MS Excel 2007 Quiz

1. Which of the following option is a formula?

=SUM(A1:A5)

Add A1 - A5

Subtract the numbers from A1 to A5

A1 = A5

The correct answer is "=SUM(A1:A5)" because it follows the syntax of a formula in Excel. The equal sign indicates that it is a formula, and the "SUM" function is used to add the values in the range A1 to A5.

Explanation

The correct answer is "=SUM(A1:A5)" because it follows the syntax of a formula in Excel. The equal sign indicates that it is a formula, and the "SUM" function is used to add the values in the range A1 to A5.

2. A fast way to add up this column of numbers is to click in the cell below the numbers and then:

Click Subtotals on the Data menu.

View the sum in the formula bar.

Click the AutoSum button on the Standard toolbar, then press ENTER.

not-available-via-ai

Explanation

not-available-via-ai

3. An Excel spreadsheet is primarily used for calculating which of the following options?

Data

Finances

Numbers

All of the above

An Excel spreadsheet is primarily used for calculating data, finances, and numbers. It is a versatile tool that allows users to perform various calculations and analysis on different types of information. With its built-in formulas and functions, Excel can handle complex calculations, budgeting, financial analysis, statistical analysis, and much more. Therefore, the correct answer is "All of the above" as Excel can be used for all these purposes.

Explanation

An Excel spreadsheet is primarily used for calculating data, finances, and numbers. It is a versatile tool that allows users to perform various calculations and analysis on different types of information. With its built-in formulas and functions, Excel can handle complex calculations, budgeting, financial analysis, statistical analysis, and much more. Therefore, the correct answer is "All of the above" as Excel can be used for all these purposes.

4. How do you change column width to fit the contents?

Single-click the boundary to the left of the column heading.

Double-click the boundary to the right of the column heading.

Press ALT and single-click anywhere in the column.

To change the column width to fit the contents, you need to double-click the boundary to the right of the column heading. This action will automatically adjust the width of the column to fit the widest content within it.

Explanation

To change the column width to fit the contents, you need to double-click the boundary to the right of the column heading. This action will automatically adjust the width of the column to fit the widest content within it.

5. Which of the following INCORRECTLY selects multiple cells?

(A1:G50)

(A1, B3:C9)

(A1:B5:C5)

(A1:B5#C5)

The correct answer is (A1:B5#C5) because it incorrectly selects multiple cells. The correct way to select multiple cells is by using a colon (:) to indicate a range of cells, or by using a comma (,) to separate individual cells or ranges. In this case, (A1:B5#C5) is incorrect because it uses the hashtag (#) symbol, which is not a valid way to select multiple cells.

Explanation

The correct answer is (A1:B5#C5) because it incorrectly selects multiple cells. The correct way to select multiple cells is by using a colon (:) to indicate a range of cells, or by using a comma (,) to separate individual cells or ranges. In this case, (A1:B5#C5) is incorrect because it uses the hashtag (#) symbol, which is not a valid way to select multiple cells.

6. What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows.

Select the range you want, including both cells, point to Fill on the Edit menu, and then click Down.

Copy the second cell, click in the cell below it, on the Standard toolbar click the down arrow on the Paste button, and then click Paste Special.

To extend the numbers to a longer sequence, you can select both cells and then drag the fill handle over the range you want. This will automatically fill in the remaining numbers in the sequence. For example, if you select cells with the numbers 1 and 2, and then drag the fill handle down 18 more rows, it will fill in the numbers 3 to 20 in the sequence.

Explanation

To extend the numbers to a longer sequence, you can select both cells and then drag the fill handle over the range you want. This will automatically fill in the remaining numbers in the sequence. For example, if you select cells with the numbers 1 and 2, and then drag the fill handle down 18 more rows, it will fill in the numbers 3 to 20 in the sequence.

7. Which one of the following options CANNOT be used in an Excel spreadsheet formula?

= (equal sign)

, (comma)

& (ampersand)

: (colon)

The ampersand (&) cannot be used in an Excel spreadsheet formula. In Excel, the ampersand is used as a concatenation operator to join text strings together. It is not a valid mathematical operator or function that can be used in a formula to perform calculations.

Explanation

The ampersand (&) cannot be used in an Excel spreadsheet formula. In Excel, the ampersand is used as a concatenation operator to join text strings together. It is not a valid mathematical operator or function that can be used in a formula to perform calculations.

8. Which do you press to enter the current date in a cell?

CTRL+SHIFT+: (colon)

CTRL+; (semicolon)

CTRL+F10

To enter the current date in a cell, you would press CTRL+; (semicolon). This keyboard shortcut inserts the current date into the selected cell.

Explanation

To enter the current date in a cell, you would press CTRL+; (semicolon). This keyboard shortcut inserts the current date into the selected cell.

9. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

Use CTRL to select all three cells, then click the Paste button on the Standard toolbar

Copy the selected cell, then select the other two cells, click Style on the Format menu, then click Modify

Click Format Painter on the Formatting toolbar twice, then click in each cell you want to copy the formatting to.

The correct answer suggests that to copy formatting from a selected cell to two other cells on the same worksheet, you need to click on the Format Painter button on the Formatting toolbar twice. After that, you click in each cell where you want to copy the formatting to. This action will copy the formatting from the selected cell to the other two cells.

Explanation

The correct answer suggests that to copy formatting from a selected cell to two other cells on the same worksheet, you need to click on the Format Painter button on the Formatting toolbar twice. After that, you click in each cell where you want to copy the formatting to. This action will copy the formatting from the selected cell to the other two cells.

10. What is the function of the word '=SUM' at the beginning of an Excel spreadsheet formula?

To add all the data together using addition only

To tell the person viewing that this is a function and it should be added together

To calculate all the data correctly without any mistakes

To inform the computer that an arithmetic function will occur

The function of the word '=SUM' at the beginning of an Excel spreadsheet formula is to inform the computer that an arithmetic function will occur. The '=SUM' indicates that the following values or cells should be added together. It is a signal to the computer to perform the addition operation on the specified data.

Explanation

The function of the word '=SUM' at the beginning of an Excel spreadsheet formula is to inform the computer that an arithmetic function will occur. The '=SUM' indicates that the following values or cells should be added together. It is a signal to the computer to perform the addition operation on the specified data.

11. In order to save a new document in Microsoft Excel you must select which one of the following tool bar options?

Edit

Format

Help

File

To save a new document in Microsoft Excel, you must select the "Format" toolbar option. This option allows you to customize the formatting of the document, such as changing the font, color, and alignment of the text. By selecting this option, you can access the "Save" or "Save As" function to save the document to a desired location on your computer or cloud storage.

Explanation

To save a new document in Microsoft Excel, you must select the "Format" toolbar option. This option allows you to customize the formatting of the document, such as changing the font, color, and alignment of the text. By selecting this option, you can access the "Save" or "Save As" function to save the document to a desired location on your computer or cloud storage.