9_3_7
WHAT: Remember how to fix a cell reference to aid with duplication of formulas
WHAT: Remember how to fix a cell reference to aid with duplication of formulas
HOW:
HOW:
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
CHECK:
CHECK:
EMBED:
EMBED:
Add to the guide that you created last lesson, showing how to fix a cell in a spreadsheet.
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.