Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Guest house rental rates excel

04/11/2020 Client: papadok01 Deadline: 3 days

EX16_XL_CH01_GRADER_ML1_HW - Guest House Rental Rates 1.6_Instructions.docx
Grader - Instructions Excel 2016 Project

EX16_XL_CH01_GRADER_ML1_HW - Guest House Rental Rates 1.6
Project Description:
You manage a beach guest house in Ft. Lauderdale containing three types of rental units. Prices are based on peak and off-peak times of the year. You need to calculate the maximum daily revenue for each rental type, assuming all units are rented. In addition, you need to calculate the discount rate for off-peak rental times. Finally, you will improve the appearance of the worksheet by applying font, alignment, and number formats.

Steps to Perform:
Step

Instructions

Points Possible

1

Start Excel. Download and open the file named e01_grader_h2.xlsx.

0

2

Apply the Heading 1 cell style to the range A1:G1.

5

3

Apply the 20% - Accent1 cell style to the range A2:G2.

5

4

Merge and center Off-Peak Rentals in the range E4:G4.

5

5

Apply Blue fill color (the eighth color below Standard Colors) and White, Background 1 font color to the cell E4.

5

6

Center and wrap the headings on row 5.

6

7

In cell D6, enter a formula that calculates the Peak Rentals Maximum Revenue by multiplying the No. Units by the Per Day value.

6

8

In cell G6, enter a formula that calculates the Discount Rate for the Off-Peak rental price per day. For example, using the peak and off-peak per day values, the studio apartment rents for 80% of its peak rental rate. However, you need to calculate and display the off-peak discount rate, which is .19973.

8

9

Copy the formula in cell D6 to cells D7:D8. Copy the formula in cell G6 to cells G7:G8.

4

10

Format the range C6:F8 with Accounting Number Format.

6

11

Format the range G6:G8 in Percent Style with one decimal place.

6

12

Apply Blue, Accent 1, Lighter 80% fill color to the range E5:G8.

4

13

Select the range C5:D8 and apply a custom fill color with Red 242, Green 220, and Blue 219. Note, Mac users, in the Colors dialog box, click the Color Sliders tab and then select the RGB Sliders.

5

14

Answer the first question below the worksheet data. Apply Yellow highlight color to the correct answer in either cell A16, A17, or A18.

5

15

Answer the second question below the worksheet data. Apply Yellow highlight color to the correct answer in either cell A22, A23, or A24.

5

16

Answer the third question below the worksheet data. Change XX.X% to the correct percentage in cell A28.

5

17

Select Landscape orientation, center the data horizontally on the page, and apply the setting to fit to one page.

5

18

Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side.

5

19

Create a copy of the Rental Rates worksheet, place the new sheet to the right side of the original worksheet, and rename the new sheet as Formulas.

5

20

On the Formulas worksheet, display cell formulas, and set options to print gridlines and headings.

5

21

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Rental Rates, Formulas. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0

Total Points

100

Created On: 07/05/2019 1 EX16_XL_CH01_GRADER_ML1_HW - Guest House Rental Rates 1.6

sparrow_e01_grader_h2.xlsx
Rental Rates
Beachfront Guest House
Effective May 1, 2018
Peak Rentals Off-Peak Rentals
Rental Type No. Units Per Day Maximum Revenue Per Day Maximum Revenue Discount Rate
Studio Apartment 6 149.95 120 720
1 Bedroom Suite 4 250.45 174 696
2 Bedroom Suite 2 450 247.55 495.1
Questions & Answers
Assume all 12 units are rented as you answer the following questions:
(1) Which rental type generates the most maximum revenue for peak rental periods?
Apply Yellow highlight to the correct answer below:
Studio Apartment
1 Bedroom Suite
2 Bedroom Suite
(2) Which rental type generates the most maximum revenue for off-peak rental periods?
Apply Yellow highlight to the correct answer below:
Studio Apartment
1 Bedroom Suite
2 Bedroom Suite
(3) Why is there a difference?
Change XX.X to the correct values at the end of the following sentence.
The Studio Apartment is discounted only 20% for off-peak periods, whereas the 1 Bedroom Suite is discounted XX.X%.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Grade Essay
Essay Writing Help
Writer Writer Name Offer Chat
Top Grade Essay

ONLINE

Top Grade Essay

Working on this platform from a couple of time with exposure of dynamic writing skills gathered with years experience on different other websites.

$62 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$62 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Team powers xps pro v2 - 978 1 133 52685 8 - What is 58.9 kg in stones and pounds - Topics in Engineering Administration - Week 4 Discussion Forum: Pathophysiology - Ground state vs excited state electron configuration worksheet - Jones blair paint case study - The hanoverians family tree - Vocabulary - Jb hi fi rangehoods - Jane has a checkbook balance of 68.00 she - Class 2 Assessment 2,3, and 4 - Mini car club of nsw - Case study - 509 week 2summary - Ethicalpaper - Sheraton grand chennai wiki - What Is The Meaning Of Finance? What Are The Different Branches Of Finance? - Law and ethics chapter 7 review answers - The world of music journal online - Demand and supply analysis of maruti suzuki - Pet class java program - Was it necessary to re formulate new coke - 1 mile fitness test - I will not be commanded sons of anarchy song lyrics - Principles of Marketing Reflection Essay - Discussion 3c2 - Scheherazade poem analysis - Tae40116 workbook answers - Mental health clearance letter template - Willowbrook school case study answers - How does shylock feel about the outcome of the trial - How to critique a presentation - Perie public health - Health Information Management System Week 1 Project - How to cite fasb codification in apa - Which of the following typifies decision making in bands? - Vertical analysis is also known as - Note: At the end of Module 8, you will have a final project of putting together a survey report. This paper will include a supportive rationale for your survey, survey instrument, data file, and analysis plan. - Odds of yellowstone erupting - 34 pin connector on motherboard - Constant dividend growth model calculator - Worksheet - Silver chain continence referral - Ethics test. - Resource based view apple - Spd 200 classroom management matrix - 560 paper - Prior to 1931 typical hollywood studios modeled this organizational structure - Critical study of literature year 11 - Duel at araluen epub download - What is intentional rounding - Point hicks lighthouse cottage - Zone rv z-21.6 off-road caravan - Linear density of a string formula - Existentialism and human emotions summary - Tracy patented sewing machines and an elevator - General security access controls refer to objects rights and - Moore parker critical thinking pdf - 2013 hsc geography answers - Psalm 137 nrsv - Module 11 Final Exam - Patient-Centric Health Care Practices - Viking cruises career talks airborne recruiting pvt ltd 9 september - How did great britain combat napoleon's naval blockade - Http open lib umn edu communication - ASTLB HW - Kunstsammlungen zu weimar v elicofon - Bobby dazzler cockney slang - 4 - el fin de semana fill in the blanks with words from the list. - How to select cells a3 through f3 in excel - Ford pinto fuel tank 1977 - Discussion - ITM Capstone - Gas turbine iso rating - Formation of ch4 equation - Excelsior credit by exam - Descriptive statistics in jupyter notebook - Cliff notes for warriors don t cry - Ethica and Legal Aspects of Nursing Practice DQ 1 student reply Javier Roche - July 27 2003 kelowna ufo - Which statement correctly describes a step up transformer - Characteristics of integer programming problems - English 102 - 63.6 kg in lbs - Physics classroom static electricity - How to find the height of a rectangular box - Assignments - Lumenier universal mini led distribution board - Tommy hilfiger marketing mix - Meal planning for lipids - A manufacturing company reports the following items - Schoolrack com sign up handout - Ethical responsibilities of the employer - The growth of cities worksheet - Dear sir in arabic - 1000 flowers auctioned per second in holland - Amazon supply chain management strategy - Bloomberg terminal software free download - Sunrise model by madeleine leininger