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.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS