TPT
Total:
$0.00
Cell References Lesson Activity for Teaching Microsoft Excel
Cell References Lesson Activity for Teaching Microsoft Excel
Cell References Lesson Activity for Teaching Microsoft Excel
Cell References Lesson Activity for Teaching Microsoft Excel
Cell References Lesson Activity for Teaching Microsoft Excel
Cell References Lesson Activity for Teaching Microsoft Excel
Share

Description

Students will learn 3 basic cell references:

Relative Cell References

Absolute Cell References

Cell References From Another Worksheet

**Files open in Microsoft Excel and are fully editable if you so choose..

***************************************************************************************

This lesson is contained within my Microsoft Excel Skills Bundle.

Other individual Microsoft Excel Skills you may be interested in:

Basic Functions and Formulas Lesson

Cell References Lesson

Conditional Formatting Lesson

Dates, Alignment, Pictures, Cell Styles Lesson

Formatting Cells Lesson

Hyperlinks and Images Lesson

IF Functions and Formulas Lesson (IF, SUMIF, COUNTIF, AVERAGEIF)

Intermediate Functions and Formulas Lesson (AND, OR, RIGHT, LEFT)

Nested IF THEN Functions and Formulas Lesson

Pixel Art Lesson

VLOOKUP Functions and Formulas Lesson

Vocabulary Definitions Slideshow

Working With Charts Lesson

Working With Tables Lesson

Wedding Playlist SmartArt Lesson

Microsoft Excel Vocab Quiz and Word List

Defining Name Ranges

Protecting Your Workbooks Activity

Microsoft Excel Text and Math Functions Activity

************************************************************************

Other Microsoft Office Product Bundles Available:

Microsoft Office Lesson Plan Mega Bundle - Word PowerPoint Excel Outlook

Microsoft Excel Skills Bundle

Microsoft PowerPoint Skills Bundle

Microsoft Word Skills Bundle

************************************************************************

Thanks for visiting my store! Don't forget to FOLLOW ME for new product announcements, sales, promotions and updates!

TechCheckLessons is not affiliated with Microsoft Corp.

Product names, logos, brands, and other trademarks featured or referred to within this lesson are the property of their respective trademark holders.

These trademark holders are not affiliated with my store. They do not sponsor or endorse the contents, materials or processes discussed within this lesson.

Terms of Use:

************************************************************************

This document is for personal use only and may only be used by the original purchaser. Copying for more than one teacher, classroom, department, school, or school district is prohibited. Additional licenses can be purchased at a discount for others to use in your department. You may not electronically distribute or post this product online where it can be accessed by the public (school INTRANET site that only students can access is fine like Google Classroom, Blackboard or Canvas). Failure to comply is a copyright infringement and a violation of the Digital Millennium Copyright Act (DMCA).

Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT's content guidelines.

Cell References Lesson Activity for Teaching Microsoft Excel

TechCheck Lessons
2.3k Followers
$1.00

Highlights

Digital downloads
Grades icon
Grades
8th - 11th
Pages
3
Teaching Duration
30 minutes

Save even more with bundles

Perfect for teaching a Microsoft Excel course! Editable lessons, activities, projects & exam preps. Great for MOS Excel certification exam training from Certiport too.Files open in Microsoft Excel so you can edit them to your liking. Optimized for Excel 2019, 2021 / 365 & 2016. (Will also
Price $20.00Original Price $30.00Save $10.00
20
Perfect for teaching a Microsoft Office course! Editable lessons, activities, projects & exam preps build student knowledge of Word, PowerPoint, Excel & Outlook. Excellent for Microsoft Office Specialist (MOS) certification exam training (through Certiport) if that is a goal of your class. C
Price $49.99Original Price $133.50Save $83.51
102

Description

Students will learn 3 basic cell references:

Relative Cell References

Absolute Cell References

Cell References From Another Worksheet

**Files open in Microsoft Excel and are fully editable if you so choose..

***************************************************************************************

This lesson is contained within my Microsoft Excel Skills Bundle.

Other individual Microsoft Excel Skills you may be interested in:

Basic Functions and Formulas Lesson

Cell References Lesson

Conditional Formatting Lesson

Dates, Alignment, Pictures, Cell Styles Lesson

Formatting Cells Lesson

Hyperlinks and Images Lesson

IF Functions and Formulas Lesson (IF, SUMIF, COUNTIF, AVERAGEIF)

Intermediate Functions and Formulas Lesson (AND, OR, RIGHT, LEFT)

Nested IF THEN Functions and Formulas Lesson

Pixel Art Lesson

VLOOKUP Functions and Formulas Lesson

Vocabulary Definitions Slideshow

Working With Charts Lesson

Working With Tables Lesson

Wedding Playlist SmartArt Lesson

Microsoft Excel Vocab Quiz and Word List

Defining Name Ranges

Protecting Your Workbooks Activity

Microsoft Excel Text and Math Functions Activity

************************************************************************

Other Microsoft Office Product Bundles Available:

Microsoft Office Lesson Plan Mega Bundle - Word PowerPoint Excel Outlook

Microsoft Excel Skills Bundle

Microsoft PowerPoint Skills Bundle

Microsoft Word Skills Bundle

************************************************************************

Thanks for visiting my store! Don't forget to FOLLOW ME for new product announcements, sales, promotions and updates!

TechCheckLessons is not affiliated with Microsoft Corp.

Product names, logos, brands, and other trademarks featured or referred to within this lesson are the property of their respective trademark holders.

These trademark holders are not affiliated with my store. They do not sponsor or endorse the contents, materials or processes discussed within this lesson.

Terms of Use:

************************************************************************

This document is for personal use only and may only be used by the original purchaser. Copying for more than one teacher, classroom, department, school, or school district is prohibited. Additional licenses can be purchased at a discount for others to use in your department. You may not electronically distribute or post this product online where it can be accessed by the public (school INTRANET site that only students can access is fine like Google Classroom, Blackboard or Canvas). Failure to comply is a copyright infringement and a violation of the Digital Millennium Copyright Act (DMCA).

Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT's content guidelines.

Reviews

5.0
Rated 4.97 out of 5, based on 7 reviews
7
ratings
Grades used with
Reviews
3
4
4
4
9th
10th
11th
12th
All verified TPT purchases
Rated 5 out of 5
January 30, 2024
Absolute references is so hard for my students to learn - but this was helpful I used as a warmup
Sunde HOrton
(TPT Seller)
517 reviews
Grades taught: 10th, 11th, 12th
Rated 5 out of 5
May 18, 2023
This was a great mini assignment to introduce MS Excel functions. Thank you for sharing
Adriana K.
647 reviews
Grades taught: 9th, 10th, 11th
Rated 5 out of 5
May 9, 2023
I bought this product along with 3 others to use in a mini-Excel unit for my Introduction to Engineering class. I like the variety of activities that it exposes the students to and the fact that I don't really have to teach them anything before they dig in and start working. The instructions are sufficient from them to work on their own, at their own pace, while I walk to the room for troubleshooting help.
Melissa M.
50 reviews
Grades taught: 12th
Rated 5 out of 5
December 16, 2022
I was looking for something to challenge my students. This was perfect.
Shelley F.
1 review
Grades taught: 9th, 10th, 11th, 12th
Rated 5 out of 5
April 18, 2022
Great resource!
Ashley S.
32 reviews
Grades taught: 9th, 10th, 11th, 12th
Rated 5 out of 5
April 20, 2017
Great simple lesson. Thanks.
Jodi Staggers
(TPT Seller)
106 reviews
TechCheck Lessons
Response from
TechCheck Lessons
(TPT Seller)
Apr 21, 2017
Thank you!
Rated 4.8 out of 5
February 12, 2017
Great, quick lesson!
Krystal Moberly
(TPT Seller)
13 reviews
TechCheck Lessons
Response from
TechCheck Lessons
(TPT Seller)
Feb 13, 2017
Thanks!

Questions & Answers

Loading
Loading