Computer Studies Practice Tests – Spreadsheet

The table below is a simple payroll.


If
• Basic pay = Hours worked x pay per hour
• Allowances are allocated at 5% of basic pay.
• Gross pay = Basic pay + allowances.
• Tax deductions are calculated at 10% of gross pay.
• Net pay = Gross pay — tax deduction.

What is the value of cell E4?

The MS Excel worksheet below shows the salary distribution for four staff of a company. The net salary is paid after deductions have been made.



Which of the following formulas would be used to obtain the value in cell E2? (WASSCE 2016)

A. =B2+C2-D2       B. =B2+C2+D2       C. (B2+C2+D2)/3       D. =C2-D2

The Table below is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.



Which of the following formulas would calculate the total score of ONYEBUEKE DEBORAH in the five subjects? (WASSCE 2018)

A. =SUM(B2:B6)       B. =SUM(A6:G6)       C. =SUM(A2:A6)       D. =SUM(B6:F6)

Study the MS Excel worksheet below and use it to answer the question that follow:



The least total score was obtained by _______?

A. Ade Olu     B. Victor Umoh      C. Obi Chidi      D. Ola Bisi

The table below is a simple payroll.


If
• Basic pay = Hours worked x pay per hour
• Allowances are allocated at 5% of basic pay.
• Gross pay = Basic pay + allowances.
• Tax deductions are calculated at 10% of gross pay.
• Net pay = Gross pay — tax deduction.

Using cell referencing, what is the formula for cell H5?