Previously, you created named ranges for all of the columns in the Employees worksheet. These named ranges can be used in formulas and functions in place of cell references. Doing this can make the formulas and functions easier to understand and, at the same time, reduce the chance of error.
To the right of the data, use a function and a named range to calculate the average salary of all employees.
To select cell N2,
Click in cell N2
To add the column header, type:
Average Salary Enter key
Now that the column header is there, go ahead and add the function to calculate the average salary.
The active cell should be N3. This works well.
To begin using the AVERAGE function, in cell N3, type:
To use a named range to complete the function, type:
Current_Salary) Enter key
The average employee salary, 51577.78, appears in cell N3. Unfortunately the currency formatting is not automatically applied. This can be easily remedied.
To select cell N3,
Click in cell N3
To format the cell as currency, on the Home tab, in the Number group,
Click , Click Currency
The average salary is now formatted as currency.
Use any method to widen the columns.
To save the workbook, press:
Control key + S
The following video demonstrates a benefit of working with named ranges.