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

Gbriseno

Community Contributor

Quizzes Created: 15 | Total Attempts: 6,618

Questions: 7 | Attempts: 273 | Updated: Mar 22, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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

11kazen Quiz - Excel Math Formulas

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

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

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

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

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

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?

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