When working with numerical data in a Microsoft Excel spreadsheet, which is better: formulas or functions? Pupils discover the answer through a short, instructional video.  First, scholars learn about the parts of a function and discover how they differ from formulas. Next, they see how to use AutoSum and the Insert Function command.

Concepts

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

Show More Show Less

Instructional Ideas

• Have learners create their own tutorials about how to use functions in Excel 

Classroom Considerations

• Each student requires a computer and headphones if watching individually
• Discusses some advanced mathematical and technical concepts; may need to play several times
• 15th of 27 videos from the Microsoft Excel 2016 set
  

• This video is hosted on YouTube

Pros

• Provides a text lesson resource
• Narrator speaks clearly and slowly for maximum comprehension 

Cons

• None

Common Core

SL.9-10.3 SL.11-12.3