Microsoft Excel Test MCQ Quiz!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Jeremystiffler
J
Jeremystiffler
Community Contributor
Quizzes Created: 3 | Total Attempts: 5,488
| Attempts: 4,157
SettingsSettings
Please wait...
  • 1/7 Questions

    Which of the following option is a formula?

    • =SUM(A1:A5)
    • Add A1 - A5
    • Subtract the numbers from A1 to A5
    • A1 = A5
Please wait...
About This Quiz

This Microsoft Excel MCQ Quiz tests your knowledge on functions, formulas, and cell operations in Excel spreadsheets.

Microsoft Excel Test MCQ Quiz! - Quiz

Quiz Preview

  • 2. 

    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 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 INCORRECTLY selects multiple cells?

    • (A1:G50)

    • (A1, B3:C9)

    • (A1:B5:C5)

    • (A1:B5#C5)

    Correct Answer
    A. (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:

  • 4. 

    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. 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. 

    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

    Correct Answer
    A. 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:

  • 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

    Correct Answer
    A. 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:

  • 7. 

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

    • Edit

    • Format

    • Help

    • File

    Correct Answer
    A. 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:

Quiz Review Timeline (Updated): Mar 22, 2023 +

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.