If the formula in Cell D49 is copied to Cells E49:F49, what sequence of values would be generated in Cells D49:F49?

If the formula in Cell D49 is copied to Cells E49:F49, what sequence of values would be generated in Cells D49:F49?


A. C, North, 19122

B. C, South, South

C. C, A, E

D. C, South, 19104

E. C, C, C

The Correct Answer is E. C, C, C

The formula given in cell D49 is a fixed formula and will not change according to the cells. The shortcut for fixing a formula is Alt + F4.  Hence, when the formula given in D49 is copied to another cell, it would produce the same results.

Comments