MS Excel 2007 Quiz
-
Which of the following option is a formula?
-
=SUM(A1:A5)
-
Add A1 - A5
-
Subtract the numbers from A1 to A5
-
A1 = A5
-
This MS Excel 2007 Quiz tests your ability to perform basic tasks such as entering dates, summing columns, adjusting column widths, using Format Painter, and extending number sequences. It is designed to enhance productivity skills in Excel, crucial for data management and office administration.
(187).jpg "MS Excel 2007 Quiz - Quiz")
Quiz Preview
- 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.
Correct Answer
A. Click the AutoSum button on the Standard toolbar, then press ENTER. -
- 3.
An Excel spreadsheet is primarily used for calculating which of the following options?
-
Data
-
Finances
-
Numbers
-
All of the above
Correct Answer
A. All of the aboveExplanation
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.Rate this question:
-
- 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.
Correct Answer
A. Double-click the boundary to the right of the column heading.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.Rate this question:
-
- 5.
Which of the following INCORRECTLY selects multiple cells?
-
(A1:G50)
-
(A1, B3:C9)
-
(A1:B5:C5)
-
(A1:B5#C5)
Correct Answer
A. (A1:B5#C5)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.Rate this question:
-
- 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.
Correct Answer
A. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows.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.Rate this question:
-
- 7.
Which one of the following options CANNOT be used in an Excel spreadsheet formula?
-
= (equal sign)
-
, (comma)
-
& (ampersand)
-
: (colon)
Correct Answer
A. & (ampersand)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.Rate this question:
-
- 8.
Which do you press to enter the current date in a cell?
-
CTRL+SHIFT+: (colon)
-
CTRL+; (semicolon)
-
CTRL+F10
Correct Answer
A. CTRL+; (semicolon)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.Rate this question:
-
- 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.
Correct Answer
A. Click Format Painter on the Formatting toolbar twice, then click in each cell you want to copy the formatting to.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.Rate this question:
-
- 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
Correct Answer
A. To inform the computer that an arithmetic function will occurExplanation
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.Rate this question:
-
- 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
Correct Answer
A. FormatExplanation
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.Rate this question:
-
Quiz Review Timeline (Updated): Mar 21, 2023 +
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 20, 2010Quiz Created by
Tcarryon
Back to top