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?
a. $e19
b. $e$19
c. e$19
d. e19

In order to keep the cell reference the same, the formula to be used should be $E$19.

B. $E$19

Explanation:

The concept of relative and absolute cell reference has been used here. By default, the spreadsheet software uses the relative cell referencing.

But if a user wants to keep a cell or a column or both of them constant, it can be achieved with the help of absolute cell referencing by using the dollar sign ahead of the component to be kept constant.

In the given question, the cell has to be kept constant so the dollar sign would be used ahead of both the row and column.

776 colleges and universities. it is also accredited 3,852 applied and natural science, computing, engineering and engineering technology programs. i hope this .

answerlibraries;