9_3_7

Activity 1

We can use the "fill handle" or "drag handle" in a spreadsheet to replicate formulas. This is a great tool but when we need to point to a fixed cell it doesn't work properly.

Look at the tutorials to see how to fix this problem.

In Microsoft Excel

In Google Sheets

Add to the guide that you created last lesson, showing how to fix a cell in a spreadsheet.

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.