Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please included detailed steps with functions for

please included detailed steps with functions for each step ...

70.2K

Verified Solution

Question

Accounting

please included detailed steps with functions for each step image
image
The purpose of this assignment is to create a worksheet that will allow the user to select a check in date and check out date for a hotel of their choice (Holiday Inn, Hyatt, Marriott or Hilton). Based on their choice, the total price for the stay will be displayed in cell H9. In order to make this work, you need to do the following: 1. Create a table called Hotels from the range in cells A4:E35. 2. Create a drop list using data validation in cell H5. The list should allow for the dates in column to be chosen. Repeat this step for H6 3. Create a drop down list using data validation to show each of the possible hotel names in cell H7 4. In cell J5, extract an array from the Hotels table that contain all of the prices for the hotel chosen in cell H7. Hint: Use the INDEX and XMATCH functions or the INDIRECT function. 5. In cell K5, create a logic create a logic array that will indicate which rows in the Hotels table fall between the two selected dates. This is done by typing the following formula in cell K5: =(Hotels[Date]>=H5)( Hotels[Date]

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Finance
1.2K views

12.Preston invested $19,750 in the stock market three years ago with hopes that it would grow...

Physics
1.2K views

I was wondering where I can get a more or less complete set of a galaxy...

Finance
1.2K views

Calculate the Net Present Value given two proposed projects of AIM Manufacturing Corp. Project # 1: Initial Investment:...

Accounting
1.2K views

Apple has the following at Jan 1, 2018 2,000,000 shares of common stock issued and $1...

Geometry
1.2K views

A pilot flies in a straight path for 1 h 30 min She then makes...

Geometry
1.2K views

1 Determine the surface area of a cylinder with a diameter of 10 in and...

Calculus
1.2K views

cot (?) Suppose ? ? ? 3?/2.If tan (?)=, what are sin (?), cos (?),...

Algebra
1.2K views

The function fis defined as f x 7 2x2 4 Find f x 6 Write...

Accounting
1.2K views

Exercise 11-3 (Algo) Transfer Pricing Basics [LO11-3] Sako Company's Audio Division...

Accounting
1.2K views

Requirement 1. Journalize the adjusting entries on December 31. (Record debits first, then credits. Select...

Accounting
1.2K views

Below find you will find summarized financial statements for Kroger. Using the ratio template discussed...

Accounting
1.2K views

Can someone explain to me how to get these answers? really struggling on homework and...