Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Finally, Camille wants to calculate the average ad amount for the Social media channel. In cell H 1 2 , create a formula using the DAVERAGE function to average the ad amounts for the Social media...

Q:

In cell H8, create a formula using the DCOUNT function to count the number of tours priced under $2,000, using the range A1:E22 as the database, Price as the field, and the range G6:G7 as the...

Q:

In cell H8, create a formula using the DCOUNT function to count the number of tours priced under $2,000, using the range A1:E22 as the database, Price as the field, and the range G6:G7 as the...

Q:

1 2 . Camille also wants to identify the number of ads that cost more than $ 1 0 0 0 . In cell H 7 , create a formula using the COUNT function to count the number of ads that cost more than $ 1 0 0 0...

Q:

18. Dean also wants to identify the number of projects that have less than $5,0G0 of funding and calculate the average funding amount of commercial projects. Create formulas that provide this...

Q:

1 2 . Camille also wants to identify the number of ads that cost more than $ 1 0 0 0 . In cell H 7 , create a formula using the DCOUNT function to count the number of ads that cost more than $ 1 0 0...

Q:

PROJECT STEPS Benicio Cortez is a financial consultant with NewSight Consulting in Denver, Colorado. He is working with DIG Technology, a company that sells five models of portable speakers to...

Q:

Benicio Cortez is a financial consultant with NewSight Consulting in Denver, Colorado. He is working with DIG Technology, a company that sells five models of portable speakers to consumers in North...

Q:

5.0Bao asks you to identify the account reps with high, average, and low evaluation scores. In the Eval Score column (range G11:G29), create a new Icon Set conditional formatting rule using the 3...

Q:

Create formulas that provide this information as follows: a . In cell J 8 , create a formula using the DCOUNT function to count the number of projects with budget amounts more than $ 1 5 , 0 0 0 ,...

Q:

The equations in Exercise 16. Redraw the phase planes for the above problem, but make the other choice for the vertical variable. Check that you get the same equilibrium. Exercise 16 Competition...

Q:

Beginning inventory, purchases, and sales data for watches are as follows: a. Assuming that a perpetual inventory system is used, costing by the FIFO method, determine the cost of goods sold for each...

Q:

The financial statement ratio that measures how rapidly accounts receivable are collected is called the .

Q:

Under what circumstances might an agency relationship terminate by operation of law? Group of answer choices The principal and agent mutually agree to dissolve the partnership The agent successfully...

Q:

What is involved in the administration of a labor agreement?

Q:

What are topics included in virtually all labor agreements?

Q:

How are the other workers likely to react toward Angelica if she chooses not to join? Discuss.