Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
To Determine the Highest Number in a Range
of Numbers Using the Insert Function Box
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
The next step is to select cell B14 and determine the highest (maximum) number in the range B4:B12.
Excel includes a function called the MAX function that displays the highest value in a range. The following
steps use the Insert Function box in the formula bar to enter the MAX function. Why? Although you could enter
the MAX function using the keyboard and Point mode as described previously, an alternative method to entering the
function is to use the Insert Function box in the formula bar.
• Select the cell to contain the maximum number, cell B14 in this case.
• Tap or click the Insert Function box in the formula bar to display the Insert Function dialog box.
• If necessary, scroll to and then tap or click MAX in the Select a function list (Insert Function dialog box) to select it
(Figure 2 – 15).
What if the MAX function is not in the Select a function list?
Click the ‘Or select a category’ arrow to display the list of function categories, select All, and then scroll down and
select the MAX function in the Select a function list.
How can I learn about other functions?
Excel has more than 400 additional functions that perform nearly every type of calculation you can imagine.
These functions are categorized in the Insert Function dialog box shown in Figure 2 – 15. To view the categories,
tap or click the ‘Or select a category’ arrow. To obtain a description of a selected function, select its name in the
Insert Function dialog box. Excel displays the description of the function below the Select a function list in the
Insert Function box
Insert Function dialog box
active cell and
‘Or select a
MAX selected in
Select a function list
Figure 2 – 15