
Question relate to the following formula:
=120*A4
If cell A4 held the value 20, what would be the result of this formula?
Question relate to the following formula:
=120*A4
What is the name of a cell reference that does not change when it is copied down a table?
Question relate to the following formula:
=120*A4
Show how you would rewrite this formula so that it does not change when it is copied down the table.
Explain how you used recalculation in this lesson to answer the director’s question.