Microsoft Excel Test MCQ 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). This is a formula because it starts with an equal sign (=) followed by the function SUM, which calculates the sum of the values in the range A1 to A5.

Explanation

The correct answer is =SUM(A1:A5). This is a formula because it starts with an equal sign (=) followed by the function SUM, which calculates the sum of the values in the range A1 to A5.

2. 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, create formulas, and analyze numerical information. With its ability to handle large amounts of data and perform complex calculations, Excel is commonly used in a wide range of fields such as finance, accounting, data analysis, and statistics. Therefore, the correct answer is "All of the above" as Excel can be used for calculating data, finances, and numbers.

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, create formulas, and analyze numerical information. With its ability to handle large amounts of data and perform complex calculations, Excel is commonly used in a wide range of fields such as finance, accounting, data analysis, and statistics. Therefore, the correct answer is "All of the above" as Excel can be used for calculating data, finances, and numbers.

3. Which of the following INCORRECTLY selects multiple cells?

(A1:G50)

(A1, B3:C9)

(A1:B5:C5)

(A1:B5#C5)

The answer (A1:B5#C5) incorrectly selects multiple cells because the "#" symbol is not a valid operator for selecting multiple cells in Excel. The correct operator to select multiple cells is ":" which is used to specify a range of cells.

Explanation

The answer (A1:B5#C5) incorrectly selects multiple cells because the "#" symbol is not a valid operator for selecting multiple cells in Excel. The correct operator to select multiple cells is ":" which is used to specify a range of cells.

4. 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. The ampersand is used to concatenate or join text strings together in Excel, but it cannot be used for mathematical calculations or referencing cells.

Explanation

The ampersand (&) cannot be used in an Excel spreadsheet formula. The ampersand is used to concatenate or join text strings together in Excel, but it cannot be used for mathematical calculations or referencing cells.

5. In order to add or alter a formula, under which of the following menu options can the 'function' menu be found?

Tools

File

Help

Insert

The 'function' menu can be found under the 'Insert' menu option. This menu allows users to add or alter formulas in the document or spreadsheet.

Explanation

The 'function' menu can be found under the 'Insert' menu option. This menu allows users to add or alter formulas in the document or spreadsheet.

6. 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. This allows the computer to recognize that the formula is intended to perform a calculation and not just display the text as it is. By using '=SUM', the computer knows to evaluate the formula and perform the necessary arithmetic 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. This allows the computer to recognize that the formula is intended to perform a calculation and not just display the text as it is. By using '=SUM', the computer knows to evaluate the formula and perform the necessary arithmetic operation on the specified data.

7. In order to save a new document in Microsoft Excel, you must select one of the following toolbar options?

Edit

Format

Help

File

To save a new document in Microsoft Excel, you need to select the "Format" toolbar option. This option allows you to customize the formatting of your document, including changing the font, color, and alignment of cells. The "Edit" option is used for making changes to the content of the document, the "Help" option provides assistance and guidance, and the "File" option is used for managing the file itself, such as opening, saving, and printing. Therefore, the correct option for saving a new document is "Format".

Explanation

To save a new document in Microsoft Excel, you need to select the "Format" toolbar option. This option allows you to customize the formatting of your document, including changing the font, color, and alignment of cells. The "Edit" option is used for making changes to the content of the document, the "Help" option provides assistance and guidance, and the "File" option is used for managing the file itself, such as opening, saving, and printing. Therefore, the correct option for saving a new document is "Format".