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.
- 2.What is the keyboard shortcut key to lock cell references in a formula?
- A.
CTRL
- B.
ALT
- C.
F2
- D.
F4
- 3.What are the shortcut keys for AutoSum?
- A.
ALT and S
- B.
CTRL and S
- C.
ALT and =
- D.
CTRL and =
- 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
- 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
- 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"
- 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
- 8.What are the keyboard shortcut keys to edit the formula in a cell?
- A.
F2
- B.
F4
- C.
CTRL + 1
- D.
CTRL + F
- 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
- 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
Questions: 22 | Attempts: 6041 | Last updated: Dec 16, 2020
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Questions: 8 | Attempts: 3203 | Last updated: Jun 7, 2019
-
Sample QuestionThe advantage of using a spreadsheet is:
Questions: 10 | Attempts: 2902 | Last updated: Aug 17, 2020
-
Sample QuestionWhat add-in program serves as the data analyzing tool in Excel?
Back to top