9_3_6

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

Create a guide on using the basic functions and formulas in Microsoft Excel or Google Sheets.

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.