formulas and functions - part 3

Calculating the average using Insert Function

Let's calculate the average number of working hours per day in a week by searching for a function using Insert Function.
If you don’t know the function's category, you can search for the function.

1. Click the cell in which you want to calculate the average. In this case, click cell G11.

2. Click Insert Function in the Function Library on the Formulas tab.

Insert Function dialog box appears.

	In the Insert Function dialog box, you can search for the function you want to use. We want to calculate the average number of working hours, don’t we?
	Yes.
	Then let's enter “average” in the Search for a function!

3. Enter “average” in Search for a function.

4. Click Go.

Candidates for the keyword “average” appear in Select a function.

5. Select a function. Information about the selected function appears. In this case, AVERAGE is selected.

6. Click OK.

The Function Arguments dialog box appears.

Tip: What is the Function Arguments dialog box? Some functions need information in order to calculate. For example, to calculate the average number of working hours, you need to have each of the numbers of working hours on which to perform the calculation. “Argument” refers to this information, and you need to enter this information in the Function Arguments dialog box in order to use the function. The contents of the arguments vary depending on the function. Some functions don’t need any arguments.

7. The calculation range is automatically recognized and displays in Number 1.

Let's change the range for calculating the total working time including overtime hours. Select the Total column in the table.

8. The necessary arguments for calculating the total working time using the AVERAGE function have been entered. Click OK.

Tip: Help on this function If you need more information about the function, click Help on this function. The Excel Help window opens to display detailed information about the function. This includes a description, syntax, remarks, etc. The following picture is the Excel Help windows displaying the information of AVERAGE function.

The average number of working hours is displayed.