Day 6 - Average, Max, Min
Entering function with AutoSum
A fast and convenient way to enter the SUM function is with the sum button in the Editing group on the Home tab. The Sum button (also referred to the AutoSum feature) quickly insert Excel functions that summarize all the values in a column or row using a single statistic. With the Sum button, you can insert the SUM, AVERAGE, COUNT, MIN, and MAX functions to generate the following:
- Sum of the values in the column or row
- Average value in the column or row
- Total Count of numeric values in the column or row
- Minimum value in the column or row
- Maximum value in the column or row
- Sum of the values in the column or row
- Average value in the column or row
- Total Count of numeric values in the column or row
- Minimum value in the column or row
- Maximum value in the column or row
Case | Global Site GPS
Kevin Hodge is a production assistant at Global Site GPS, a leading manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin’s job is to monitor output at the company’s five regional plants. He wants to create an Excel workbook that reports the monthly production at the five sites, including monthly average, minimum, and maximum production and total production for the previous year. He asks you to create the workbook that reports these statistics.
Instruction File
|
Data File RequiredThe file on the left side is an instruction file. Click on Download File to open the file. Once opened, print a copy to get started. This particular assignment requires a data file to start. After printing the instruction file, go to the Data Files tab and open "Global" workbook to start.
If you're working in the classroom, you may find the Data File in the Share drive. |