SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 22 Nov 2017 My Price 10.00

complete the excel sheet Each step is important to the final result.

Please follow the steps to complete the excel sheet. Each step is important to the final result. Thank you.

  • EXP ECH01 H3 - Guest House Rental Rates 1.1

     

    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.

     

    Instructions:

    For the purpose of grading the project you are required to perform the following tasks:

    Step

    Instructions

    Points Possible

    1

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

    0.000

    2

    Merge and center the Peak Rentals title in the range C4:D4.

    5.000

    3

    Apply Dark Red fill color and White, Background 1 font color to cell C4.

    5.000

    4

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

    5.000

    5

    Apply Blue fill color and White, Background 1 font color to the cell E4.

    5.000

    6

    Center and wrap the headings on row 5.

    6.000

    7

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

    6.000

    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.000

    9

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

    4.000

    10

    Format the range C6:F8 with Accounting Number Format.

    6.000

    11

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

    6.000

    12

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

    4.000

    13

    Select the range C5:D8 and apply a custom fill color with Red 242, Green 220, and Blue 219.

    6.000

    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.000

    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.000

    16

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

    5.000

    17

    Answer the fourth question below the worksheet data. Type the value in cell A31. If you change any values in the worksheet to answer the question, change them back to their original values.

    2.000

    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.000

    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 Copy.

    6.000

    20

    Select Landscape orientation and select the options to print gridlines and row and column headings on the Copy worksheet.

    6.000

    21

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

    0.000

     

    Total Points

    100.000

     

     

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 22 Nov 2017 12:11 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)