11kazen Quiz - Excel Math Formulas

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 Gbriseno
G
Gbriseno
Community Contributor
Quizzes Created: 15 | Total Attempts: 6,887
Questions: 7 | Attempts: 279

SettingsSettingsSettings
Microsoft Excel Quizzes & Trivia

This quiz is a measurement of your knowledge of the software called Excel. Please use the software to answer any of the questions that are on this quiz.


Questions and Answers
  • 1. 

    Which of the following formulas is used to ADD "two" cells together?

    • A.

      =sum(cell+cell)

    • B.

      =cell+cell

    • C.

      =sum(cell/cell)

    • D.

      =cell/cell

    Correct Answer
    B. =cell+cell
    Explanation
    The correct answer is =cell+cell. This formula is used to add two cells together in a spreadsheet. The plus sign (+) between the two cells indicates the addition operation, and the formula will calculate the sum of the values in the two cells.

    Rate this question:

  • 2. 

    Which of the following formulas is used twith the "AutoSum" feature?

    • A.

      =cell+cell

    • B.

      =cell*cell

    • C.

      =sum(cell:cell)

    • D.

      =cell/cell

    Correct Answer
    C. =sum(cell:cell)
    Explanation
    The "AutoSum" feature in Excel is used to quickly calculate the sum of a range of cells. The formula "=sum(cell:cell)" is the correct answer because it uses the "sum" function to add up the values in the specified range of cells.

    Rate this question:

  • 3. 

    Which of the following formulas is used to "multiply" cells together?

    • A.

      =cell*cell

    • B.

      =cell+cell

    • C.

      =cell/cell

    • D.

      =cell-cell

    Correct Answer
    A. =cell*cell
    Explanation
    The correct answer is =cell*cell. This formula is used to multiply the values of two cells together. The asterisk (*) symbol represents multiplication in Excel. So, when this formula is used, it will multiply the value in the first cell with the value in the second cell, giving the result of their multiplication.

    Rate this question:

  • 4. 

    The formula (=cell/cell) is used to divide cells in Excel.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The formula (=cell/cell) is used to divide cells in Excel. This formula is commonly used to perform mathematical calculations by dividing the value of one cell by another cell. It allows users to create dynamic formulas that update automatically when the values in the referenced cells change. By using this formula, users can easily perform division operations and manipulate data in Excel spreadsheets.

    Rate this question:

  • 5. 

    The formula (=cell-cell) is used to multiply two cells together.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The formula (=cell-cell) is not used to multiply two cells together. The correct formula to multiply two cells is =cell*cell. Therefore, the given statement is false.

    Rate this question:

  • 6. 

    The software Excel is used as a tool to help businesses create financial reports and to do payroll and keep track of inventory. What type of software is this considered?

    • A.

      Spreadsheet

    • B.

      Word document

    • C.

      Presentation

    • D.

      Email

    Correct Answer
    A. Spreadsheet
    Explanation
    Excel is considered a spreadsheet software because it is specifically designed to create and manage spreadsheets. It provides features such as formulas, functions, and formatting options that are essential for organizing and analyzing data. While word document software is used for creating and editing text documents, presentation software is used for creating slideshows, and email software is used for sending and receiving emails, none of these options are designed for the same purpose as Excel. Therefore, spreadsheet is the correct answer.

    Rate this question:

  • 7. 

    Excel can be used to create bar graphs and charts for use in powerpoint presentations.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Excel is a powerful tool that allows users to create various types of graphs and charts, including bar graphs. These visual representations of data are commonly used in PowerPoint presentations to enhance the audience's understanding and engagement. By using Excel to create bar graphs and charts, users can easily import them into PowerPoint and seamlessly integrate them into their presentations. Therefore, the statement that Excel can be used to create bar graphs and charts for use in PowerPoint presentations is true.

    Rate this question:

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
  • Oct 08, 2010
    Quiz Created by
    Gbriseno
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.