First Quarter Cardio Sales, accounting homework help

/in /by

First Quarter Cardio Sales, accounting homework help

Instructions: Complete the following

  1. Enter the following data in the specified cells:

A1: Pro Fit Miami

A2: First Quarter Cardio Sales

A4: Stationary Bikes

A5: Stair Steppers

A6: Treadmills

A7: Elliptical Machines

A8: Total

B3: January

  1. With cell B3 active, use the fill handle and drag to cell D3.
  2. Increase the width of column A to 125 pixels and center the text for the three months.
  3. 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

  1. In cells B8:D8, calculate the total sales for each month.
  2. 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.
  3. In cell F3, type Trend
  4. Merge and Center cells A1:F1 and A2:F2.
  5. Apply the Title cell style to cell A1.
  6. Apply the Heading 2 cell style to cell A2.
  7. Apply the Heading 4 cell style to the column titles and row titles.
  8. Apply the Total cell style to cells B8:E8.
  9. Apply the Accounting Number Format to cells B4:E4 and B8:E8.
  10. Apply the Comma Style to cells B5:E7.
  11. Apply the Slice theme to the workbook.