The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, and A, B, C respectively. Use the...

      

The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, and A, B, C respectively.
fig2925620191400.png
Use the following expressions to answer the questions that follow
- Basic pay- Hours worked x pay per hour
- Allowances are allowed at 10% of basic pay
- Gross pay- Basic pay + allowances
- Tax deductions are calculated at 20% of gross pay
- Net pay-= gross pay – tax deductions
Write formulae using cell references for the following cells
(i) D2
(ii) E4
(iii) F10
(iv) G7
(v) H5

  

Answers


Kavungya
(i) D2 = B2 * C2
(ii) E4 = 10% * D4 or 10% * (B4 * C4)
(iii) F10 = D10 + E10
(iv) G7 = 20% * F7
(v) H5 = H5 – G5
Kavungya answered the question on June 25, 2019 at 11:02


Next: Draw a flowchart to compare three non- equal numeric values A,B,C and print the largest of the three
Previous: State three ways of moving round the page in desktop publishing window

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions