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 29 Nov 2017 My Price 10.00

stabilization equipment that Pro Fit Marietta is marketing.

Excel document need help with. You will find an attachment with instructions as well as the excel document to format

  • GO! ECH01 H2 - Balance Sales 2.1

     

    Project Description:

    In the following project, you will create a worksheet summarizing the sales of balance and stabilization equipment that Pro Fit Marietta is marketing.

     

    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 balance sales

    0.000

    2

    Merge and center the title and then the subtitle across columns A:F and apply the Title and Heading 1 cell styles, respectively.

    8.000

    3

    Check spelling in your worksheet, and correct Silde to Slide. Widen column A to 180 pixels and columns B:F to 95 pixels.

    8.000

    4

    In cell E4, construct a formula to calculate the Total Sales of the Balance Pillow by multiplying the Quantity Sold by the Retail Price. Copy the formula down for the remaining products.

    10.000

    5

    Select the range E4:E10, and then use the Quick Analysis tool to sum the Total Sales for All Products, which will be formatted in bold. To the total in cell E11, apply the Total cell style.

    10.000

    6

    Using absolute cell references as necessary so that you can copy the formula, in cell F4, construct a formula to calculate the Percent of Total Sales for the first product. Copy the formula down for the remaining products.

    10.000

    7

    To the computed percentages, apply Percentage Style with two decimal places, and then center the percentages.

    8.000

    8

    Apply the Comma [0] style to the Quantity Sold figures. To cells D4, E4, and E11, apply the Accounting Number Format.

    8.000

    9

    To the range D5:E10, apply the Comma Style.

    4.000

    10

    Change the Retail Price of the Slide Board to 75.50 and the Quantity Sold of the Balance Pad to 150.

    4.000

    11

    Delete column B.

    6.000

    12

    Insert a new row 3. In cell A3, type Month Ending March 31 and then merge and center the text across the range A3:E3. Apply the Heading 2 cell style.

    8.000

    13

    To cell A12, apply the 20% - Accent1 cell style.

    4.000

    14

    Select the four column titles. Apply Wrap Text, Middle Align, and Center formatting, and then apply the Heading 3 cell style.

    8.000

    15

    Center the worksheet horizontally on the page, and then insert the file name in the footer in the left section. Return the worksheet to Normal view, if necessary.

    4.000

    16

    Save and close the workbook. Exit Excel. Submit the file as directed.

    0.000

     

    Total Points

    100.000

     

     

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 29 Nov 2017 02: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)