Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the data below please anwser all the questions below. Please show the forumla used in excel!! Thank you and the fast I get this

Using the data below please anwser all the questions below. Please show the forumla used in excel!! Thank you and the fast I get this the better! I will give thumbs up.

image text in transcribed

Guest Corporatation Room Type Cost Nights Stayed
M Choi Acme King 284 4
J Bond United Inc. Deluxe 435 9
S Sheldon MGM Queen 215 2
G Jones SPS Inc Queen 225 13
R Greene Range Inc Suite 335 4
T Bingham Range Inc King 284 1
B Wilfong ITO Inc Queen 215 2
P Dolan WWH Inc King 284 3
L Patel SPS Inc Dsuite 525 5
M Hall OPM Inc Deluxe 435 6
J Hoffmann Talent Inc QSuite 305 8
E Blech Standard 175 14
L Gleason Queen 215 2
C. Torger King 305 4
K Hough DriveIT Inc Deluxe 475 7
E Betof Goody Inc QSuite 325 8
F Feldman Leading Inc Suite 350 8
M Small Charm Inc Queen 250 10
1) Classify the nights stayed as Good if the nights are from 0-9 Better Better if the nights are from 10-12 Best Best if nights are 13 or over A) Classify the nights stayed using a NestedIF in Column F B) Classify the nights stayed using a Vlookup with an approximate match in Column G Be sure to build you table array for the Vlookup appropriately. 2) Name your Table Array "Classification" 3) In column H, create a simple IF formula to determine if the Room Type is a King. Show the word "King" if a King, otherwise show nothing

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

Entity Alignment Concepts Recent Advances And Novel Approaches

Authors: Xiang Zhao ,Weixin Zeng ,Jiuyang Tang

1st Edition

9819942527, 978-9819942527

More Books

Students also viewed these Databases questions

Question

What are the advantages of planning ?

Answered: 1 week ago

Question

Explain the factors that determine the degree of decentralisation

Answered: 1 week ago

Question

What Is acidity?

Answered: 1 week ago

Question

Explain the principles of delegation

Answered: 1 week ago

Question

State the importance of motivation

Answered: 1 week ago