CBSE Class 9 Computer Applications
Question 53 of 53
Spreadsheet Tool : OO Calc I — Question 25
Back to all questions 25
Question Question 26
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.
(i) To calculate the total salary as sum of Basic Salary, HRA and DA for each employee for the year 1997, follow the given steps:
Step 1 — Select E2 and write the formula =B2+(C2/100*B2)+D2. This formula will calculate the total salary of Shirome.