From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using the AVERAGE(), MAX(), MIN(), and SUM() functions

Using the AVERAGE(), MAX(), MIN(), and SUM() functions

From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

Using the AVERAGE(), MAX(), MIN(), and SUM() functions

“

- [Instructor] In this video, we're going to look at calculation functions. We'll learn how to use the AVERAGE function, MAX and MIN, which are the largest and the smallest entry in a range of cells, and how to use SUM to quickly total the information in columns or rows. Let's jump right into our Summary_Functions workbook and take a look at quickly averaging our Q1 sales. I'll click in the cell below, type in =AVERAGE, notice how the auto-complete has come up and highlighted AVERAGE for me. I'll go ahead and hit Tab on my keyboard, and go in now and select the range of cells that I want to average. Excel will look at all of the cells in the range, average them together, and I'll close my parentheses. And when I hit Enter, the average of the cells is displayed in C21. Now, this is a relative reference, and that means I can copy that formula all the way across for my other columns. Now, let's take a look at how we can find the largest Q1 sales amount. I'll click in C22 and type =MAX…

Contents