Could You Pass The MS Excel Assessment Trivia Quiz?
Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for calculation, pivot tables, and numerous graphing tools. This quiz has been designed to test your knowledge about the shortcuts and functions used in Excel. Lets' start off! All the best!
- 1.
How do you spell check an Excel worksheet?
- A.
Under the Tools menu, click Spelling.
- B.
Press F7.
- C.
Click the button with ABC Check Mark icon.
- D.
Any of the above will perform a spell check.
Correct Answer
D. Any of the above will perform a spell check.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.Rate this question:
-
- 2.
What is the keyboard shortcut key to lock cell references in a formula?
- A.
CTRL
- B.
ALT
- C.
F2
- D.
F4
Correct Answer
D. F4Explanation
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.Rate this question:
-
- 3.
What are the shortcut keys for AutoSum?
- A.
ALT and S
- B.
CTRL and S
- C.
ALT and =
- D.
CTRL and =
Correct Answer
C. ALT and =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.Rate this question:
-
- 4.
What are the shortcut keys to insert a new row in an Excel spreadsheet?
- A.
ALT + H + I + R
- B.
ALT + H + I + C
- C.
ALT + H + I + I
- D.
ALT + H + I + S
Correct Answer
A. ALT + H + I + RExplanation
The correct answer is ALT + H + I + R. This key combination is used to insert a new row in an Excel spreadsheet.Rate this question:
-
- 5.
What are the shortcut keys to group rows so you can expand/contract a section of data?
- A.
ALT + A + U + U
- B.
ALT + A + W + G
- C.
ALT + A + G + G
- D.
ALT + A + B
Correct Answer
C. ALT + A + G + GExplanation
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.Rate this question:
-
- 6.
What formula should be entered in cell A3 to display the results as shown below?
- A.
="Income Statement"&A1
- B.
="Income Statement "&A1
- C.
="Income Statement "+A1
- D.
="Income Statement "&"A1"
Correct Answer
B. ="Income Statement "&A1Explanation
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.Rate this question:
-
- 7.
What are the keyboard shortcut keys to paste special?
- A.
ALT + H + V + F
- B.
ALT + H + V + P
- C.
ALT + H + V + O
- D.
ALT + H + V + S
Correct Answer
D. ALT + H + V + SExplanation
The keyboard shortcut keys to paste special are ALT + H + V + S.Rate this question:
-
- 8.
What are the keyboard shortcut keys to edit the formula in a cell?
- A.
F2
- B.
F4
- C.
CTRL + 1
- D.
CTRL + F
Correct Answer
A. F2Explanation
The keyboard shortcut key "F2" is used to edit the formula in a cell.Rate this question:
-
- 9.
Which of the following features cannot be found in the Data ribbon?
- A.
What-If Analysis
- B.
PivotTable
- C.
Data Validation
- D.
Text to Columns
Correct Answer
B. PivotTableExplanation
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.Rate this question:
-
- 10.
What are the shortcut keys to open up the Find and Replace window?
- A.
ALT + H + FD + R
- B.
CTRL + F
- C.
ALT + H + R
- D.
ALT + H + FD + F
Correct Answer
A. ALT + H + FD + RExplanation
The shortcut keys to open up the Find and Replace window are ALT + H + FD + R.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Aug 17, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 06, 2008Quiz Created by
Nwhitehe
Back to top