Computer Applications: Microsoft Excel Lesson on Conditional Formatting w/ Test

Also included in:
  1. Lesson 1:Students are given step-by-step directions (54 slides) on how to use formulas to make calculations using football statistics. They write formulas to determine net receiving yards, average number of carries per game, average number of yards gained per game, and the percentage of total yards
    Save $4.50
  2. This is a bundle of 6 lessons from my Computer Applications class. They each include step-by-step directions for students and an assessment to evaluate their learning. Screenshots are from Microsoft 2016 (Office 365)
    Save $9.50
Product Description

Students are given step-by-step directions (33 slides) on how to use conditional formatting on a sales report in Microsoft Excel. They:

  • Program a vocabulary study sheet so that a cell turns green when they enter the correct term. This introduces the concept of conditional formatting in Excel.
  • Work with a sales report sheet and format it to color-code their best sellers, worst sellers, lowest inventory, and revenue.
  • Write simple formulas to calculate their ending inventory and their monthly revenue.
  • Use data validation to create an "Updated By" drop-down menu in their first column.
  • Create a graph in Excel from this data.
  • Complete an assessment where they are given a new set of data and directions for what sort of calculations they must program the sheet to make.
  • A rubric is included.

Answer keys included. All screenshots are from Microsoft Excel 2016 (Office 365).

For a more in-depth lesson on formulas, you might want my Microsoft Excel Lesson on Formulas.

More Computer Applications Lessons (Word, Excel, PowerPoint, Video Editing)

Computer Coding Lessons

Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere

Elements and Principles of Design Lessons

Literary Elements Lessons

English Grammar Lessons

Novel Study

Total Pages
39 pages
Answer Key
Teaching Duration
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.
Digital Download
Share this resource
Report this resource to TpT
Miss B's Shop

Miss B's Shop

More products from Miss B's Shop
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up