# The Microsoft Excel 2010 Quiz! Trivia

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
Learn about Our Editorial Process
| Written by SamGl
S
SamGl
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,105
Questions: 10 | Attempts: 1,105

Settings

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!

Questions and Answers
• 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 above
Explanation
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. False
Explanation
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 point
Explanation
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 twice
Explanation
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. True
Explanation
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. Bold
Explanation
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. True
Explanation
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. True
Explanation
This statement is true. You can search for information or formatting.

Rate this question:

Related Topics

Back to top
×

Wait!
Here's an interesting quiz for you.