Home / Answered Questions / WPC 300 / wpc300-assignment-1-excel-fundamentals-q-988

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

WPC300

Assignment 1: Excel Fundamentals

Started: Jan 2021

Quiz Instructions

Actions

Change the submission file name to: YourFirstName_YourLastName_Assignment1.xlsx

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)

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:

• 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:

• 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?

• \$105
• 0
• \$150
• \$35

Question 5              2.5 pts

What type of the room did Carlyle Charleston stay in?

• Bay window
• Luxury
• Ocean View

Question 6             2.5 pts

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

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

Choose a File

Question 8               2.5 pts

Which room type generated the largest total revenue?

• Side
• Luxury
• Ocean
• Bay-window

Question 9        2.5 pts

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

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

Choose a File

We have an Answer from Expert