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

What does Excel 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

Formula for multiplying numbers in A1 and B1

Back

=A1*B1

Front

Formula =A3+B4 is copied from C1 to D1. What is the changed formula in D1?

Back

=B3+C4