Week 7 · 45-60 min
Spreadsheet Formulas and Functions
Week Summary
A quick preview of the main ideas in this week before you begin the slides.
- Introduction to Formulas
- Basic Arithmetic Formulas
- The SUM Function
- The AVERAGE Function
Glossary
Review these key terms before starting this week. They are kept simple so students can learn the new vocabulary before moving into the slides.
- Introduction to Formulas
- Introduction to Formulas
- Basic Arithmetic Formulas
- Basic Arithmetic Formulas
- The SUM Function
- The SUM Function
Introduction to Formulas
Progress
1 / 8
Use basic formulas to perform calculations in a spreadsheet.
Read one card at a time. Focus on the main idea first, then look at the visual on the right to help it stick.
Formulas calculate values automatically.
Every formula starts with an equals sign.
Formulas can reference other cells.
Results update when the data changes.
Formulas save time compared with manual calculation.
Remember
Formulas turn a spreadsheet from a table into a working tool.
Introduction to Formulas
Slide 1 of 8
Use arrows or dots to move through the lesson
Practice
- Write 2-3 sentences about what you learned this week.
Coming Next Week: Next: Email Basics and Etiquette