WAEC Data Processing 2023 Paper

Concept:$\mathrm{COUNTA}$ counts all non-empty cells in a range.It can count text entries such as identification numbers.Explanation:The identification numbers are stored as text in cells $\mathrm{A}2:\mathrm{A}5$.Each individual has one non-empty cell in this range.So, the correct formula is $=\mathrm{COUNTA}(\mathrm{A}2:\mathrm{A}5)$.$=\mathrm{COUNT}(\mathrm{A}2:\mathrm{A}5)$ would not work because it counts only numeric cells, and these IDs are text.$=\mathrm{COUNTIF}(\mathrm{A}2:\mathrm{A}5)$ is incomplete because it needs a criterion.$=\mathrm{SUM}(\mathrm{A}2:\mathrm{A}5)$ adds numeric values and would not count individuals.Answer:$=\mathrm{COUNTA}(\mathrm{A}2:\mathrm{A}5)$Option C.