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
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? . Make sure you supply your Full Name before submission.

error: Content is protected !!