Question

You plan to use the fill down feature on a formula and you need to keep a cell reference the same . Which one of the following formats will allow you to keep the same cell reference ?

Answer 1

This question is unfortunately incomplete. The options are:
A. E$19
B. $E$19
C. $E19
D. E19

The correct answer is B: $E$19

The '$' symbol allows you to make an absolute reference in a spreadsheet. However, you can either make absolute reference to a column (C. $E19), or absolute reference to a row (A. E$19), but to make an absolute reference to a particular cell, both the row and column parts must be referenced using the '$' symbol.