11kazen Quiz - Excel Math Formulas - Quiz, Flashcards & Trivia

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?

Spreadsheet

Word document

Presentation

Email

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.

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.

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

=cell*cell

=cell+cell

=cell/cell

=cell-cell

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

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

=cell+cell

=cell*cell

=sum(cell:cell)

=cell/cell

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.

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.

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

True

False

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.

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.

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

=sum(cell+cell)

=cell+cell

=sum(cell/cell)

=cell/cell

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.

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.