Students use the Insert Function tool to find the missing answers in the light blue cells. This lesson will teach you how to insert and edit charts and also teach you the following functions:

SUM

AVERAGE

MAX

MIN

COUNTIF

**Files open in Microsoft Excel and are fully editable.

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

This lesson is contained within my Microsoft Excel Skills Bundle. Click on the link below to view this bundle.

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 Excel Skills Bundle

Microsoft PowerPoint Skills Bundle

Microsoft Word Skills Bundle

Microsoft Outlook Skills Bundle

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

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

-TechCheckLessons

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