The Microsoft Excel 2010 Quiz! Trivia
(95).jpg "The Microsoft Excel 2010 Quiz! Trivia - Quiz")
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
Correct Answer
D. All of the aboveExplanation
Excel is a powerful spreadsheet software that allows users to create spreadsheets, charts, and summarize numerical data. With Excel, users can organize and analyze data by creating spreadsheets, which are tables that store data in rows and columns. Additionally, Excel offers various chart types that can be used to visually represent data. Lastly, Excel provides functions and formulas that enable users to calculate and summarize numerical data, making it a versatile tool for data analysis. Therefore, all of the given tasks can be performed with Excel.Rate this question:
-
- 2.
By clicking Control+Home it will take you to the cell in Column A of the current row.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
This statement is false. By clicking Control+Home it will take you to the very first cell of the worksheet (A1).Rate this question:
-
- 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
Correct Answer
C. Arial 10 pointExplanation
Font should be Arial 10 point.Rate this question:
-
- 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
Correct Answer
A. Press and release the left mouse button quickly twiceExplanation
To double-click something, you need to press and release the left mouse button quickly twice. This action is commonly used to open files, folders, or launch applications on a computer. By quickly clicking the left mouse button twice, you are indicating to the computer that you want to perform a double-click action, which triggers the corresponding function associated with the item you are clicking on.Rate this question:
-
- 5.
Headers and footers only apply to a specific worksheet, not the entire workbook.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Headers and footers typically appear on every page of a report. In Excel 2010, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to identify the document and to display the page numbers. Unless you specify otherwise, Excel does not automatically add either a header or footer to a new workbook.Rate this question:
-
- 6.
What appears in a cell when a column is not wide enough for its numerical contents?
- A.
??????????
- B.
##########
- C.
>>>>>>>>>>
- D.
!!!!!!!!!!
Correct Answer
B. ##########Explanation
####### appears if the cell is too narrow to display the numerical contents. To widen the column exactly enough to hold the longest entry in it: Double-click the divider between the column headers or choose Home→Cells→Format→AutoFit Column Width. To widen the column manually: Drag the divider between the column headers.Rate this question:
-
- 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
Correct Answer
A. BoldExplanation
Emphasis is to be given by bold typeface. Underlining and block capitals should never be used anywhere in documents. Italics may be used in draft documents.Rate this question:
-
- 8.
Pressing the control key whilst inserting a semicolon enters the current date.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
To insert the current date, press CTRL+; (semi-colon).Rate this question:
-
- 9.
When you enter a formula in Excel, what sign must go in front of the formula?
- A.
>
- B.
#
- C.
=
- D.
!
Correct Answer
C. =Explanation
When entering formulas, you need to put an equal (=) sign in front. Otherwise, the formula will merely be text in a cell.Rate this question:
-
- 10.
Excel's Find and Replace feature can find words, numbers, and formatting.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
This statement is true. You can search for information or formatting.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
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 19, 2013Quiz Created by
SamGl
Back to top