On the "Customers" worksheet, enter a formula in cell N2 that uses an Excel function to return the average age of the customers based on the values in the "CurrentAge" column.

Explanation: First, locate the "Customers" worksheet, which is where you want the Excel function to return the result to. 2. In the Address bar, type the average function syntax: =AVERAGE(K1:K101). References…

Manage Tables and Lists

Question

On the "Customers" worksheet, enter a formula in cell N2 that uses an Excel function to return the average age of the customers based on the values in the "CurrentAge" column.

Explanation

Explanation: First, locate the "Customers" worksheet, which is where you want the Excel function to return the result to. 2. In the Address bar, type the average function syntax: =AVERAGE(K1:K101).

References: https://support.office.com/en-us/article/AVERAGE-function-047BAC8B-D466-426C-A32B-8F33BE8960C6

Topics

#AVERAGE function#column formula#worksheet formula#aggregate function

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice