Microsoft Excel Test MCQ Quiz!

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Jeremystiffler

Jeremystiffler

Community Contributor

Quizzes Created: 3 | Total Attempts: 5,394

Questions: 7 | Attempts: 4,139 | Updated: Mar 22, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Questions and Answers

1.

In order to save a new document in Microsoft Excel, you must select one of the following toolbar options?
- A.
  
  Edit
- B.
  
  Format
- C.
  
  Help
- D.
  
  File
Correct Answer
B. 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".

Rate this question:

1
0
2.

An Excel spreadsheet is primarily used for calculating which of the following options?
- A.
  
  Data
- B.
  
  Finances
- C.
  
  Numbers
- D.
  
  All of the above
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, 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.

Rate this question:
3.

Which of the following option is a formula?
- A.
  
  =SUM(A1:A5)
- B.
  
  Add A1 - A5
- C.
  
  Subtract the numbers from A1 to A5
- D.
  
  A1 = A5
Correct Answer
A. =SUM(A1: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.

Rate this question:
4.

Which one of the following options CANNOT be used in an Excel spreadsheet formula?
- A.
  
  = (equal sign)
- B.
  
  , (comma)
- C.
  
  & (ampersand)
- D.
  
  : (colon)
Correct Answer
C. & (ampersand)

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.

Rate this question:
5.

What is the function of the word '=SUM' at the beginning of an Excel spreadsheet formula?
- A.
  
  To add all the data together using addition only
- B.
  
  To tell the person viewing that this is a function and it should be added together
- C.
  
  To calculate all the data correctly without any mistakes
- D.
  
  To inform the computer that an arithmetic function will occur
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. 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.

Rate this question:
6.

Which of the following INCORRECTLY selects multiple cells?
- A.
  
  (A1:G50)
- B.
  
  (A1, B3:C9)
- C.
  
  (A1:B5:C5)
- D.
  
  (A1:B5#C5)
Correct Answer
D. (A1:B5#C5)

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.

Rate this question:

2
0
7.

In order to add or alter a formula, under which of the following menu options can the 'function' menu be found?
- A.
  
  Tools
- B.
  
  File
- C.
  
  Help
- D.
  
  Insert
Correct Answer
D. Insert

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.

Rate this question:

1
0

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 22, 2023

Quiz Edited by
ProProfs Editorial Team
Jul 30, 2008

Quiz Created by
Jeremystiffler

Microsoft Excel Test MCQ Quiz!

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

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

Which of the following option is a formula?

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

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

Which of the following INCORRECTLY selects multiple cells?

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