Computer Applications
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.
OOo Calc
7 Likes
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.
Answered By
5 Likes
Related Questions
Create the following worksheet in Ooo Calc :
From the above created worksheet find out the average marks for the entire class using appropriate formulas.
Now move the original data range (including total, average and class average) to a new location. Find out whether the cell references in formulas change or not.
Now move back the moved data range to the original position and make changes in the marks obtained by students. Notice total, average and class average. What happens ? Why does this happen ? What is this feature called ?