ch01qz01a - Total 365541 53535 312,006 Directions: c. Copy...

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 01 - Quiz 01 Addison Computer Store Sales Report Year Ended December - 20-- Department Gross Sales Returns Total Sales Sales Printers 37850 9500 28,350 Scanners 16874 3280 13,594 Keyboards 4621 875 3,746 Software 25982 11000 14,982 Monitors 15326 760 14,566 Laptops 21963 12950 9,013 Computers 62485 1500 60,985 Supplies 24153 300 23,853 Books 95841 2100 93,741 Training 33248 8870 24,378 Fax 15629 1395 14,234 PDAs 11569 1005 10,564
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Total 365541 53535 312,006 Directions: c. Copy the formula down Column D. a. Format Column D for Currency. Set Decimals to zero. Set Currency symbol to None. b. Enter a formula in Cell D9 to subtract Sales Returns & Allowances from Gross Sales. d. Total Columns B, C, and D. Format totals for Currency. Set Decimals to zero. Set Currency symbol to $. e. Save the file as ch01qz01a.xls. A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29...
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