The Microsoft Excel 2010 Quiz! Trivia
(95).jpg "The Microsoft Excel 2010 Quiz! Trivia")
Are you ready to test your Microsoft Excel 2010 knowledge? There is so much that one can do when they understand how to use spreadsheets correctly. Is it possible to have a header and footer on a spreadsheet, and what is the right way of writing formulas on a set of data? This quiz is perfect for those of you who have a hard time when it comes to using this Microsoft Tool. Check it out!
- 1.Which of the following tasks can be performed with Excel?
- A.
Create a spreadsheet
- B.
Create a chart
- C.
Summarise numerical data
- D.
All of the above
- 2.By clicking Control+Home it will take you to the cell in Column A of the current row.
- A.
True
- B.
False
- 3.What font must be used to comply with our Standard Document Rules?
- A.
Calibri 11 point
- B.
Times New Roman 12 point
- C.
Arial 10 point
- D.
Century Gothic 10 point
- 4.If you were asked to double-click something, what would you do?
- A.
Press and release the left mouse button quickly twice
- B.
Press and release the right mouse button quickly twice
- C.
Press and release the left and right mouse buttons together
- D.
Press and release the left and right mouse buttons together quickly twice
- 5.Headers and footers only apply to a specific worksheet, not the entire workbook.
- A.
True
- B.
False
- 6.What appears in a cell when a column is not wide enough for its numerical contents?
- A.
??????????
- B.
##########
- C.
>>>>>>>>>>
- D.
!!!!!!!!!!
- 7.Which of the following can be used for emphasis in all of Rollits' documents?
- A.
Bold
- B.
Underline
- C.
Block capitals
- D.
All of the above
- 8.Pressing the control key whilst inserting a semicolon enters the current date.
- A.
True
- B.
False
- 9.When you enter a formula in Excel, what sign must go in front of the formula?
- A.
>
- B.
#
- C.
=
- D.
!
- 10.Excel's Find and Replace feature can find words, numbers, and formatting.
- A.
True
- B.
False
Questions: 25 | Attempts: 20299 | Last updated: May 26, 2021
-
Sample QuestionWhich formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Questions: 5 | Attempts: 9590 | Last updated: Sep 24, 2020
-
Sample QuestionWhat is a Backstage View in Microsoft Excel 2013?
Questions: 20 | Attempts: 8186 | Last updated: Apr 21, 2020
-
Sample QuestionWhat is wrong with this formula? =IF(D3=<90,"A-",0)
Back to top