Spreadsheet Basics: Cells, Formulas, Functions
Grade 8 Office Productivity Ms. Kenya Akins John R. Griffin Middle School
I Can... Learning Objectives
Navigate a spreadsheet interface confidently Identify cells using grid coordinates (like B4) Input different types of data correctly Create basic formulas using +, -, *, / Use functions: SUM, AVERAGE, MAX, MIN Understand why cell references are magical!
The Human Calculator Challenge
Can YOU beat a spreadsheet? Challenge: Add these 10 numbers as fast as possible 23 + 67 + 89 + 45 + 12 + 78 + 34 + 56 + 91 + 29 Timer starts... NOW! Spreadsheet result: Instant! The winner: Technology wins every time!
Spreadsheet Anatomy: Know Your Grid
{"left":"Columns are labeled with LETTERS (A, B, C, D...)\nRows are labeled with NUMBERS (1, 2, 3, 4...)\nCell Address = Column + Row (like B4)","right":"Formula Bar shows what's really in a cell\nEvery formula starts with = sign\nThe Fill Handle copies formulas down"}
From Formulas to Functions: The Shortcuts
Manual Formula: =A1+A2+A3+A4+A5 (lots of typing!) Function Shortcut: =SUM(A1:A5) (so much easier!) =AVERAGE(B1:B10) finds the mean =MAX(C1:C20) finds the highest value =MIN(D1:D15) finds the lowest value Functions are like having a math genius helper!
The Magic of Cell References
"When you change one number, everything updates automatically. That's the real power of spreadsheets!" - Why we use A1 instead of typing 10 - Change the price, watch totals update - No more manual recalculation - This is what makes spreadsheets magical!