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 5 Question 3 Discussion

Actual exam question for Microsoft's exam

Question #: 3
Topic #: 5

[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 ''Orders'' worksheet, enter a formula in cell J2 that uses an Excel function to return the ''OrderTotal'' value of the individual order that has the highest ''OrderTotal'' value.

A1. Select the cell J2 where you want the highest ''OrderTotal'' value to be.

B1. Select the cell J2 where you want the highest ''OrderTotal'' value to be.

Show Suggested Answer

Suggested Answer: A

References:

https://support.office.com/en-us/article/calculate-the-smallest-or-largest-number-in-a-range-45fe249f-96c3-443b-8e9f-87f16c48462c

by Jolene at May 04, 2022, 05:54 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!