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!


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


The third position goes to _______

A. Anene Lorreta      B. Eneh Grace      C. Onyebueke Deborah      D. Bakare Iman


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


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

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


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 _______

A. 1070      B. 375      C. 340      D. 355


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


 



error: Content is protected !!