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

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

Activity Based Cost Management In Government

Authors: Gary Cokins

2nd Edition

1567261817, 978-1567261813

More Books

Students also viewed these Accounting questions

Question

What committees does the person serve on?

Answered: 1 week ago

Question

Write a Python program to check an input number is prime or not.

Answered: 1 week ago

Question

LO6 Define harassment and the role that HR plays in addressing it.

Answered: 1 week ago