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, 2 Days 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 23 Nov 2017 My Price 10.00

Submitted my solutions two times but received a low score

Cannot figure out what I did wrong. Submitted my solutions two times but received a low score each time. Please complete and send back solution. Thank you.

  • EXP ECH01 H2 - Restaurant Receipt 2.3

     

    Project Description:

    Matt, the owner of Matt’s Sports Grill in Toledo, Ohio, asked you to help him create a receipt spreadsheet that he can use until his new system arrives. He wants an input area for the total food and beverage purchases, the sales tax rate, and the tip rate. The formatted receipt should include the subtotal, tax, tip, and total amount for a customer.

     

    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_h2.xlsx.

    0.000

    2

    Merge and center the Input Area title over the range A1:B1.

    5.000

    3

    Apply bold and Blue, Accent 1, Lighter 40% fill color to the range A1:B1.

    5.000

    4

    Apply the Accounting Number Format to cell B2.

    4.000

    5

    Apply the Percent Style with one decimal place to cells B3:B4.

    4.000

    6

    Use Format Painter to copy the formats of the title in cell A1 to D1.

    4.000

    7

    Change the width of column D to 17.

    4.000

    8

    Indent the Subtotal and Tip Amount  labels twice each.

    4.000

    9

    In cell E4, enter a formula that repeats the value in cell B2. Do not type the value; use a formula.

    5.000

    10

    In cell E5, enter a formula to calculate the product of the Food & Beverages (in column E) and the Sales Tax Rate.

    5.000

    11

    In cell E6, enter a formula to calculate the Subtotal of the Food & Beverages (in column E) and the Sales Tax Amount.

    5.000

    12

    In cell E7, enter a formula to calculate the Tip Amount based on the Subtotal and the Tip Rate.

    5.000

    13

    In cell E8, enter a formula to calculate the Total Bill based on the Subtotal and the Tip Amount.

    5.000

    14

    Apply Comma Style and Single Accounting Underline to the Sales Tax Amount and Tip Amount values in cells E5 and E7.

    6.000

    15

    Apply the Double Accounting Underline style to the Total Bill value in cell E8.

    3.000

    16

    Set a 1.5-inch top margin and center the data horizontally on the page.

    6.000

    17

    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.

    6.000

    18

    Create a copy of the Receipt worksheet, move the new sheet to the end, and then rename the copied sheet as Formulas.

    6.000

    19

    Display cell formulas on the Formulas worksheet.

    6.000

    20

    Select Landscape orientation and select the options to print gridlines and headings.

    6.000

    21

    Adjust the width of column C to 5.

    6.000

    22

    Ensure that the worksheets are correctly named and placed in the following order in the workbook: Receipt, Formulas. 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 23 Nov 2017 11:11 AM 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)