First Quarter Cardio Sales, accounting homework help
Instructions: Complete the following
- Enter the following data in the specified cells:
A1: Pro Fit Miami
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowA2: First Quarter Cardio Sales
A4: Stationary Bikes
A5: Stair Steppers
A6: Treadmills
A7: Elliptical Machines
A8: Total
B3: January
- With cell B3 active, use the fill handle and drag to cell D3.
- Increase the width of column A to 125 pixels and center the text for the three months.
- Enter the following data in the specified cells:
B4: 88930.25 C4: 84434.20 D4: 69675
B5: 12563 C5: 22572.33 D5: 34459.45
B6: 22478.11 C6: 45128.45 D6: 36913
B7: 45764.12 C7: 46124.28 D7: 45934.17
- In cells B8:D8, calculate the total sales for each month.
- In cell E3, type Total and in cells E4:E7, calculate the total sales for each item and in cell E8, calculate the total of totals.
- In cell F3, type Trend
- Merge and Center cells A1:F1 and A2:F2.
- Apply the Title cell style to cell A1.
- Apply the Heading 2 cell style to cell A2.
- Apply the Heading 4 cell style to the column titles and row titles.
- Apply the Total cell style to cells B8:E8.
- Apply the Accounting Number Format to cells B4:E4 and B8:E8.
- Apply the Comma Style to cells B5:E7.
- Apply the Slice theme to the workbook.
"Looking for a Similar Assignment? Order now and Get 15% Discount! Use Code "FIRST15"
