Clait and DIT Spreadsheet Exercises

What’s inside (for each of the 6 scenarios):

A short scenario description
A data table students will enter into Excel
Clear, numbered tasks that cover:

COUNT, IF, SUM, AVERAGE, COUNTIF, SUMIF
Linking cells across sheets
Charts + trend lines
Data interpretation prompts
Cell validation (numeric ranges, dropdown lists)
Conditional formatting (thresholds, color scales)
Absolute cell references (e.g., thresholds, rates)
Dashboards (key metrics + visuals)

Scenarios included:

Retail Store Sales (revenue, category analysis, VAT rate with absolute cell)
Student Grades (averages, pass/fail threshold, color scales)
Household Monthly Expenses (essential vs discretionary, budget check)
Warehouse Inventory (reorder flags, category totals)
Employee Performance & Bonuses (targets, bonus % with absolute cell)
Website Traffic Analytics (conversion rates, trend vs target)