Ch 12: Summarize Data with Functions in Excel

About This Chapter

Explore the steps for summarizing data with functions in Excel. This set of engaging video lessons with self-assessment quizzes explains the basics of five such Excel functions.

Summarize Data with Functions in Excel: Chapter Summary

In this collection of lessons, you can learn to add, average, and count numbers in specific Excel cells or cell ranges. In addition, you can also find out the steps for finding the minimum or maximum value in chosen ranges or cells.

Experienced Excel instructors will lead you through all the necessary steps in these instructional videos. Each lesson has a brief quiz for feedback on your progress. Watch as many times as you like, or read the accompanying transcripts, until you're comfortable with these functions.

Lessons include the following:

  • Using the SUM Excel function
  • Trying the MAX and MIN functions
  • Using the COUNT function
  • Understanding the AVERAGE function

(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools, or displays may be different in other versions.)

Excel is a trademark of the Microsoft Corporation, which is not affiliated with Study.com.

Final Exam
Intro to Excel: Essential Training & Tutorials
This course currently has no final exam ready
Chapter Exam

Earning College Credit

Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.