Win7 system Excel maximum, minimum and average function skills

First, the maximum function MAX

1, in the edit field to enter =, pay attention to every function they have to Input =, then enter the function MAX (to be capitalized), use the mouse to select the range;

2. Click OK to get the maximum sales in January;

3, according to the method in the figure Drag the cursor to find the maximum sales for the month. Note that if you want the cursor to appear black cross, drag it again to succeed. See if all the maxima have appeared.

Second, the minimum function MIN

1, the minimum and maximum values ​​are similar, also enter = in the edit field, then enter the function MIN (to be capitalized), use the mouse to select the range.