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. 

Concepts

basic computer skills, spreadsheet skills, microsoft excel, computer software, technology resources

Show More Show Less

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

Common Core

SL.9-10.3 SL.11-12.3