Curated and Reviewed by
Lesson Planet
What are the two main types of cell references in Excel? Scholars discover the answer through a short instructional video that models how to create and copy formulas using relative and absolute references. Additionally, users explore how to reference cells across worksheets from the same workbook.
3 Views
2 Downloads
CCSS:
Adaptable
Concepts
Instructional Ideas
- Have partners quiz each other about using absolute and relative cell references in Excel
Classroom Considerations
- Contains some complicated concepts
- Provide each student with a computer and headphones, or use speakers and projection for whole-class viewing
- 14 of the 27-part Microsoft Excel 2016 series
- This video is hosted on YouTube
Pros
- Includes a text-based lesson resource
- Guides viewers in a step-by-step tutorial using screen sharing
Cons
- None