Tom's Place

Kitchen Department Prices

Item, Westside Store, East Valley Stroe, Difference $,$Total per Item, Discount $\%,$ Discounted Total

ITEMS WESTSIDE STORE EAST VALLEY STORE

Drawer Storage $29\mathrm{.}9919\mathrm{.}96$

Cabinet Organizer $62\mathrm{.}9299\mathrm{.}97$

Countertop Organizer $44\mathrm{.}7457\mathrm{.}36$

Pull Out Cabin $22\mathrm{.}9713\mathrm{.}96$

Sink Accessories $38\mathrm{.}2229\mathrm{.}97$

Drawer Organizer $109\mathrm{.}7799\mathrm{.}93$

Kitchen Carts $515\mathrm{.}31488\mathrm{.}21$

Stackable Organizer $49\mathrm{.}8644\mathrm{.}81$

Total per Store

THIS ARE THE INSTRUCTIONS BELOW

Project Description:

In this project, you will create a worksheet to calculate the discount prices in the kitchen department of a retail store. You will calculate the total prices in the department at different store locations, and the percentage of an expected discount per location.

Steps to Perform:

Step Instructions Points Possible

$1$ Start Excel. Download and open the file named Student$\_$Excel$\_01\_$SA$\_$Prices$\_$AS$.$xlsx$.$ Save the file as Last$\_$First$\_$Excel$\_01\_$SA$\_$Prices$\_$AS$.0$

$2$ Merge and Center the range A$1$:G$1.$ Apply the cell style Accent$4$ to the merged cell, and increase the font size to $16.$ Merge and Center the range A$2$:G$2.$ Apply the $40\%-$ Accent$4$ cell style. $11$

$3$ Adjust the width of column A to $20.$ Adjust the widths of columns B:G to $16.0$

$4$ Apply Bold formatting to the column and row labels. Center align the row $3$ labels. $5$

$5$ In cell D$4,$ type a formula that subtracts the East Valley Store price from the Westside Store price. In cell E$4,$ type a formula that adds the Westside Store price to the East Valley Store price. AutoFill the formulas in the range D$4$:E$4$ down through row $14.8$

$6$ In row $15,$ insert the function to provide totals for columns B:E$.5$

$7$ In F$4$ enter $\mathrm{.}001,$ and in F$5$ enter $\mathrm{.}002.$ Use the range F$4$:F$5$ to fill the series down through F$14.$ Format the range F$4$:F$14$ with the Percent Style number format, and $1$ decimal displayed. $6$

$8$ Insert a new column between F and G$.$ Type the column label Discount Amount. Create a formula in cell G$4$ calculating the discount by multiplying Total per Item and Discount $\%.$ Copy the result in cell G$4$ down through row $14.$

$10$

$9$ In cell H$4,$ type a formula that subtracts the Discount Amount from the Total per Item to calculate the Discounted Total. AutoFill the formula down through row $14.$ Insert a function in G$15$:H$15$ to total the columns.

$5$

$10$ Format the ranges B$4$:E$4,$ B$15$:E$15,$ G$4$:H$4,$ and G$15$:H$15$ with the Currency cell style. $7$

$11$ Format the ranges B$5$:E$14$ and G$5$:H$14$ with the Comma cell style. $4$

$12$ Format the ranges B$15$:E$15$ and G$15$:H$15$ with the Total cell style. $4$

$13$ Insert a new row above row $15.$ In cell A$15,$ type Spice Organizer in cell B$15$ type $37\mathrm{.}20$ and in C$15$ type $29\mathrm{.}74.$ Fill the series in F$13$:F$14$ down through cell F$15.$ Copy the range G$14$:H$14$ down through row $15.$ Edit the formulas in the range G$16$:H$16$ to include the values in G$15$:H$15.10$

$14$ Rename the Sheet$1$ tab as Prices. $4$

$15$ Use the Spelling and Grammar dialog box to correct any spelling errors. $6$

$16$ Add the file name field in the worksheet$$s left footer. Add the date field to the center footer, and the sheet name field to the right footer. Return to Normal view.

$6$

$17$ Set the scaling width to print on $1$ page and gridlines to print. Center the worksheet horizontally on the page. $9$

$18$ Save and close the Last$\_$First$\_$Excel$\_01\_$SA$\_$Prices$\_$AS$.$xlsx file. Close Excel and any other open windows. Submit the file as directed. $0$

Total Points $100$