Computer Studies Practice Tests – Spreadsheet


Hello and Welcome to Computer Studies Practice Tests - Spreadsheet

  1. You are to attempt 5 random objectives questions ONLY.
  2. Supply Your Full Name and Location in the text box below and begin immediately.
  3. You can attempt as many times as possible
  4. Your time starts NOW!
Full Name (Surname First)
Location (City/State)
email address:


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 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 H5?

A. 140     B. 141      C. 142      D. 141.75


In a worksheet, which of the following actions would select non-contiguous cells? (WASSCE 2017)

A. Holding down the Shift key
B. Holding down the Ctrl key
C. Holding down the Alt Key
D. Hold big down Ctrl+Shift key



Which of the following formulas would calculate the total of entries in the second row in the diagram above? (WASSCE 2014) 

A. =sum(P1:S2)    B. sum(A1,D2)     C. =sum(A2:D2)   D. =sum(P2:S2)


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 G8?

A. =5%*F10     B. =10%*F8      C. =10%*F10      D. =10*F8


To submit your quiz and see your score/performance report; Make sure you supply your Full Name in the form above.




 



Online Learning and Assessment Portal for Nigerian and International Students
error: Content is protected !!