ch06test01a - $1,000 $2,524.92 $111,000 $7.50 $100...

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 06 - Test 01 $ Amount Tax Due $33,000 $4.88 $100 $1,608.75 $30,000 $110.70 $1,000 $3,321.00 $47,000 $37.50 Mill per $1 $1,762.50 0.001 $56,000 $113.70 Mill per $1 $6,367.20 0.001 $66,000 $66.75 $1,000 $4,405.50 $71,000 $110.25 $1,000 $7,827.75 $81,000 $16.65 $1,000 $1,348.65 $96,000 $4.35 $100 $4,176.00 $106,000 $23.82
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $1,000 $2,524.92 $111,000 $7.50 $100 $8,325.00 $136,000 $75.75 $1,000 $10,302.00 Directions: a. Enter multimath formulas in Column D to calculate the Tax Due. b. Format Column D for Currency, 2 Decimal places, and $. Assessed Value $100/ $1,000/ Mill c. Save the file as ch06test01a.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