Open the file SalesExcelHandsOn; save it in your account area.

This Excel document contains the monthly automobile sales data for three regions – Region 1, Region 2, and Region 3. Perform the tasks listed below.

Perform Formatting as specified below:

1.     The spreadsheet title “Sales” in row 1 must be Arial font style, size 16, in italics; it is merged and centered across columns A through E.

2.     Labels in column A and in row 2 must be bold.

3.     Widen column A so all the labels in it fit.

4.     Select the range B3:E14, then select Accounting format.

Enter Formulas to do the following:

1.     Compute the total sales for each month, in cells E3 to E8.

2.     Compute the regional total sales in cells B10 to D10, and the grand total sales for all six months in E10.

3.     Compute the average monthly sales (of data in rows 3 through 8) in cells B12 to E12.

4.     Compute the highest monthly sales (of data in rows 3 through 8) in cells B13 to E13.

5.     Compute the lowest monthly sales (of data in rows 3 through 8) in cells B14 to E14.

6.     Count the number of months that made sales above the average for each region

7.     Count the number of months that made sales below the average for each region

Create a Chart

Create a pie chart of the regional average sales (B12:D12) for each region (B2:D2). Position the chart to the right of the spreadshe

SophiaPretty

(5)

Status NEW Posted 04 Dec 2017 08:12 AM My Price 7.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)

• Buy Answer