CBSE Class 9 Computer Applications Question 51 of 53

Spreadsheet Tool : OO Calc I — Question 23

Back to all questions
23
Question

Question 24

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.

Answer

When we move the original data range to a new location, the cell references in the formulas change according to the position of the cells to which they refer.