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

Data Processing
WAEC 2023

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,
##### Explanation

The formula that will calculate the total number of individuals who earn less than ₦500,000 from the table as shown in Figure 3 is COUNTIF(E2:E5, "< 500,000").

The COUNTIF function counts the number of cells that contain a specific value in a range. In this case, we want to count the number of cells in the E column that contain a value less than ₦500,000. The E column contains the net salaries of the individuals. Therefore, the COUNTIF function will return the total number of individuals who earn less than ₦500,000.