When you copy a formula from one cell to another, Excel automatically alters the new formula relative to where it is being copied. The fill handle is used to make copying text, numbers and formulas easier.
Identify the steps involved when copying formulas with the fill handle. Then explain what is likely to occur if you copy formulas from one worksheet to another. What are the advantages of relative cell referencing? Can you think of any disadvantages? 150-200 Words