# (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)

Question 2

2.5 pts

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

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:

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?

\$450

\$135

\$150

0

Question 5

2.5 pts

What type of the room did Carlyle Charleston stay in?

Ocean View

Bay window

Luxury

Question 6

2.5 pts

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

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.

Question 8

2.5 pts

Which room type generated the largest total revenue?

Side

Ocean

Bay-window

Luxury

Question 9

2.5 pts

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

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

Choose a File

We have an Answer from Expert