New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Microsoft Exam 77-727 Topic 6 Question 2 Discussion

Actual exam question for Microsoft's exam

Question #: 2
Topic #: 6

[All Questions]

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.

A1. Select cell N2 on the ''Customers'' worksheet, which is where you want the Excel function to return the result to.

B1. Select cell N2 on the ''Customers'' worksheet, which is where you want the Excel function to return the result to.

Show Suggested Answer

Suggested Answer: A

References:

https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B-8F33EB960CF6

by Elly at May 05, 2022, 09:55 PM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!