Answered step by step
Verified Expert Solution
Link Copied!

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 ... 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

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Accounting questions