Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help it's due soon Note: As you complete these steps, you should frequently save your changes. 1. Start Excel and open a blank workbook.

please help it's due soon

image text in transcribed
Note: As you complete these steps, you should frequently save your changes. 1. Start Excel and open a blank workbook. In the location where you store your files, save the file as Lastname Firstname with your name. 2. Enter the following data in the specified cells: Al: Pro Fit Miami A2: First Quarter Cardio Sales A4: Stationary Bikes A5: Stair Steppers A6: Treadmills A7: Elliptical Machines A8: Total B3: January 3. With cell B3 active, use the fill handle and drag to cell D3 to auto fill in other months 4. 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 5. In cells B8:D8, calculate the total sales for each month. 6. In cell E3, type Total and in cells E4:E7, calculate the total sales for each item 7. In cell F3, type Trend 8. Merge and Center cells Al:F1 and A2:F2. 9. Apply the Accounting Number Format to cells B4:E4 and B8:E8. 10. Apply the Comma Style to cells B5:17. 1 1. Insert a new row between rows 2 and 3 and in cell A3, type As of March 31 12, Insert a new column between columns A and B. 13. In cell B4, type Warehouse Site in cells B5, B6, and B9, type Miami and in cells B7 and B8, type Jacksonville 14. Find Average, Maximum and Minimum without including the Totals 15. Add footer with the tags cardio sales your course and section as the subject and your name as the author. 16. Create a column chart based on the worksheet numbers 17. Save your worksheet. 18. Perform a spell check of the entire worksheet and make necessary corrections. 19. Submit the worksheet on the link provided on Moodlel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: David Spiceland, Wayne M. Thomas, Don Herrmann

5th edition

1259914895, 978-1259914898

More Books

Students also viewed these Accounting questions