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
There are 3 Steps involved in it
Step: 1
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