This timed task set uses a fictional support workbook. Read each instruction, inspect the column headings and complete the requested result. You have 150 seconds per task. The timer records an overrun but still lets you finish, so an unfamiliar task can become practice instead of a dead end.
These are original questions for independent preparation. They aren't copied exam items or an official certification test. Each task starts from its own workbook copy and checks the result against changed data. Use formulas and references that follow the inputs. For a spill task, leave enough empty cells for all matching records. After the set, revisit any question where the hint exposed a boundary or a population you missed.