facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Keyboard Shortcuts for Cell Contents Test

Free Online Microsoft Excel Tests
Excel 2010 & Excel 2013

* Shortcuts to Undo and Redo
* Shortcuts to Cut, Copy, Paste and Edit Cell Contents
* Shortcuts to Insert Comments and Hyperlinks
* Shortcuts to Insert Dates and Times
* Shortcuts to Display Cell Value or Formula


10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Excel Keyboard Shortcuts for Cell Contents Test

1) Study the screenshot of the Insert Hyperlink dialogue box below this question.  Hyperlinks allow you to link contents in one document to another document, worksheet, webpage or other element for ease of reference.  Which of the following is a quick way of inserting a hyperlink?
a) By pressing Ctrl+h.
b) By pressing Ctrl+Shift+h.
c) By pressing Ctrl+y.
d) By pressing Ctrl+k.
Question 1 - Microsoft Excel Tests -
            Keyboard Shortcuts for Cell Contents Test

2) If you are creating a time log or any worksheet where you frequently need to type in the current date, there is a really quick and easy way to do this.  Which of the following shortcuts will insert today's date in a cell?
a) Pressing Ctrl+d will insert the date.
b) Pressing Ctrl+; will insert the date.
c) Pressing Ctrl+Shift+; will insert the date.
d) Typing "'date" and pressing "enter" will insert the date.

3) Study the screenshot of a section of a worksheet in Excel below.  The box pointing to cell C:9 is called a comment.  You can insert comments in a Worksheet to review your own work or to provide feedback for colleagues.  Which of the following is a shortcut for inserting a comment on a selected cell or cells?
a) Pressing Shift+F2 and typing your comment.
b) Pressing Ctrl+Shift+F2 and typing your comment.
c) Double clicking a cell, then pressing F2 and typing your comment.
d) Pressing Ctrl+c and typing your comment.
Question 3 - Microsoft Excel Tests -
            Keyboard Shortcuts for Cell Contents Test

4) Study the formula in the Formula Bar in the screenshot below this question. What will the cell containing this formula display when printed or viewed?
a) It will display the result of the formula.
b) It will display an error message.
c) It will display:  =IF(B10>500,F35*0.25,F35*0.5)
d) It is impossible to ascertain what it will display by looking at the Formula Bar.
Question 4 - Microsoft Excel Tests -
            Keyboard Shortcuts for Cell Contents Test

5) What is a quick way of viewing all the formulas contained in a worksheet?
a) Press Ctrl+` (the grave symbol).
b) Press Ctrl+s.
c) Select the whole worksheet and press Ctrl+Shift+'.
d) All of the above options are correct.



6) Data entry can be a time consuming activity.  Oftentimes you may find yourself needing to insert data from one worksheet into another. Which of the following options best represents the shortcut sequence to use to copy and paste content from one spreadsheet (or document) into a selected cell in a different location?
a) Press Ctrl+x, select cell or cells to paste content into, press Ctr+p.
b) Press Ctrl+c and then press Ctrl+v.
c) Select content to copy, press Ctrl+c, select cell or cells to paste content into, press Ctrl+v.
d) Select content to copy, press Ctrl+c, select cell or cells to paste content into, press Ctrl+p.

7) Which of the following shortcut key combinations do you expect to usually press after pressing Ctrl+x?
a) Ctrl+z.
b) Ctrl+v.
c) Ctrl+c.
d) Ctrl+p.

8) Paris is creating a time sheet to log the time her colleague, Lauren, spends on smoke breaks so she can report on it to HR.  Study the screenshot of her worksheet below this question.  Which of the following shortcut combinations will allow her to quickly enter the start and end time of each break her colleague takes?
a) Pressing Ctrl+s and Ctrl+f in the Time Start and Time End columns.
b) Pressing Ctrl+; in the Time Start and Time End columns.
c) Pressing Ctrl+Shift+; in the Time Start and Time End columns.
d) Pressing Ctrl+Shift+t in the Time Start and Time End columns.
Question 8 - Microsoft Excel Tests -
            Keyboard Shortcuts for Cell Contents Test

9) How do you add a line/paragraph break within the same cell in a worksheet? 
a) Press Enter in the cell to add a new line.
b) Press Alt+Enter in the cell to add a new line.
c) Press Ctrl+Enter in the cell to add a new line.
d) Press Ctrl+Alt+Enter in the cell to add a new line.

10) What does the shortcut Ctrl+r achieve?
a) It formats the selected cell.
b) It repeats the last action (redo).
c) It inserts the current date.
d) It creates a copy of the cell contents from the left.