ch03qz02a

# ch03qz02a - 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 02 Marsch’s Auto Supply Sales Department 2001 2002 125-854 \$21,375.61 \$24,354.52 \$2,978.91 13.9% 24.4% 759-864 \$14,357.84 \$16,948.51 \$2,590.67 18.0% 17.0% 579-846 \$12,457.85 \$15,264.59 \$2,806.74 22.5% 15.3% 531-426 \$2,453.68 \$6,352.00 \$3,898.32 158.9% 6.4% 796-364 \$8,561.43 \$13,467.64 \$4,906.21 57.3% 13.5% 246-951 \$25,852.25 \$23,568.89 -\$2,283.36 -8.8% 23.6% Total \$85,058.66 \$99,956.15 \$14,897.49 17.5% 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 ch03qz02a.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 ]}

Ask a homework question - tutors are online