Excel Functions and Formulas

Front

Every formula starts with

Back

=

Front

Choose the answer that shows a RELATIVE cell reference

Back

=C4

Front

Choose the answer that shows a formula with an ABSOLUTE cell reference

Back

=B1*$C$4

Front

A RELATIVE reference in Excel means that the cell reference does not change when the formula is copied.

Back

False

Answer explanation

A RELATIVE reference changes when a formula is copied in Excel. When this formula is cpied down, Excel will change the formula automatically. If you copied it down one more cell, it would enter "=B7*C7".

Front

An ABSOLUTE cell reference in Excel means that the cell reference does change when the formula is copied.

Back

False

Answer explanation

An ABSOLUTE cell reference is used in Excel when you do not want the cell reference to change. You can make a cell reference ABSOLUTE by adding the $ before each character- $D$11. Use the F4 button to make a cell reference ABSOLUTE.

Front

Choose the answer that references a cell

Back

C4 or $C$4

Front

Which answer references a cell range: =Sum(A3,B7,E4), =B3+B5, =SUMIF(A1:A13,"Brass",C1:C13), SUM

Back

=SUMIF(A1:A13,"Brass",C1:C13)

Front

Excel can find the average of a range of numbers by using the _________ function.

Back

AVERAGE

Front

The _______ function counts the numbers in a range of cells.

Back

COUNT

Front

The _______ function returns a specified number of characters from the beginning of a given text string

Back

LEFT