Bright Tutorials Bright Tutorials
CBSE Class 9 Computer Applications Question 50 of 53

Spreadsheet Tool : OO Calc I — Question 22

Back to all questions
22
Question

Question 23

Now copy the range consisting of the mentioned entire data (including total, average & class average) to a new location. Find out whether the cell references in formulas change or not.

Answer

When we copy the range consisting of the mentioned entire data to a new location, the cell references in the formulas change according to the position of the cells to which they refer.