Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the data set found here (try right-clicking and opening in new tab for easier viewing - image is also shown below) select the proper

image text in transcribed
image text in transcribed
Given the data set found here (try right-clicking and opening in new tab for easier viewing - image is also shown below) select the proper function (to include syntax and inputs) to provide the desired results as defined. To return the exact phrase "Order" 125444 sold by Gill included 27 Pens at 19.99 each for a total of 539.73 you would use the formula. For Order\#120137, to return the exact phrase "The sale of 95 units is greater than 150 dollars" if the total value of the units sold is greater than 150 dollars or "The sale of 95 units is less than 150 dollars" if the total value of the units sold is less than 150 dollars, the formula you would use is For order number 124307, to return the exact phrase "Order was completed on 11/25/18 for 479.04 which is greater than 5 other orders.", using formulas that would lookup the order number and count the number of orders with a greater total than order 124307 , you would use the formula

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Susan V. Crosson, Belverd E. Needles

10th edition

1133940595, 978-1133940593

More Books

Students also viewed these Accounting questions