WAEC Data Processing 2017 Paper

Concept:MS Excel named ranges cannot contain spaces.Explanation:In MS Excel, every formula starts with the equals sign $=$.The $\text{SUM}$ function adds the numeric values inside the referenced range.A range name such as $\text{examscore}$ or $\text{exam\_score}$ is validbecause Excel allows letters, numbers, and underscores in names.However, Excel does not allow a space inside a range name or a formula reference.Option D uses $\text{exam score}$, which contains a space between $\text{exam}$ and $\text{score}$.Excel treats this space as invalid syntax.Hence, the formula $=\text{SUM}(\text{exam score})/8$ will not be executed.Options A, B, and C do not contain spaces in their range names, so they are valid.Answer:D. $=\text{SUM}(\text{exam score})/8$