Search SchoolNGR

Tuesday, 21 April 2026
Register . Login

Data Processing Past Questions and Answers

Data Processing Questions

Question 76:
An operating system will perform the following except
  • A Files and folder arrangement
  • B Storage location
  • C User profile creation
  • D Protection from surge
View Answer & Explanation
Question 77:
A Microsoft Office application suites include all the following except
  • A Word
  • B Access
  • C CorelDraw
  • D PowerPoint
View Answer & Explanation
Question 78:
Which of the following is not a feature of the drawing tool bar?
  • A Oval shape
  • B Line
  • C Drop Cap
  • D Arc
View Answer & Explanation
Question 79:
The MS Excel worksheet below shows the salary distribution for four staff in a company. The net salary is paid after deductions have been made.
S/N A B C D E
1 IDENTIFICATION NUMBER BASIC SALARY (N) TOTAL ALLOWANCE (N) TOTAL DEDUCTION (N) NET SALARY (N)
2 LP/p/1202 22000 29000 7000 44000
3 L/P/1250 26000 35000 9000 52000
4 L/P/3205 15000 21000 6000 30000
5 L/P/3215 33000 41000 8000 66000



Which of the following cells contain numeric data?
  • A A1
  • B A2
  • C C3
  • D E1
View Answer & Explanation
Question 80:
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.
S/N A B C D E
1 IDENTIFICATION NUMBER BASIC SALARY (N) TOTAL ALLOWANCE (N) TOTAL DEDUCTION (N) NET SALARY (N)
2 LP/p/1202 22000 29000 7000 44000
3 L/P/1250 26000 35000 9000 52000
4 L/P/3205 15000 21000 6000 30000
5 L/P/3215 33000 41000 8000 66000



Which of the following for mulas would be used to obtain the value in cell E2?
  • A = B2 + C2 - D2
  • B = B2 + C2 + D2
  • C = (B2 + C2 + D2)/3
  • D = C2 - D2
View Answer & Explanation