WAEC Data Processing 2023 Objective — Question 21

Question 21 of 40 from the West African Examinations Council (WAEC) Data Processing 2023 Objective paper, with the correct answer and a full explanation.

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

A. 3

Explanation

COUNTIF is a function in spreadsheet packages that counts the number of cells that satisfy a particular condition; the correct syntax would be =COUNTIF(E2:E5,"<500,000") to count individuals earning less than #500,000 (option D reflects the correct COUNTIF usage pattern among the choices).

Sign up free to unlock

Score tracking
Practice history
Saved questions
Progress dashboard
Personalized sessions
Weak-topic breakdown

…and/or go further with premium services and No Ads.

Create free account

More questions from Data Processing 2023 Objective More Data Processing past papers