Câu 2: 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

SIMULATION -Project 1 of 7: Tailspin Toys -Overview -You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data. 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.

1. A. See explanation below. 1. Select cell N2 on 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-047BAC88-D466-426C-A32B-8F33EB960CF6 — đáp án hiện tại