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.
Click here to open and print out the instruction.
___________________________________________________________________________
Case | Grade Book
___________________________________________________________________________
In this exercise, you will be creating the Grade book from scratch. Click here to open and print out the Grade book template.
