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

A. = A5:F5        B. =B5:G5         C. =F10-G10       D. =F5-G5


Which of these formulas will not be executed in MS Excel? (WASSCE 2017)

A. =SUM(examscore)
B. =SUM(examscore)-12
C. =SUM(examscore)*8
D. =SUM(examscore)/3


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



What is the exam average score for Obi Chidi?

A. 30      B. 10      C. 15      D. 13.5


If cell A20 in MS Excel contains the value 5, then the formula “=A20^3” will return a value equal to ________ (WASSCE 2020)

A. 15      B. 25      C. 75      D. 125


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

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


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