If =B2F1 is copied from C2 to C3, it becomes:

=B3F2
=C3G1
=B3F1
=B2F1

Answer

C) =B3F1

Only the relative part changes.

Computer Science MCQ · More Lab: MS Excel MCQs · Practise