facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Keyboard Shortcuts for Formulas Test

Free Online Microsoft Excel Tests
Excel 2010 & Excel 2013

* Shortcuts for Autosum
* Shortcuts for Copy Formulas Down
* Shortcuts for Insert Functions, Formulas & Arguments
* Shortcuts for Array Formulas
* Shortcuts for Calculate the Worksheet
* Shortcuts for show/ hide formulas
* Shortcuts for Absolute References


10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Keyboard Shortcuts for Formulas Test

1) Study the screenshot of an Excel worksheet below this question.  What will the result be if you press the shortcut combination: Alt+= in cell B5 (the yellow highlighted cell in the screenshot)?
a) It will add an array formula to the cell.
b) It will add the Sum formula to the cell.
c) It will insert a new cell below the highlighted cell.
d) It will insert a new line in the highlighted cell.
Microsoft Excel Test - Keyboard Shortcuts for Formulas - Question 1
2) Study the screenshot of the Function Arguments dialogue box below this question.  Which of the following is the shortcut combination for launching this dialogue box?
a) Pressing Shift+F3 will launch the Function Arguments dialogue box.
b) Pressing Ctrl+a after typing the name of the formula will launch the Function Arguments dialogue box.
c) Pressing Ctrl+f after typing the name of the formula will launch the Function Arguments dialogue box.
d) Pressing Ctrl+Shift+Enter after typing the name of the formula will launch the Function Arguments dialogue box.
Microsoft Excel Test - Keyboard Shortcuts for Formulas - Question 2
3) Which of the following options best describe what the shortcut combination Shift+F3 accomplishes?
a) It inserts the Autosum formula into a selected cell.
b) It launches the Function Arguments dialogue box.
c) It launches the Insert Function dialogue box.
d) It launches the Select Formula dialogue box.

4) Lauren needs to create a very complex nested formula. Unfortunately, she does not have all the data that is going to be included in the arguments yet.  Is there a way for her to insert the formula with the arguments automatically displayed as placeholders?
a) After typing the name of the formula, for example =IF(, if she presses Ctrl+Shift+a, the formula arguments will be inserted in the cell.
b) After typing the name of the formula, for example =IF(, if she presses Ctr+Shift+F, the formula arguments will be inserted in the cell.
c) After typing the name of the formula, for example =IF(, if she presses Ctrl+a, the formula arguments will be inserted in the cell.
d) This is not possible.  She will have to leave the cell blank until she has all the data for all the arguments in her formula.

5) Study the screenshot of a Price List below this question.  To calculate the value for the highlighted block (Total for Products Sold), one would have to multiply each item in the Selling Price column with the Number Sold column and then total that up to get an answer.  However, there is a quicker way.  Which of the following solutions when entered in the highlighted box, will give the correct total?
a) By entering =SUM(C4:C32*D4:D32) and pressing enter.
b) By entering =(C4:C32*D4:D32) and pressing Alt+=.
c) By entering =C4*D4 and pressing Ctrl+Shift+Enter.
d) By entering =SUM(C4:C32*D4:D32) and pressing Ctrl+Shift+Enter.
Microsoft Excel Test - Keyboard Shortcuts for Formulas - Question 5

6) To ensure a cell reference becomes absolute and does not change when more rows or columns are added or if the cell containing the referenced value is moved, you need to:
a) Type the cell reference and press Ctrl+Shift+Enter to make the reference absolute.
b) Type the cell reference and press Ctrl+a to make the reference absolute.
c) Type the cell reference and press Ctrl+Shift+F4 to make the reference absolute.
d) Type the cell reference and press F4 to make the reference absolute.

7) What will happen to all your worksheets in your current open workbook when you press F9?
a) The workbook will automatically be saved.
b) All formulas will automatically be calculated.
c) All cell references will become absolute.
d) None of the above options are correct.

8) Stacey has taken over a worksheet from a colleague. She wants to quickly see all the formulas that are present in the worksheet to better understand the data.  Which shortcut combination can she use to achieve this?
a) Pressing Ctrl+` (grave symbol) will display all formulas instead of their values.
b) Pressing Ctrl+Shift+' (apostrophe) will display all formulas instead of their values. 
c) Pressing Ctrl+Shift+a will display all formulas instead of their values.
d) Pressing Shift+' (apostrophe) will display all formulas instead of their values.

9) Study the screenshot below this question. To calculate the Total Income column we need to Sum the Sales and Profit values for each row.  With the cells in which we want the totals for each row to appear selected (Column H), which of the following actions will ensure the formula entered (see screenshot below) gets copied into each cell?
a) Pressing Ctrl+Shift+Enter, will copy the formula down.
b) Pressing Ctrl+Alt+' will copy the formula down.
c) Pressing Ctrl+Enter will copy the formula down.
d) Pressing Alt+Enter will copy the formula down.
Microsoft Excel Test - Keyboard Shortcuts for Formulas - Question 9

10) Which of the following shortcuts allow you to calculate the formulas and functions only in the worksheet that you are currently working in (i.e. the active sheet)?
a) Pressing Ctrl+F9 will calculate only the active worksheet.
b) Pressing Shift+F9 will calculate only the active worksheet.
c) Pressing Ctrl+Shift+F9 will calculate only the active worksheet.
d) Pressing F9 will calculate only the active worksheet.