Question

In this worksheet, cell E5 contains the formula =$A$5. If you drag cell E5 down to E6, what appears in cell E6 :

a. =$A$5
b. =$A$6
c. =$A$7
d. =$A$4

Answer 1

The answer is option a. =$A$5.

Step-by-step explanation:

When you drag cell E5 down to E6, the formula remains the same because the formula is an absolute reference to cell A5. So, the answer is option a. =$A$5.