{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch03qz01a

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

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

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
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

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern