Computer Studies Practice Tests – Spreadsheet

Published by on

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!


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


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 the following formulas would calculate the total of entries in the second row in the diagram above? (WASSCE 2014) 

A. =sum(P1:S2)    B. sum(A1,D2)     C. =sum(A2:D2)   D. =sum(P2:S2)


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


 



Related Quizzes:

  1. Computer Studies Practice Tests – Internet Computer Studies Practice Tests – Internet  ...
  2. Computer Studies Practice Tests – Concepts of Number System (Questions with Answers and Explanations) Computer Studies Practice Tests – Concepts of Number System (Questions...
  3. Computer Studies/ICT Practice Tests – Basic Programming (Questions With Answers and Explanations) Computer Studies Practice Tests – Basic Programming    ...
  4. Computer Studies Practice Test – Logic Circuits (Questions with Answers and Explanations) Computer Studies Practice Test – Logic Circuits (Questions with Answers...
  5. Computer Studies/ICT Practice Test – System Development Life Cycle (Questions with Answers and Explanations) Computer Studies/ICT Practice Test – System Development Life Cycle (Questions...
  6. Computer Studies/ICT Practice Test – Computer Data Conversion (Questions with Answers and Explanations) Computer Studies/ICT Practice Test – Computer Data Conversion (Questions with...
Categories: Computer Studies Practice Test
Tags:

Related Posts

Computer Studies Practice Test

Computer Studies/ICT Practice Test – Computer Data Conversion (Questions with Answers and Explanations)

Computer Studies/ICT Practice Test – Computer Data Conversion (Questions with Answers and Explanations)     Related Quizzes: Computer Studies Practice Tests – Internet Computer Studies Practice Tests – Internet  ... Computer Studies Practice Tests – Read more…

Computer Studies Practice Test

Computer Studies/ICT Practice Test – System Development Life Cycle (Questions with Answers and Explanations)

Computer Studies/ICT Practice Test – System Development Life Cycle (Questions with Answers and Explanations)     Related Quizzes: Computer Studies Practice Tests – Internet Computer Studies Practice Tests – Internet  ... Computer Studies Practice Tests Read more…

Computer Studies Practice Test

Computer Studies Practice Test – Historical Development of Computers

Computer Studies Practice Test – Historical Development of Computers     Related Quizzes: Computer Studies Practice Tests – Internet Computer Studies Practice Tests – Internet  ... Computer Studies Practice Tests – Word Processing Computer Studies Read more…

error: Content is protected !!