The Microsoft Excel 2010 Quiz! Trivia

1. What appears in a cell when a column is not wide enough for its numerical contents?

??????????

##########

>>>>>>>>>>

!!!!!!!!!!

####### 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.

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.

2. When you enter a formula in Excel, what sign must go in front of the formula?

>

#

=

!

When entering formulas, you need to put an equal (=) sign in front. Otherwise, the formula will merely be text in a cell.

Explanation

When entering formulas, you need to put an equal (=) sign in front. Otherwise, the formula will merely be text in a cell.

3. Which of the following tasks can be performed with Excel?

Create a spreadsheet

Create a chart

Summarise numerical data

All of the above

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.

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.

4. Excel's Find and Replace feature can find words, numbers, and formatting.

True

False

This statement is true. You can search for information or formatting.

Explanation

This statement is true. You can search for information or formatting.

5. Pressing the control key whilst inserting a semicolon enters the current date.

True

False

To insert the current date, press CTRL+; (semi-colon).

Explanation

To insert the current date, press CTRL+; (semi-colon).

6. If you were asked to double-click something, what would you do?

Press and release the left mouse button quickly twice

Press and release the right mouse button quickly twice

Press and release the left and right mouse buttons together

Press and release the left and right mouse buttons together quickly twice

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.

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.

7. What font must be used to comply with our Standard Document Rules?

Calibri 11 point

Times New Roman 12 point

Arial 10 point

Century Gothic 10 point

Font should be Arial 10 point.

Explanation

Font should be Arial 10 point.

8. By clicking Control+Home it will take you to the cell in Column A of the current row.

True

False

This statement is false. By clicking Control+Home it will take you to the very first cell of the worksheet (A1).

Explanation

This statement is false. By clicking Control+Home it will take you to the very first cell of the worksheet (A1).

9. Headers and footers only apply to a specific worksheet, not the entire workbook.

True

False

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.

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.

10. Which of the following can be used for emphasis in all of Rollits' documents?

Bold

Underline

Block capitals

All of the above

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.

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.