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

Info iconThis 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 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
Background 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 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

This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.

Ask a homework question - tutors are online