Computer Studies Practice Tests – Spreadsheet

Published by ASSURE on

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.


 



Related Quizzes:

Computer Studies Practice Tests – NetworkingNovember 21, 2022
Computer Studies Practice Tests – InternetNovember 21, 2022
Computer Studies Practice Tests – Word ProcessingNovember 21, 2022
Computer Studies Practice Tests – Concept of Numbering System in ComputingNovember 21, 2022
Computer Studies Practice Tests – Basic ProgrammingNovember 21, 2022
Categories: Computer Studies Practice Test
Tags:

Related Posts

Computer Studies Practice Test

Computer Studies Practice Tests – Basic Programming

Computer Studies Practice Tests – Basic Programming   Related Quizzes:Computer Studies Practice Tests – InternetNovember 21, 2022Computer Studies Practice Tests – SpreadsheetNovember 21, 2022Computer Studies Practice Tests – Word ProcessingNovember 21, 2022Computer Studies Practice Tests Read more…

Computer Studies Practice Test

Computer Studies Practice Tests – Concept of Numbering System in Computing

Computer Studies Practice Tests – Concept of Numbering System in Computing   Related Quizzes:Computer Studies Practice Tests – Word ProcessingNovember 21, 2022Computer Studies Practice Tests – InternetNovember 21, 2022Computer Studies Practice Tests – SpreadsheetNovember 21, Read more…

Computer Studies Practice Test

Computer Studies Practice Tests – Networking

Computer Studies Practice Tests – Networking   Related Quizzes:Computer Studies Practice Tests – SpreadsheetNovember 21, 2022Computer Studies Practice Tests – Basic ProgrammingNovember 21, 2022Computer Studies Practice Tests – Word ProcessingNovember 21, 2022Computer Studies Practice Tests Read more…

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