11kazen Quiz - Excel Math Formulas

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 Gbriseno
G
Gbriseno
Community Contributor
Quizzes Created: 15 | Total Attempts: 6,997
| Attempts: 293
SettingsSettings
Please wait...
  • 1/7 Questions

    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?

    • Spreadsheet
    • Word document
    • Presentation
    • Email
Please wait...
About This Quiz

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.

Spreadsheet Quizzes & Trivia

Quiz Preview

  • 2. 

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

    • =cell*cell

    • =cell+cell

    • =cell/cell

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

  • 3. 

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

    • True

    • False

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

  • 4. 

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

    • True

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

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

    • =cell+cell

    • =cell*cell

    • =sum(cell:cell)

    • =cell/cell

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

  • 6. 

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

    • True

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

  • 7. 

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

    • =sum(cell+cell)

    • =cell+cell

    • =sum(cell/cell)

    • =cell/cell

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

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