(Solved): WPC300 Assignment 1: Excel Fundamentals Jan 2021 update...

WPC300

Assignment 1: Excel Fundamentals

Started: Jan 2021

Quiz Instructions

Read the Assignment instructions

Actions

Start with datafile: Graduate Inn Data.xlsx

Change the submission file name to: YourFirstName_YourLastName_Assignment1.xlsx

Answer the following multiple-choice questions. 

Note: When you are asked to submit a screen capture, you need to make sure that your name is part of the capture.

When possible, use a separate excel sheet to answer the questions below. 

Question 1        2.5 pts

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

Upload 

Choose a File

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

• Either a pivot table or the Sumif() function
• All of the answer selections are correct
• Pivot Table
• 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
• None of the answer sections are correct
• A fuzzy match
• An exact match

Question 4                2.5 pts

How much resort fee above the daily rate did Carlyle Charleston pay?

Group of answer choices

• $105
• 0
• $150
• $35

Question 5              2.5 pts

What type of the room did Carlyle Charleston stay in?

Group of answer choices

• Quincy Adams
• Bay window
• Luxury
• Ocean View

Question 6             2.5 pts

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

Group of answer choices

•   $20,751.45
•  $23,985.50
• $23,128.95
• None of the other answers is true

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 

Choose a File

Question 8               2.5 pts

Which room type generated the largest total revenue?

Group of answer choices

• Side
• Luxury
• Ocean
• Bay-window

Question 9        2.5 pts

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

Group of answer choices

• $5,010.00
• $14,861.90
• $3,257.05
• None of the other answers is true

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