6.3 Can you do more? (Y8)
Question relate to the following formula:
If cell A4 held the value 20, what would be the result of this formula?
What is the name of a cell reference that does not change when it is copied down a table?
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.