Blades - Units Sold Northeast East Southeast Midwest...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chexel Key: 49c5588e37385d3454b2eef2e1394db3e Banner: 391668 First Name: Caitlin Last Name: McCurdy Email: [email protected]
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1. Enter Chexel information. 2. Find the sum in cells C10:I10 . 3. Find the average in cells C16:I16 . 4. Find the minimum for cells C22:I22. 5. Find the maximum for cells C28:I28 . 6. Set page orientation to landscape . 7. Enter a header that has "Balance Sheet" written in the middle. 8. Enter a footer that has the current page number centered in the footer. 9. Change the margins to 1" all around. 10. Change the page setup to where the page is centered vertically. 11. Insert a comment in cell A18 that says, "Need more in northwest region." 12. Apply the AutoFormat Classic 2 to cells A5:I28. 13. Hide the Blades workbook. 14. Unhide the Blades workbook. 15. Save as "Blades" to home folder and to dropbox. 16. Please make sure you have your Chexel information on, the full email address including @acu.edu and your banner number.
Background image of page 2
Balance Sheet 3 Davis Blades Sales Report 1/1/2006 - 12/31/2006
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Units Sold Northeast East Southeast Midwest Southwest West All Regions Black Hawk Qtr 1 641 748 733 676 691 783 4,272 Qtr 2 708 826 811 748 763 866 4,722 Qtr 3 681 795 780 719 734 833 4,542 Qtr 4 668 779 764 705 720 816 4,452 Total 2,698 3,148 3,088 2,848 2,908 3,298 17,988 Blademaster Qtr 1 513 598 587 541 552 627 3,418 Qtr 2 567 661 648 598 611 693 3,778 Qtr 3 545 636 624 575 587 666 3,633 Qtr 4 534 623 611 564 576 653 3,561 AVG 540 630 618 570 582 660 3,598 The Professional Qtr 1 342 399 391 361 368 418 2,279 Qtr 2 378 441 432 399 407 462 2,519 Qtr 3 363 424 416 383 391 444 2,421 Qtr 4 356 415 407 376 384 435 2,373 MIN 342 399 391 361 368 418 2,279 All Models Qtr 1 1,496 1,745 1,711 1,578 1,611 1,828 9,969 Qtr 2 1,653 1,928 1,891 1,745 1,781 2,021 11,019 Qtr 3 1,589 1,855 1,820 1,677 1,712 1,943 10,596 Qtr 4 1,558 1,817 1,782 1,645 1,680 1,904 10,386 MAX 1,653 1,928 1,891 1,745 1,781 2,021 11,019...
View Full Document

This note was uploaded on 04/29/2008 for the course MGMT 120 taught by Professor Lynn during the Fall '08 term at Abilene Christian University.

Page1 / 3

Blades - Units Sold Northeast East Southeast Midwest...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online