Excel - Formulas, Functions & Formatting

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.

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

• Order of Operations
• Formula Guidelines

By default, all cell references are _________ references. 

• Absolute
• Relative

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.

• relative
• relational

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

• Absolute
• relative

What does the Average formula return?

• Returns the lowest argument.

• Returns the middle argument.

• Returns the three highest arguments.

• Returns the mean of all its arguments.

What does the Max formula do?

• Returns the highest three values in a set of values and ignores text.

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

• Returns the text that you are searching for.

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

What does the Min formula return?

• Returns the smallest three numbers form a set and ignores text.

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

• Returns the largest three numbers form a set and ignores text.

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

What does the Countif formula return?

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

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

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

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

Which operator is used to multiply in Excel?

• +

• -

• /

• *