Business Applications

Not a customer? Learn More


Estimated Time:15 minutes

Score Type:Auto Score

This lesson automatically provides a score to your gradebook

Available Languages: English, Spanish

Vocabulary: cell range, formula, function, function library, function tool, numerical formula, spreadsheet, summation function

Primary Objectives:

  • Student learns to use functions in a spreadsheet.
  • Student learns the correct notation and format to use functions in a spreadsheet.
  • Student is introduced to the functions for mathematical sum, mean, minimum, and maximum.
  • Student learns how to apply a function across multiple cells.
  • Student is introduced to the function library and how to use the function tool.
  • Student gains additional experience using the summation command.
  • Student learns to specify cell ranges in functions in a spreadsheet.
  • Student gains additional experience using numerical formulas in a spreadsheet.

Secondary Objectives:

  • Student will learn to use digital tools to gather, organize and evaluate information.
  • Student will understand and be able to use functions in spreadsheets.
  • Student will gain more experience using the different tools available in spreadsheet software.
  • Student will learn how to work more efficiently in a spreadsheet program by using automated functions when analyzing data.



Mathematics > Number Operations > Mean > Arithmetic

Data Collection for Decision Making

Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making 

Digital Literacy > Student Use > Data Collection for Decision Making 


Mathematics > Statistics Probability > Computation/Technology > Displays

Graphic Organizers (Venn Diagrams,etc.) 

Information Technology > Software Applications > Graphic Organizers (Venn Diagrams,etc.) 


Mathematics > Statistics Probability > Data > Maximum/Minimum


Mathematics > Number Operations > Computation/Technology > Spreadsheets


Mathematics > Statistics Probability > Computation/Technology > Spreadsheets


Information Technology > Software Applications > Spreadsheets


Information Technology > Software Applications > Spreadsheets 

Technical / Specialized

Language Arts > Communication > Listening Strategies / Context > Content Specific > Technical / Specialized

Use appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically
Show More

Teacher Notes:

  • Functions are generally harder to grasp than formulas, despite the function simply being a more automated version of a formula. Copying and pasting sometimes is not as intuitive for students. Students will need practical experience with the functions available, but it may be best to limit focus to the mean, minimum, and maximum functions. Introduce other functions as needed.

Extension Ideas:

  • Students can break into groups or pairs to explore and experiment using a function available in the function library. The instructor can assign the specific functions randomly or allow students to choose, but try to avoid having too many teams covering the same functions. Teams can teach the class how to use the function in a brief presentation or demonstration.


S.5.b Students collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.
2-DA-08 Collect data using computational tools and transform the data to make it more useful and reliable. (P6.3)
Math.Practice.MP5 Use appropriate tools strategically.
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards