Could You Pass The MS Excel Assessment Trivia Quiz?

1. What are the shortcut keys to insert a new row in an Excel spreadsheet?

ALT + H + I + R

ALT + H + I + C

ALT + H + I + I

ALT + H + I + S

The correct answer is ALT + H + I + R. This key combination is used to insert a new row in an Excel spreadsheet.

Explanation

The correct answer is ALT + H + I + R. This key combination is used to insert a new row in an Excel spreadsheet.

2. What is the keyboard shortcut key to lock cell references in a formula?

CTRL

ALT

F2

F4

The keyboard shortcut key to lock cell references in a formula is F4. Pressing F4 toggles between different types of cell references, such as absolute, relative, and mixed references. This allows users to easily adjust and fix the references in their formulas without manually typing the dollar sign ($) or selecting the cells.

Explanation

The keyboard shortcut key to lock cell references in a formula is F4. Pressing F4 toggles between different types of cell references, such as absolute, relative, and mixed references. This allows users to easily adjust and fix the references in their formulas without manually typing the dollar sign ($) or selecting the cells.

3. What are the shortcut keys for AutoSum?

ALT and S

CTRL and S

ALT and =

CTRL and =

The shortcut keys for AutoSum are ALT and =. This combination allows users to quickly insert the AutoSum function in a selected range of cells in Microsoft Excel. By pressing ALT and = together, Excel automatically selects the adjacent range of cells and inserts the SUM function, saving time and effort for users.

Explanation

The shortcut keys for AutoSum are ALT and =. This combination allows users to quickly insert the AutoSum function in a selected range of cells in Microsoft Excel. By pressing ALT and = together, Excel automatically selects the adjacent range of cells and inserts the SUM function, saving time and effort for users.

4. What are the keyboard shortcut keys to edit the formula in a cell?

F2

F4

CTRL + 1

CTRL + F

The keyboard shortcut key "F2" is used to edit the formula in a cell.

Explanation

The keyboard shortcut key "F2" is used to edit the formula in a cell.

5. How do you spell check an Excel worksheet?

Under the Tools menu, click Spelling.

Press F7.

Click the button with ABC Check Mark icon.

Any of the above will perform a spell check.

The question asks for the method to spell check an Excel worksheet. The correct answer states that any of the options provided will perform a spell check. This means that the user can either go to the Tools menu and click on Spelling, press F7 on the keyboard, or click on the button with the ABC Check Mark icon to initiate the spell check process. All three options will achieve the same result of spell checking the worksheet.

Explanation

The question asks for the method to spell check an Excel worksheet. The correct answer states that any of the options provided will perform a spell check. This means that the user can either go to the Tools menu and click on Spelling, press F7 on the keyboard, or click on the button with the ABC Check Mark icon to initiate the spell check process. All three options will achieve the same result of spell checking the worksheet.

6. What are the keyboard shortcut keys to paste special?

ALT + H + V + F

ALT + H + V + P

ALT + H + V + O

ALT + H + V + S

The keyboard shortcut keys to paste special are ALT + H + V + S.

Explanation

The keyboard shortcut keys to paste special are ALT + H + V + S.

7. What are the shortcut keys to group rows so you can expand/contract a section of data?

ALT + A + U + U

ALT + A + W + G

ALT + A + G + G

ALT + A + B

The correct answer is ALT + A + G + G. This shortcut is used to group rows in order to expand or contract a section of data. By selecting the desired rows and pressing these keys, the rows will be grouped together and can be easily expanded or collapsed.

Explanation

The correct answer is ALT + A + G + G. This shortcut is used to group rows in order to expand or contract a section of data. By selecting the desired rows and pressing these keys, the rows will be grouped together and can be easily expanded or collapsed.

8. Which of the following features cannot be found in the Data ribbon?

What-If Analysis

PivotTable

Data Validation

Text to Columns

The PivotTable feature cannot be found in the Data ribbon. PivotTable is a powerful data analysis tool that allows users to summarize and analyze large amounts of data in a flexible and interactive way. It is typically found in the Insert tab or in the Analyze tab of the Excel ribbon.

Explanation

The PivotTable feature cannot be found in the Data ribbon. PivotTable is a powerful data analysis tool that allows users to summarize and analyze large amounts of data in a flexible and interactive way. It is typically found in the Insert tab or in the Analyze tab of the Excel ribbon.

9. What are the shortcut keys to open up the Find and Replace window?

ALT + H + FD + R

CTRL + F

ALT + H + R

ALT + H + FD + F

The shortcut keys to open up the Find and Replace window are ALT + H + FD + R.

Explanation

The shortcut keys to open up the Find and Replace window are ALT + H + FD + R.

10. What formula should be entered in cell A3 to display the results as shown below?

="Income Statement"&A1

="Income Statement "&A1

="Income Statement "+A1

="Income Statement "&"A1"

The correct formula to display the results as shown below is "= "Income Statement" & A1". This formula uses the ampersand (&) operator to concatenate the text "Income Statement" with the content of cell A1. The result will be "Income Statement" followed by the value in cell A1.

Explanation

The correct formula to display the results as shown below is "= "Income Statement" & A1". This formula uses the ampersand (&) operator to concatenate the text "Income Statement" with the content of cell A1. The result will be "Income Statement" followed by the value in cell A1.