This Quiz is protected.
Click on the "Subscribe Button" below to unlock.
Note: If you have Already Subscribed and you are seeing this message, it means you are logged out. Please Log In using the Login form Below to Carry on Studying!
(i) Provide four different names of your choice to complete the table.
(ii) Give the values of HOURS WORKED ranging between 3-4 hours for each name provided.
(iii) Provide the corresponding values for the PAY PER HOUR ranging between N300 to N700
(iv) Calculate the BASIC PAY for the values provided to complete the table.
Solution:
To calculate the BASIC PAY for Akin Jones, click on cell E8 and type the formula ⇒ =C7*D7.
Click on the edge of the green rectangle and drag down to obtain the BASIC PAY for the rest of the staff. (or type the corresponding formula in each cell, for example, in cell E8, C8*D8)
(v) Calculate the cell references and corresponding results of the following:
(a) total HOURS WORKED by the staff of the company.
Solution:
To calculate the total hours worked, click on cell C11 and type the formula ⇒ =SUM(C2:C10)
(b) the BASIC PAY of the last five names on the payroll.
Solution:
E6: N400
E7: N900
E8: 1600
E9: 1500
E10: 2800
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
