Create the following worksheet in Ooo Calc.

(i) From the above worksheet find out the average marks for the entire class.

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

(iii) Now move the original data range to a new location. Find out whether the cell references change or not.

(iv) Again move back the data to its original position and make changes in the marks obtained by students. Notice total, average and class average. What happens ? Why does this happen ?

Clear the copied data range (do not touch the 23. original data range).

From the above created worksheet find out the average marks for the entire class using appropriate formulas.

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.