Answer:
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.
