Computer Applications
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.
OOo Calc
36 Likes
Answer
(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.
Explanation of Formula
Total salary = Basic Pay + HRA + DA
To calculate HRA, we use the formula = C2/100 * B2
Thus, the formula for Total salary =B2+(C2/100*B2)+D2
Step 2 — With E2 selected, dragging the cell handle from E3 to E7 will copy the formula to the cell range [E3 : E7]. The total salary of each employee will be displayed in the respective cell.
(ii) To calculate the total salary of each employee as sum of salary for the year 1997 and bonus, follow the given steps:
Step 1 — Select G2 and write the formula =SUM(E2 : F2). This formula will calculate the total salary (1998) of Shirome.
Step 2 — With G2 selected, dragging the cell handle from G3 to G7 will copy the formula to the cell range [G3 : G7]. The total salary of each employee will be displayed in the respective cell.
To calculate the percentage increase in the total salary from 1997 to 1998 for each employee, follow the given steps:
Step 1 — Select H2 and type the formula =(G2-E2)/E2 * 100.
Step 2 — With H2 selected, dragging the cell handle from H3 to H7 will copy the formula to the cell range [H3 : H7]. The percentage increase in the total salary from 1997 to 1998 for each employee will be displayed in the respective cell.
Answered By
23 Likes
Related Questions
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 ?
A university student uses a PC to help plan a budget for the first term. Their first attempt is shown below.
(a) Tick one box to show which type of software package has been used.
Tick one box only Graphics Database Spreadsheet Multimedia (b) Which cell contains the spending on rent per week ?
(c) Which one of the following is the formula used in cell D23 ?
Tick one box only = D21 - D8 = D8 - D21 = sum(D2 : D12) (d) Tick one box to show a disadvantage of using a software package to help work out the budget rather than using a calculator, pen and paper.
Tick one box only The formulae could be wrong The wrong prices could be input A virus may corrupt the information Multiple printouts could be produced A self-employed car mechanic uses a spreadsheet to calculate bills for customers.
(a) The mechanic made a mistake when entering the cost of an air filter. An air filter costs Rs. 400.00.
Complete the sentences using words from this list.
C7 ; copy ; D8 ; D7 ; rename ; highlight
(i) The mechanic can change the cost of an air filter by editing cell ……………… .
(ii) The mechanic should ……………… the cell and enter the new cost.
(b) Give the cell references of two cells that should change automatically when the cost of an air filter is changed.
(c) Cells can contain numbers or text.
Tick three boxes to show other types of information a cell can contain.
Tick three boxes Printer Website address Idea Formula Picture Word processor (d) On-line help is available within the spreadsheet.
Tick three boxes to show what should be in the on-line help for the spreadsheet.
Tick three boxes A lesson on percentages so the mechanic can calculate VAT An index to help the mechanic find the information needed A road map to help the mechanic find the route to the parts warehouse A tutorial guide to help the mechanic use the spreadsheet A dictionary that helps the mechanic understand the meaning of words A search engine to help the mechanic find the information needed (e)
(i) The mechanic has to buy the air filter from an on-line store.
Write the labels in order to show how the mechanic can do this.
Label A Pay using a credit card B Enter the key words: air filter, and press the search button C Go to the on-line store using a web browser D Look at the search results and find the right air filter (ii) The mechanic uses a search engine to find where to buy the air filter.
State two reasons why the mechanic might search only websites in the India.
(f) The mechanic gives customers a credit rating from 1 to 3.
Credit Rating 1 Pays promptly and in full on collecting the car 2 Pays within four weeks of collecting the car 3 Money still owed after four weeks A customer who pays after four weeks is given the same credit rating as a customer who does not pay.
(i) Describe one limitation of this coding system designed in OOo Calc.
(ii) Design an improved coding system, if possible.