Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-assignment-1-excel-fundamentals-graduates-inn-guest-database-q-720

(Solved): WPC 300 : Assignment 1: Excel Fundamentals-Graduates' Inn Guest database...



JAN 2021 UPDATE HERE 


WPC300

 Excel Fundamentals

Question 1

2.5 pts

Provide a screenshot that shows the 3 additional columns indicated in the assignment guidelines (one page is sufficient)

Upload 

Question 2

2.5 pts

When categorizing the total revenue by room type, we can use which of the following Excel capabilities:

Group of answer choices

All of the answer selections are correct

Sumif() function

Pivot Table

Either a pivot table or the Sumif() function

Question 3

2.5 pts

The type of match to use in a Vlookup() function to assess the resort fee as a possible additional cost for a particular room is:

Group of answer choices

An approximate match

A fuzzy match

An exact match

None of the answer sections are correct

Question 4

2.5 pts

What daily rate did Carlyle Charleston pay?

Group of answer choices

$450

$135

$150

0

Question 5

2.5 pts

What type of the room did Carlyle Charleston stay in?

Group of answer choices

Quincy Adams

Ocean View

Bay window

Luxury

Question 6

2.5 pts

What was the total revenue for the Graduates Inn in December?

Group of answer choices

None of the other answers is true

$23,128.95

$23,985.50

$20,751.45

Question 7

2.5 pts

Provide a screenshot of the pie chart that shows the divide of the total revenue in December by room type. Ensure that the percentages for each slice are shown.

Upload 

Question 8

2.5 pts

Which room type generated the largest total revenue?

Group of answer choices

Side

Ocean

Bay-window

Luxury

Question 9

2.5 pts

What was the total of revenue for the Bay-Window rooms in December?

Group of answer choices

$14,861.90

$3,257.05

None of the other answers is true

$5,010.00

Question 10

2.5 pts

Upload the excel file with all sheets that you created to answer the above questions. Don't forget to add your name to the filename. 

Upload 

Choose a File

 



We have an Answer from Expert View Expert Answer

Expert Answer


We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $20 / Month