Question

Use Microsoft Excel to produce the work sheet below and to answer the questions that

follow:
Staff ID No Staff Name Rank Salary Allowance Gross Tax NetPayAnnual Income

P.214 Paul J. Director 245,500

P.213 Akanbi E. Manager 186,000

P.457 Michael A Analyst 188,500

P.189 John K. Engineer 180,350

P.362 Ojokojo M. Engineer 180,000

P.404 Lawal O. Manager 175,450

P.241 Chuku B. Auditor 186,250

P.345 Musa D. Accountant 175,000


a. Calculate the Allowance for each staff (Allowance is 25% of the salary).

b. Calculate the Gross for each staff (Gross = Salary + Allowance).

c. Calculate the tax for each staff (Tax = 3.3% of Salary)

d. Calculate the Net Pay for each staff (Net Pay = Gross – Tax).

e. Calculate the Annual income for each staff.

f. Give the worksheet a suitable title, place it above the table and merge/centralize it

appropriately.

g. Rename the worksheet tab with the name “STAFF PAYROLL”.


NOTE:

▪ All values must be in currency format and must include a naira sign (N)

▪ All calculations must be done by using Formulas or Microsoft Excel functions. Manual

calculation is NOT allowed

▪ Neat arrangement and application of necessary formatting of your worksheet would

Answer 1

Answer:

calculate is Not allowed near arrangement and application of necessary formatting of your worksheet would