TPT
Total:
$0.00
IF Functions and Formulas Activity for Microsoft Excel
IF Functions and Formulas Activity for Microsoft Excel
IF Functions and Formulas Activity for Microsoft Excel
IF Functions and Formulas Activity for Microsoft Excel
IF Functions and Formulas Activity for Microsoft Excel
IF Functions and Formulas Activity for Microsoft Excel
IF Functions and Formulas Activity for Microsoft Excel
IF Functions and Formulas Activity for Microsoft Excel
Share

Description

A brief activity designed to teach students the following Microsoft Excel skills:

Simple IF Functions

IF

SUMIF

AVERAGEIF

COUNTIF

**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.

IF Functions and Formulas Activity for Microsoft Excel

Rated 4.67 out of 5, based on 9 reviews
4.7 (9 ratings)
TechCheck Lessons
2.3k Followers
$1.50

Highlights

Digital downloads
Grades icon
Grades
8th - 11th
Pages
5
Answer Key
Included
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

A brief activity designed to teach students the following Microsoft Excel skills:

Simple IF Functions

IF

SUMIF

AVERAGEIF

COUNTIF

**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

4.7
Rated 4.67 out of 5, based on 9 reviews
9
ratings
All verified TPT purchases
Rated 3 out of 5
February 22, 2024
It is really short not enough for a whole day or even part of a lesson, could use more.
Brandon E.
9 reviews
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 4 out of 5
September 18, 2022
Great resource for Excel.
Tracy Sritairat
(TPT Seller)
134 reviews
Grades taught: 9th
Rated 5 out of 5
July 25, 2022
A great activity in a general computers class to begin to introduce students to concepts that lead into programming.
JT H.
1,226 reviews
Grades taught: 10th, 11th, 12th
Rated 5 out of 5
January 3, 2022
It has been years since I have used IF statements, so this was a good review for myself before I have to teach it to my students.
Stephanie H.
533 reviews
Rated 5 out of 5
August 18, 2021
This was perfect for my adult work force training students. They loved this resource!
Angie S.
47 reviews
Grades taught: , Adult Education
Rated 5 out of 5
July 28, 2021
A great resource, thank you.
Roxanne H.
1,070 reviews
Grades taught: 9th
Rated 5 out of 5
January 29, 2020
Wonderful resource!
AikenforKnowledge
(TPT Seller)
79 reviews
TechCheck Lessons
Response from
TechCheck Lessons
(TPT Seller)
Jan 30, 2020
Thanks so much for your kind words!

Questions & Answers

Loading
Loading