Formulas in Excel

In the picture, why is D2 through D5 placed in paranthesis?

• So Excel knows to total the cells before performing the next operation.

• So the total of the cells can be multiplied rather than added.

• So the calculation will be done last.

If the parenthesis is removed, what will 9.5% be multiplied by? 

• D2 +D3+D4+D5
• D5
• D2
• None

Which response best completes the following statement: A formula is used to

• perform calculations or other actions.

• find averages.

• Look Up data

Excel follows the ___________________ and first adds the values inside the parentheses.

• Order of Operations
• Formula Guidelines

___________ are often the best way to define which calculations will be performed first in Excel.

• Parentheses
• Forumlas

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

• %

• $

• &

• #

When calculating the tax per item the formula to use it

• = Total * sales tax%
• = Total +(Total * sales tax%)

What is a formulas in excel sheet

• The address of the cells

• The defined expression that contains values, constants, Call reference, functions and operators

• Numbers or text values that can be entered directly in a formula

(a)   Specify the type of Operation you want to perform

An error that occurs when a formula is not spelt correctly

• #NAME?

• #VALUE!

• #DIV/0!

• #####