Data Processing Practice Tests – Spreadsheet

The Table below is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.

What is the sum total of the total score for Anene Lorreta, Eneh Grace and Bakare Iman is _______

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

In Microsoft Excel, LABELS are described as ______ (NECO 2016)

A. formula descriptors.
B. numeric information in a cell.
C. several cells in a sequence
D. text entries that describe the contents of other cells

By default, numeric values in worksheet are _______ (WASSCE 2019)

A. centered      B. left-aligned      C. right-aligned      D. unaligned