Excel - Formulas, Functions & Formatting

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

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

Back

Order of Operations

Front

By default, all cell references are _________ references.

Back

Relative

Front

In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.

Back

relative

Front

If you don't want a cell reference to change when copied to other cells, use _________ references.

Back

Absolute

Front

What does the Average formula return?

Back

Returns the mean of all its arguments.

Front

What does the Max formula do?

Back

Returns the largest value in a set of values and ignores text.

Front

What does the Min formula return?

Back

Returns the smallest value in a set of values and ignores text.

Front

What does the Countif formula return?

Back

Counts the number of cells within a range that meets the given condition.

Front

Which operator is used to multiply in Excel?

Back

*