Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 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
★★★★★
3.47 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
formula by using DCOUNT function to Count the number of ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started