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

Spreadsheet Tool : OO Calc I — Question 18

Back to all questions
18
Question

Question 19

Create the following worksheet in Ooo Calc.

Create the worksheet in Ooo Calc. From the worksheet find out the average marks for the entire class. 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. Spreadsheet Tool: OO Calc, Computer Applications Code 165 Sumita Arora Solutions CBSE Class 9.

(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 ?

Answer

(i) The average marks for the entire class is 86.

From the worksheet find out the average marks for the entire class. Spreadsheet Tool: OO Calc, Computer Applications Code 165 Sumita Arora Solutions CBSE Class 9.