Page 15 of 24PREVNEXT

Get to know Excel: Enter formulas

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


What is an absolute cell reference?

The cell reference automatically changes when the formula is copied down a column or across a row.

The cell reference is fixed.

The cell reference uses the A1 reference style.

Which cell reference refers to a range of cells in column B, rows 3 through 6?

(B3:B6)

(B3,B6)

Which of these is an absolute reference?

B4:B12

$A$1

If you copy the formula =C4*$D$9 from cell C4 to cell C5, what will the formula be in cell C5?

=C5*$D$9

=C4*$D$9

=C5*$E$10

Page 15 of 24PREVNEXT