### Data Processing Past Questions

66

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
WAEC 2016
67

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
WAEC 2016
68

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

• A. Attributes
• B. Objects
• C. Relationships
• D. Relations
WAEC 2016
69

A data element that uniquely identifies one record from the other in a table is the

• A. Attribute key
• B. determinant
• C. entity key
• D. primary key
WAEC 2016
70

In MS PowerPoint presentation, the special effects that control the order in which objects enter a slide and their manner of appearance is

• A. Transition
• B. Media
• C. ClipArt
• D. Animation
WAEC 2016