1.
Which do you press to enter the current date in a cell?
Correct Answer
B. 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.
2.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER.
3.
How do you change column width to fit the contents?
Correct Answer
B. 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.
4.
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
Correct Answer
C. 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.
5.
What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
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.
6.
In order to save a new document in Microsoft Excel you must select which one of the following tool bar options?
Correct Answer
B. Format
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.
7.
An Excel spreadsheet is primarily used for calculating which of the following options?
Correct Answer
D. All of the above
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.
8.
Which of the following option is a formula?
Correct Answer
A. =SUM(A1: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.
9.
Which one of the following options CANNOT be used in an Excel spreadsheet formula?
Correct Answer
C. & (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.
10.
What is the function of the word '=SUM' at the beginning of an Excel spreadsheet formula?
Correct Answer
D. To inform the computer that an arithmetic function will occur
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.
Which of the following INCORRECTLY selects multiple cells?
Correct Answer
D. (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.