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!


The symbol "∑" in mathematical operation in Ms-excel environment is called ______ (NECO 2014)

A. Auto add      B. Auto format      C. Auto sign      D. Auto sum


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

Who among the students will likely earned the first position?

A. Anene Lorreta      B. Eneh Grace      C. Mohammed Deji      D. Bakare Iman


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


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.

What is the value of cell F10?

A. 80   B. 82    C. 84    D. 86


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



In what cell is Victor Umoh’s assignment score?

A. D      B. D5    C. D6     D. E5


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




 



error: Content is protected !!