Thn figure below is an excel snapshot containing information on students. NAME RANK 0 BASIC SALARY TOTAL ALLOWANCE I SEN

[answerhappygod]

Thn Figure Below Is An Excel Snapshot Containing Information On Students Name Rank 0 Basic Salary Total Allowance I Sen 1 (42.61 KiB) Viewed 84 times

Thn figure below is an excel snapshot containing information on students. NAME RANK 0 BASIC SALARY TOTAL ALLOWANCE I SENTE CONTRIBUTION NET SALARY IGH IGH CHO 2400 780 1570 2 Mr. Charles Alta Peter So Staff 3. Mr. Henry Tespety Stor Star 4 Ms. Jacqueline Adjel - Bhasin Senior Staff 5 Mr. Alassan Rasheed Senior Staff 6. Ms. Diabord zalo Junior Staff 7 Mt. Young Forever Senior Star 1600 900 1800 Assumptions: - Total allowance for senior staff is 25% of basic salary and total allowances for junior staff is 17% of basic salary - SSNIT contribution is 5% of basic salary -Net Salary is the sum of basic salary and allowances less SSNIT contribution What function should be entered in cell D2 to compute the Total Allowance for the first employee? 1) What function should be entered in cell 04 to compute the Total Allowance for the third employee? ) Write a function to be entered in cell E3 to compute the SSNIT contribution for the second employee. Write a function to be entered in cell E6 to compute the SSNIT contribution for the fifth employee. v/ What function should be entered in cell F7 to compute the net salary for Mr. Young Forever? vi) What function can be entered in a cell to compute the maximum SSNIT contribution? vii) What function can be entered in a cell to compute the minimum Net Salary? vi) Write a function to be entered in a cell to compute the average Total Allowance. ix) What function can be entered in a cell to count the number of employees? *) What is the difference between the COUNT function and the COUNTA function