Above is a data representing the dates of employment, working status, salary and days of work the staff of ICT SALES COMPANY LTD?
By using formulas and Excel functions, answer the following questions
NB. Write the formulas and the answers in the blank spaces provided.
a. How many staff members had a salary smaller than 4000 and a “contract” working status?................................................................................................................................
b. Calculate the total number of the all the staff members……………………………………………………………………………………
c. If a staff member had a salary bigger than 6000 then a bonus of 1000 is to be given to the staff else the staff will have a bonus of 400. Therefore how many staff members had 100 as bonus and how many had 400 as bonus ………………………………………………………………………………………….
………………………………………………………………………………………….
d. Calculate the average salary of all staff members having a morning shift working status.………………………………………………………………………………………
……………………………………………………………………………………………..
e. What is the total salary of Maxwell Nti, Frempong Jeff, Anderson Nsiah and Dick Karren?
………………………………………………………………………
f. Who is the second lowest paid staff member?
…………………………………………………………………………………………………………
g. Find the top 5 highest salaries
………………………………………………………………………………………………………………………………………………………………………………………………
h. Calculate for staff members having a Full day working status, more than 20 days of work and a salary greater than 4000?...................................................................................................................................
i. Find the top 6 smallest salaries
..……………………………………………………………………………………………..
………………………………………………………………………………………………
j. How many staff members are having salaries higher than 20,000 and an hourly working status
………………………………………………………………………………………………
………………………………………………………………………………………………
k. How many staff members worked for more than 40 days?
…………………………………………………………………………………………..
l. What is the total salary of staff members who are having a “morning shift” working status?
………………………………………………………………………………………………
………………………………………………………………………………………………
m. Find the exact date on which the following staff members ended working for the company.
i. Christin Osei……….………………………………………………………………….
ii. Isaac Adomako ………………………………………………………………………..
iii. Harrison Ford …………………………………………………………………………
iv. Agyemang George ……………………………………………………………………
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
