Respuesta :
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 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
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
