Data Processing Practice Tests – Spreadsheet

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?

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