Mastering Excel's Big Three Functions
AVERAGE, MIN, and MAX Grade 7 Technology John R. Griffin Middle School
I Can... Learning Objectives
I can define and differentiate between AVERAGE, MIN, and MAX functions I can apply correct Excel formula syntax with equals sign and cell ranges I can analyze real-world datasets to extract meaningful insights I can troubleshoot and fix common formula errors
The Anatomy of a Function
Functions vs. Formulas: What's the difference? The Magic Equals Sign (=) - Without it, no magic happens! Cell Ranges: A1:A10 means 'from A1 to A10' Syntax: The 'grammar rules' of Excel
Ribbon Scavenger Hunt
Find the 'fx' function button Locate the SUM function (our warm-up) Identify where formulas appear when typing Discover the 'Name Box' that shows cell addresses
Meet the Big Three Functions
AVERAGE: Finds the arithmetic mean (the middle ground) MIN: Identifies the smallest value (the bargain hunter) MAX: Identifies the largest value (the premium choice) All three use the same syntax pattern: =FUNCTION(Range)
Function Syntax Breakdown
{"left":"=AVERAGE(A1:A10)\nFinds the mean of values in cells A1 through A10\n=MIN(B5:B15)\nReturns the smallest number in the range B5 to B15","right":"=MAX(C1:C20)\nShows the largest value from C1 to C20\nPro Tip: Always start with =\nWithout it, Excel thinks you're typing words!"}
Griffin Middle Sneakers Project
Analyze 20 popular sneaker prices from different stores Use AVERAGE to find typical sneaker cost Use MIN to find the best deal Use MAX to identify luxury options Real-world data analysis practice
Data Detective Challenge
You're analyzing test scores: 85, 92, 78, 95, 88, 91, 82 What function would you use to find the class average? Which function shows the highest score? How would you identify the lowest score?
Error Hunting: Common Mistakes
Missing equals sign: AVERAGE(A1:A10) ❌ Wrong punctuation: =MIN(A1-A10) ❌ Missing parentheses: =MAX A1:A10 ❌ Correct format: =FUNCTION(A1:A10) ✅
Your Excel Toolkit is Complete!
You can now find averages in any dataset You can identify minimum and maximum values You understand Excel syntax and can avoid common errors You're ready for Friday's Skills Challenge! Next: Apply these skills to real-world problems