Question

c. The two ways of entering a cell reference in a formula are (a) by typing and (b) by pointing.
Explain the difference between the two methods.
d. When you enter a formula and click Enter, it displays the calculated value. What will you display the formula​

Answer 1

Answer:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

Optional: Download our example file for this lesson.

Watch the video below to learn more about cell references.