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
J
Jeremystiffler
Community Contributor
Quizzes Created: 3 | Total Attempts: 5,389
Questions: 7 | Attempts: 4,138

SettingsSettingsSettings
Microsoft Excel Test MCQ Quiz! - Quiz

.


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:

  • 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:

  • 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:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.