Excel Formulas/Functions

Front

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

Back

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

Front

If the parenthesis is removed, what will 9.5% be multiplied by? Options: D2 +D3+D4+D5, D5, D2, None

Back

D5

Front

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

Back

perform calculations or other actions.

Front

The discount formula can be explained by saying the _______ minus 10% of the ___________ or multiplying the ________ times 90%.

Back

total

Front

Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.

Back

True

Front

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

Back

Order of Operations

Front

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

Back

Parentheses

Front

By default, all cell references are _________ references.

Back

Relative

Front

Unlike _________ references, _________ references do not change when copied or filled.

Back

Relative, Absolute

Front

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

Back

$