huge spreadsheet test

Front

Every formula starts with

Back

=

Front

Choose the answer that shows a RELATIVE cell reference: =C4, =($C$1*.5)+$D$1, =$C$4, =4^3

Back

=C4

Front

Choose the formula with an ABSOLUTE cell reference: =B1*C4, =B1*$C$4, =A3, =4^3

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: Red Blood, 4*12, Mitochondria, C4 or $C$4

Back

C4 or $C$4

Front

Which answer references a cell range?

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 joins multiple items using a delimiter (like a space, period, or comma). The first argument defines the delimiter, the second determines if blank cells will be ignored, and the remaining arguments are the cells that have the data that will be concatenated.

Back

TEXTJOIN