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: 7,012
| Attempts: 293 | Questions: 7
Please wait...
Question 1 / 7
0 %
0/100
Score 0/100
1. 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?

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.

Submit
Please wait...
About This Quiz
Spreadsheet 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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

Submit
View My Results

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
Cancel
  • All
    All (7)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
The software Excel is used as a tool to help businesses create...
Which of the following formulas is used to "multiply" cells together?
The formula (=cell-cell) is used to multiply two cells together.
The formula (=cell/cell) is used to divide cells in Excel.
Which of the following formulas is used twith the "AutoSum" feature?
Excel can be used to create bar graphs and charts for use in...
Which of the following formulas is used to ADD "two" cells together?
Alert!

Advertisement