Microsoft Excel 2010
  • Home
  • Daily Lessons
    • Day Two
    • Day Three
    • Day Four
    • Day Five
    • Day Six
    • Day Seven
    • Day Eight
    • Day Nine
    • Day Ten
    • Day Eleven
    • Day Twelve
    • Day Thirteen
    • Day Fourteen
  • Data Files
  • Answer Keys
  • Tutorial
  • Survey
  • Resource
  • Contact

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

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

global_site_instruction.pdf
File Size: 17 kb
File Type: pdf
Download File

Data File Required

The 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.
Seattle Goodwill | 1400 S. Lane St. Seattle, WA 98144 | 206 860 5791 | www.seattlegoodwill.org