This Excel lesson on formulas and basic functions helps students practice real-life spreadsheet calculations through a practical, easy-to-understand scenario.

In the Shopping List activity, students work with a small dataset of items, quantities, and prices. They calculate item totals using multiplication formulas and then analyze the data by finding the grand total and key summary values using Excel functions. Built-in tips and automatic feedback guide students as they complete the tasks, helping them understand both the formulas and the logic behind the calculations.

Skills Practiced

• Writing multiplication formulas
• Using SUM, MAX, MIN, and AVERAGE functions
• Working with quantities, prices, and totals
• Interpreting spreadsheet data and summary values

What’s Included

• 1 interactive Excel file with built-in guidance and feedback
• 1 printable and editable worksheet (Word format)
• Completed Excel file and worksheet (answer key)

Key Features

• Step-by-step tips that support beginner learners
• Reinforces correct formula and function syntax
• No prep required — ready to use in class or online

Perfect for middle school, high school, or introductory Excel classes, this lesson works well for classwork, independent practice, homework, early finishers, or assessment. Students gain hands-on experience using formulas and functions while working with realistic spreadsheet data.