Data Processing Practice Tests – Spreadsheet


Hello and Welcome to Data Processing 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 (Surnamr First):
Location (City/State):


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



Which of the two students obtained same total score?

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


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?

A. = A5:F5        B. =B5:G5         C. =F10-G10       D. =F5-G5


In spreadsheets, data would not be accepted into a cell by pressing the _______ (WASSCE 2015)

A. Shift key.       B. Arrow key.       C. Esc key.        D. Tab key


The first step taken in editing a chart in MS Excel is ______ (WASSCE 2019)

A. click and drag the chart object
B. click the chart object
C. copy the chart object
D. drag the chart object


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



What is the sum total of exam average score for students in row 3, 4 and 5?

A. 27.5      B. 29      C. 80.5      D. 24


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

Unable to submit your quiz? Kindly Click Here To Retake Data Processing Practice Tests - Spreadsheet. Make sure you supply your Full Name before submission.






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