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

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