Excel Functions and Formulas

Front

By default, all cell references are _________ references.

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 function do?

Back

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

Front

What does the Min function return?

Back

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

Front

What does the Countif function return?

Back

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

Front

Excel will display _______________________ if the cell is not wide enough.

Back

######

Front

What is the syntax for the sum function in excel that sums a range from B1 to E1?

Back

=Sum(B1:E1)

Front

For multiplying numbers in A1 AND B1, you use the following formula:

Back

=A1*B1

Front

Formula =A3+B4 is copied from C1 to D1. The changed formula in D1 is

Back

=B3+C4