3. The figure below is an excel snapshot containing information on students. [10 marks) NAME B RANK D F BASIC SALARY TOTAL ALLOWANCE (CHSSNIT CONTRIBUTION NET SALARY (CH) (GH) CH 1 2 Mr. Charles Atta Peters Senior Staff 3. Mr. Henry Tekpetey Junior Staff 4 Ms. Jacqueline Adjei - Busia Senior Staff 5 Mr. Alhassan Rasheed Senior Staff 6 Ms. Dzigbordi Azaglo Junior Staff 7 Mr. Young Forever Senior Staff 2400 780 1870 1600 940 1800 Assumptions: Total allowances 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. i) ii) iv) v) What function should be entered in cell D2 to compute the Total Allowance for the first employee? What function should be entered in cell D4 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 What function should be entered in cell F7 to compute the net salary for Mr. Young Forever? What function can be entered in a cell to compute the maximum SSNIT contribution? What function can be entered in a cell to compute the minimum Net Salary? Write a function to be entered in a cell to compute the average Total Allowance. 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 vi) vii) Vii) ix) function [10 marks)