Data Processing 2016 Waec Past Questions and Answers

Question 31 :

• WAEC 2016

A Microsoft Office application suites include all the following except

A. Word
B. Access
C. CorelDraw
D. PowerPoint

Question 32 :

• WAEC 2016

Which of the following is not a feature of the drawing tool bar?

A. Oval shape
B. Line
C. Drop Cap
D. Arc

Question 33 :

• WAEC 2016

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

Question 34 :

• WAEC 2016

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

Question 35 :

• WAEC 2016

In Database Management System (DBMS), linking entities is used to represent?

A. Attributes
B. Objects
C. Relationships
D. Relations