Computer Applications
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.
Related Questions
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.
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 ?
Write commands for the operations (i) — (ii) based upon the spreadsheet shown below :
(i) To calculate the total salary as sum of Basic Salary, HRA and DA for each employee for the year 1997.
(ii) To calculate the total salary of each employee for the year 1998 as sum of salary for the year 1997 and bonus. Also calculate the percentage increase in the total salary from 1997 to 1998 for each employee.