ch06test01a

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

This preview shows page 1. Sign up to view the full content.

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

{[ snackBarMessage ]}

Ask a homework question - tutors are online