### Data Processing Past Questions

381

Figure 3 is a Microsoft Excel Worksheet. Use it to answer questions 20 and 21.

 A B C D E 1 IDENTICATION NUMBER BASIC SALARY (N) TOTAL ALLOWANCE (N) TOTAL DEDUCTION (N) NET SALARY (N) 2 WASC/LPT/001 800000 60000 40000 820000 3 WASC/LPT/002 700000 40000 20000 720000 4 WASC/LPT/003 300000 10000 5000 305000 5 WASC/LPT/004 400000 20000 10000 410000

Figure 3

What formula will correctly display the total number of individuals involved in the computation as shown in Figure 3?

• A. =COUNT(A2:A5)
• B. =COUNTIF(A2:A5)
• C. =COUNTA(A2:A5)
• D. =SUM(A2:A5)
WAEC 2023
382

Figure 3 is a Microsoft Excel Worksheet. Use it to answer questions 20 and 21.

 A B C D E 1 IDENTICATION NUMBER BASIC SALARY (N) TOTAL ALLOWANCE (N) TOTAL DEDUCTION (N) NET SALARY (N) 2 WASC/LPT/001 800000 60000 40000 820000 3 WASC/LPT/002 700000 40000 20000 720000 4 WASC/LPT/003 300000 10000 5000 305000 5 WASC/LPT/004 400000 20000 10000 410000

Figure 3
What formula will calculate the total number of individuals who earn less than â‚¦500,000 from the table as shown in Figure 3?

• A. =COUNT(E2:E5,
• B. =COUNT(E2:E5)
• C. =COUNTA(E2:E5)
• D. =COUNTIF(E2:E5,
WAEC 2023
383

Figure 4 is an entity relationship diagram in MS Access. Use it to answer questions 22 and 23.
How many entity are listed in Figure 4?

• A. 30
• B. 25
• C. 3
• D. 5
WAEC 2023
384

Figure 4 is an entity relationship diagram in MS Access. Use it to answer questions 22 and 23.
What kind of relationship exists between users and products as shown in Figure 4?

• A. One-to-many
• B. Many-to-many
• C. One-to-one
• D. Many-to-one
WAEC 2023
385

Database Administrator is a professional who

• A. handles packet sniffing in a network
• B. designs, implements and maintains a database
• C. performs data entry in a database
• D. tests and detects vulnerabilities on hardware devices and software
WAEC 2023