Data Processing Practice Tests – Spreadsheet

Published by on

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 Table below is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.   



Which of the following formulas would calculate the average score of the students in Mathematics? (WASSCE 2018)

A. =Average(C2:C6)       B. =Average(C2:F2)       C. =Average(C1:C6)       D. Average(C1:F1)


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



What is the sum total score for Ade Olu and Eti James?

A. 76     B. 92      C. 168      D. 45


The symbol of the tool for enlarging a cell’s width in MS Excel is _______ (WASSCE 2014)


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


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


 



Related Quizzes:

  1. Data Processing Practice Tests – Relational Models and Constraints in Database Data Processing Practice Tests – Relational Models and Constraints in...
  2. Data Processing Practice Tests – Word Processing Data Processing Practice Tests – Word Processing    ...
  3. Data Processing Practice Tests – Number Bases (Questions with Answers and Explanations) Data Processing Practice Tests – Number Bases (Questions with Answers...
  4. Data Processing Practice Tests – Networking Data Processing Practice Tests – Networking  ...
  5. Data Processing Practice Test – Internet (Questions with Answers and Explanations) Data Processing Practice Test – Internet    ...
  6. Data Processing Practice Test – Data Modeling Data Processing Practice Test – Data Modeling    ...
Categories: Data Processing Practice Test
Tags:

Related Posts

Data Processing Practice Test

Data Processing Practice Test – Data Modeling

Data Processing Practice Test – Data Modeling     Related Quizzes: Data Processing Practice Tests – Relational Models and Constraints in Database Data Processing Practice Tests – Relational Models and Constraints in... Data Processing Practice Read more…

Data Processing Practice Test

Data Processing Practice Test – Internet (Questions with Answers and Explanations)

Data Processing Practice Test – Internet     Related Quizzes: Data Processing Practice Tests – Relational Models and Constraints in Database Data Processing Practice Tests – Relational Models and Constraints in... Data Processing Practice Tests Read more…

Data Processing Practice Test

Data Processing Practice Test – File Organisation (Questions with Answers and Explanations)

Data Processing Practice Test – File Organisation (Questions with Answers and Explanations)     Related Quizzes: Data Processing Practice Tests – Relational Models and Constraints in Database Data Processing Practice Tests – Relational Models and Read more…

error: Content is protected !!