Excel Test: 17-July-2014

Is this your test? Login to manage it. If not, you can create a quiz just like it.

This is a non-interactive preview of the quiz content.

1 point

Which shortcut key is used to add a Hyperlink in Excel?

Ctrl + K

Ctrl + L

Ctrl + H

Ctrl + J

1 point

Shortcut to open a workbook is___?

Ctrl + Q

Alt + Q

Ctrl + O

Alt + O

1 point

shortcut for Freeze top row is ___ ?

Alt + W + F + P

Alt + V + F + P

Alt + W + F + R

Alt + V + F + R

1 point

Shortcut for quickly create a bullet point in MS Word is__?

Ctrl + Shift + L

Ctrl + Shift + K

Ctrl + Shift + B

Ctrl + Shift + I

1 point

how to separate two words ( Text To Column)

Alt + A + S

Both of above

Alt + A + M

None of above

1 point

function for counting length of word or sentence

=COUNT

=CHAR

=LENGTH

=LEN

1 point

Ctrl + D shortcut key in Excel will

None of above

Fill down the value of upper cell in current cell

Open the font dialog box

Fill down the value of lower cell in current cell

1 point

How to remove left border from table ?

Alt + R + B + N

Alt + H + B + L

Alt + R + B + L

Alt + H + B + N

1 point

Shortcut to move the cursor at end of page is ___?

End

Ctrl + Home

Ctrl + End

Home

10.

1 point

Which of the following is incorrect____?

Both of above

None of above

Alt + W is used to close a worksheet in Excel

Ctrl + F4 is used to close a worksheet in Excel

Home Features Pricing FAQs Legal Sample Tests Build a Test Login/Sign Up