9_3_6
WHAT: Use basic formulas and functions in a spreadsheet
WHAT: Use basic formulas and functions in a spreadsheet
HOW:
HOW:
Activity 1
Basic Formulas and Functions - this tutorial will cover:
- Add
- Subtract
- Multiply
- Divide
- Average
- Max
- Min
Watch in Microsoft Excel
Watch in Google Sheets
Activity 2
Using the function tools - this tutorial will cover:
- Autosum
- Count
- If
- Countif
In Microsoft Excel
In Google Sheets
CHECK:
CHECK:
EMBED:
EMBED:
Create a guide on using the basic functions and formulas in Microsoft Excel or Google Sheets.
CLASSROOM IDEAS:
CLASSROOM IDEAS:
Students will need some time to practice the different formulas in the tutorials. It may be best to let students work through these tutorials independently.