Question

The formula in cell C2 is =A$2. Autofill is used by dragging C2's autofill box across to D2, E2, and F2. What formulas will appear in D2, E2, and F2, respectively?
A$2, A$3, A$4


B$2, C$2, D$2


B$2, B$3, B$4


C$3, C$4, C$5

Answer 1

The formulas that will appear in D2, E2, and F2 are B$2, C$2 and D$2 respectively

How to determine the formulas?

The formula in C2 is given as:

=A$2

The above is a mixed type of cell referencing where only the row number is locked.

This means that when the cell formula is copied to D2, E2 and F2 the row number 2 would remain unchanged, while the column name A would change to B, C and D.

Hence, the formulas that will appear in D2, E2, and F2 are B$2, C$2 and D$2 respectively

Read more about Excel formulas at:

brainly.com/question/14299634

#SPJ1