Page 100 - Computer - 6

3. Type the name of the function in the Search for a function text box and click the Go button.

A list of functions appears.

3

4

4. In the Select a function box, select the function that you 5
want to insert and click the OK button.
The Function Arguments dialog box opens.
5. Specify the arguments for the function.
6. Click the OK button.
Excel displays the result of the function in the selected cell. 6

Lab Activity 1
Experiential Learning
To calculate the total runs,
average runs, maximum runs, and
minimum runs scored by each
player in a series of five matches.

1. Prepare the worksheet as
shown.

2. Click cell H3.
3. On the Formulas tab, click the Insert Function button.
The Insert Function dialog box opens.

4. In the Select a function box, select the SUM function.

98