{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch03qz01a - between 2001 and 2002 Format Column D for...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 03 - Quiz 01 Connie’s Department Store Sales Department 2001 2002 15-524 $521,131.23 $604,344.97 $83,213.74 16.0% 22.9% 13-024 $354,118.87 $312,497.45 -$41,621.42 -11.8% 11.8% 87-645 $197,887.12 $187,946.75 -$9,940.37 -5.0% 7.1% 18-349 $279,446.91 $289,338.78 $9,891.87 3.5% 10.9% 16-761 $675,315.54 $684,951.64 $9,636.10 1.4% 25.9% 12-852 $574,568.21 $565,753.25 -$8,814.96 -1.5% 21.4% Total $2,602,467.88 $2,644,832.84 $42,364.96 1.6% 100.0% Directions: Dollar Increase/ Decrease Percent Increase/ Decrease Percent of Total 2002 Sales a. Enter formulas in Column D to calculate the Dollar Increase or Decrease for each Department
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: between 2001 and 2002. Format Column D for Currency. Set Decimal places to 2. Set Currency symbol to $. b. Enter a formula in each cell in Column E to calculate the Percent of Increase or Decrease. Format Column E for Percentage. Set Decimal places to 1. c. Enter formulas in Column F to calculate the Percent of Total 2002 Sales contributed by each Department. Format Column F for Percentage. Set Decimal places to 1. d. Save the file as ch03qz01a.xls. A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern