Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
A NAME RANK BASIC SALARY TOTAL ALLOWANCE (GH SSNIT CONTRIBUTION NET SALARY (CHC) (CH C) (GHC) Senior Staff Junior Staff 2 Mr. Charles Atta Peters 2400 780 3 Mr. Henry Tekpetey 4 Ms. Jacqueline Adjei - Busia Senior Staff 5 Mr. Alhassan Rasheed 6 Ms. Dzigbordi Azaglo 7 Mr. Young Forever 1870 Senior Staff Junior Staff Senior Staff 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) What function should be entered in cell D2 to compute the Total Allowance for the first employee? ii) What function should be entered in cell D4 to compute the Total Allowance for the third employee? iii) Write a function to be entered in cell E3 to compute the SSNIT contribution for the second employee. iv) 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? viii) 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? x) What is the difference between the COUNT function and the COUNTA function.

A NAME RANK BASIC SALARY TOTAL ALLOWANCE (GH SSNIT CONTRIBUTION NET SALARY (CHC) (CH C) (GHC) Senior Staff Junior Staff 2 Mr. Charles Atta Peters 2400 780 3 Mr. Henry Tekpetey 4 Ms. Jacqueline Adjei - Busia Senior Staff 5 Mr. Alhassan Rasheed 6 Ms. Dzigbordi Azaglo 7 Mr. Young Forever 1870 Senior Staff Junior Staff Senior Staff 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) What function should be entered in cell D2 to compute the Total Allowance for the first employee? ii) What function should be entered in cell D4 to compute the Total Allowance for the third employee? iii) Write a function to be entered in cell E3 to compute the SSNIT contribution for the second employee. iv) 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? viii) 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? x) What is the difference between the COUNT function and the COUNTA function.

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
1st Edition
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Chapter11: Building Solutions: Database, System, And Application Development Tools
Section: Chapter Questions
Problem 11TF
See similar textbooks
icon
Related questions
Question
A B D F BASIC SALARY TOTAL ALLOWANCE (GH SSNIT CONTRIBUTION NET SALARY (CHC) NAME RANK C) (GH C) (CH C) 1 2 Mr. Charles Atta Peters Senior Staff 2400 Junior Staff 3 Mr. Henry Tekpetey 4 Ms. Jacqueline Adjei - Busia Senior Staff 780 1870 5 Mr. Alhassan Rasheed 6 Ms. Dzigbordi Azaglo 7 Mr. Young Forever Senior Staff Junior Staff Senior Staff 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) What function should be entered in cell D2 to compute the Total Allowance for the first employee? ii) What function should be entered in cell D4 to compute the Total Allowance for the third employee? iii) Write a function to be entered in cell E3 to compute the SSNIT contribution for the second employee. iv) 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? viii) 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? x) What is the difference between the COUNT function and the COUNTA function.
Transcribed Image Text:A B D F BASIC SALARY TOTAL ALLOWANCE (GH SSNIT CONTRIBUTION NET SALARY (CHC) NAME RANK C) (GH C) (CH C) 1 2 Mr. Charles Atta Peters Senior Staff 2400 Junior Staff 3 Mr. Henry Tekpetey 4 Ms. Jacqueline Adjei - Busia Senior Staff 780 1870 5 Mr. Alhassan Rasheed 6 Ms. Dzigbordi Azaglo 7 Mr. Young Forever Senior Staff Junior Staff Senior Staff 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) What function should be entered in cell D2 to compute the Total Allowance for the first employee? ii) What function should be entered in cell D4 to compute the Total Allowance for the third employee? iii) Write a function to be entered in cell E3 to compute the SSNIT contribution for the second employee. iv) 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? viii) 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? x) What is the difference between the COUNT function and the COUNTA function.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Decision Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Management Of Information Security
Management Of Information Security
Computer Science
ISBN:
9781337405713
Author:
WHITMAN, Michael.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS