The formula in cell B1 is = A$2. Autofill is used by dragging B1's autofill box across to C1, D1, and E1. What formulas will appear in C1, D1, and E1, respectively?

The formulas that will appear in

C1 is = B$2

D1 is = C$2

E1 is = D$2

Step-by-step explanation:

Given

Formula in B1 is = A$2

Required

Formulas in C1, D1 and E1 when dragged from B1.

In Microsoft Office Excel, this is called absolute reference.

But this type of absolute reference requires that only the cell name will be changed or altered, the row number will always remain the same no matter where it's been dragged to.

Since the initial column name is A and the Initial row number is 2 (from A$2),

Cell C1 will take the formula = B$2

Cell D1 will take = C$2

Cell E1 will take = D$2

Notice that only the column name changed for each formula; the row number remain unchanged.