Ch06qz01a - $1,508.60 $100,000 $5.00 $100 $5,000.00 $125,000 $50.50 $1,000 $6,312.50 Directions a Enter multimath formulas in Column D to calculate

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 ______________________________ $ Amount Tax Due $22,000 $3.25 $100 $715.00 $19,000 $73.80 $1,000 $1,402.20 $36,000 $25.00 Mill per $1 $900.00 0.001 $45,000 $75.80 Mill per $1 $3,411.00 0.001 $55,000 $44.50 $1,000 $2,447.50 $60,000 $73.50 $1,000 $4,410.00 $70,000 $110 $1,000 $7,700.00 $85,000 $2.90 $100 $2,465.00 $95,000 $15.88 $1,000
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,508.60 $100,000 $5.00 $100 $5,000.00 $125,000 $50.50 $1,000 $6,312.50 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 ch06qz01a.xls. A B C D E F G 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