Data Processing 2018 Waec Past Questions and Answers

Question 36 :

• WAEC 2018

Which of the following command would undo the last operation carried out in Microsoft Word

A. Ctrl + Z
B. Ctrl + Y
C. Ctrl + W
D. Ctrl + U

Question 37 :

• WAEC 2018

While typing, a series of letters were highlighted and the keyboard key combination "Ctrl + B" was executed, the highlighted letters would be ____________

A. Underlined
B. Italicized
C. Deleted
D. Bold

Question 38 :

• WAEC 2018

Table 1 is a part of MS Excel worksheet which shows the mark obtained by some students in an examination. Use the table to answer questions 20 and 21.

S/N	A	B	C	D	E	F
1	NAME OF STUDENT	ENGLISH LANGUAGE	MATHEMATICS	DATA PROCESSING	COMPUTER STUDIES	CIVIC EDUCATION
2	ANENE LORRETA	65	90	70	85	65
3	BAKARE IMAN	60	65	75	80	75
4	ENEH GRACE	75	65	65	75	60
5	MOHEMMED DEJI	65	60	65	60	60
6	ONYEBUEKE DEBORAH	89	65	60	60	65

Which of the following formulas would calculate the average score of the students in Mathematics?

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

Question 39 :

• WAEC 2018

Which of the following formulas would calculate the total score of ONYEBUEKE DEBORAH in the five subjects

S/N	A	B	C	D	E	F
1	NAME OF STUDENT	ENGLISH LANGUAGE	MATHEMATICS	DATA PROCESSING	COMPUTER STUDIES	CIVIC EDUCATION
2	ANENE LORRETA	65	90	70	85	65
3	BAKARE IMAN	60	65	75	80	75
4	ENEH GRACE	75	65	65	75	60
5	MOHEMMED DEJI	65	60	65	60	60
6	ONYEBUEKE DEBORAH	89	65	60	60	65

A. =SUM(B2:B6)
B. =SUM(A6:G6)
C. =SUM(A2:A6)
D. =SUM(B6:F6)

Question 40 :

• WAEC 2018

The following are advantages of a Database Management System (DBSM) except

A. Restriction of unauthorized access to data
B. Provision of multiple interfaces to different classes of users
C. Provision of backup and recovery
D. Compromise of data integrity