Win7 system Excel Maximum, minimum and average function usage skill

Win7 system Excel Maximum, minimum and average function usage skill

One, max value function max

1, in the formula bar first input =, note that each function must first input =, then enter the function max (to capitalize), with the mouse to select the range;

2, click to determine the largest January sales;

3, according to the figure method, drag the cursor can find the month's maximum sales. Note that if you want the cursor to appear black cross then drag before you can succeed. See if all the maximum values are present.

Second, the Minimum value function min

1, the minimum and the maximum value similar to the same in the formula bar first input =, and then enter the function min (to capitalize), with the mouse to select the range.