STATISTICS FOR MANAGERS USING MICROSOFT EXCEL REVIEW PAPER 2026 COMPLETE QUESTIONS WITH EXPERT SOLUTIONS AND MARKING SCHEME

STATISTICS FOR MANAGERS USING
MICROSOFT EXCEL REVIEW PAPER 2026
COMPLETE QUESTIONS WITH EXPERT
SOLUTIONS AND MARKING SCHEME

◉ Cell range.
Answer: A group of selected cells in a worksheet


◉ Cell reference.
Answer: The location of a cell identified by column and row (ex: A1)


◉ COUNT.
Answer: Counts only numeric values in a range


◉ COUNTA.
Answer: Counts all non-empty cells (text + numbers)


◉ Flash Fill.
Answer: Automatically fills in data based on patterns it detects


◉ Formula.

, Answer: An equation used to calculate a value (starts with =)


◉ Function.
Answer: A built-in formula in Excel (like SUM or AVERAGE)


◉ Operators.
Answer: Symbols used in formulas (+, −, *, /, ^)


◉ Order of Operations.
Answer: The sequence Excel follows to calculate formulas


◉ PEMDAS.
Answer: Parentheses, Exponents, Multiply/Divide, Add/Subtract


◉ Range.
Answer: A group of cells


◉ Range reference.
Answer: Identifies a group of cells (ex: A1:A10)


◉ SUM.
Answer: Adds values in a range