Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In cell H13, create a formula using the DAVERAGE function to determine the average price of Amazing Amazon tours, using the range Lookup[#All] as the

  1. In cell H13, create a formula using the DAVERAGE function to determine the average price of Amazing Amazon tours, using the range Lookup[#All] as the database, Price as the field, and the range G11:G12 as the criteria.
Tour Code Tour Depart Date Price Seats Reserved Tour Information
758H Pacific Odyssey 1/12/2018 $ 2,255 20 Tour Code 966W
120A Amazing Amazon 1/13/2018 $ 2,466 18 Tour
431V Amazing Amazon 2/22/2018 $ 2,134 15 Depart Date
762N Hiking Patagonia 2/28/2018 $ 2,812 15
215C Pearls of the Orient 3/13/2018 $ 2,350 15 Price
251D Silk Road Travels 3/19/2018 $ 2,110 19 < 2000
966W Photographing France 3/20/2018 $ 1,755 20 Number of Tours
830L Old Japan 3/23/2018 $ 2,450 22
245M African National Parks 4/8/2018 $ 3,115 10
334Q Experience Cambodia 4/11/2018 $ 2,441 21 Tour
325B Biking in France 4/15/2018 $ 1,900 19 Amazing Amazon
754Q Amazing Amazon 4/23/2018 $ 1,925 20 Average Price
543Y Catalonia Adventure 5/9/2018 $ 2,587 17
556J Treasures of Ethiopia 5/18/2018 $ 1,638 5
675Y Monasteries of Bulgaria 5/20/2018 $ 1,663 11
544T Biking in France 5/23/2018 $ 1,635 10
778W Magnificent Montenegro 5/27/2018 $ 1,890 4
446R Catalonia Adventure 6/9/2018 $ 2,100 15
677Y Nepal Trekking 6/9/2018 $ 4,200 18
433Q Corfu Sailing Voyage 6/10/2018 $ 2,190 10
335V Amazing Amazon 8/23/2018 $ 2,877 18

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 Manufacturing And Service Applications

Authors: Arnold Schneider, Harold M. Sollenberger

4th Edition

0759350426, 978-0759350427

More Books

Students also viewed these Accounting questions

Question

What is the formula used for computing BIC?

Answered: 1 week ago

Question

What is involved in the administration of a labor agreement?

Answered: 1 week ago

Question

What are topics included in virtually all labor agreements?

Answered: 1 week ago