COMPUTER STUDIES _ MID TERM PROJECT –JS3 (SECOND TERM)

 

MID TERM PROJECT –JS3    (40MARKS)

1. Create a spreadsheet document (i.e using Microsoft Excel) for company payroll as shown below:

(a)  Find the  basic pay for each staff by using the formula:

BASIC PAY = HOURS WORKED * PAY PER HOUR

(b) Add five (5) names of your choice, hours worked, and pay per hour to make the records 10.

(c) Find the total BASIC PAY on row 11

 

S/N	NAMES OF STAFF	HOURS WORKED	PAY PER HOUR (N)	BASIC PAY (N)
1	IJILUSI OPEYEMI	2	400
2	OMONIYI SOLA	3	200
3	AGATI FATGAN	4	100
4	UMAR ABDULAHI	3	100
5	IBEKWE EBUKA	2	200
6
7
8
9
10
				TOTAL=

 

Note: 

Submit your project to: sunlitedigitalhub@gmail.com and use your full name as subject of the mail...…