{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch07qz01a

# ch07qz01a - c Enter a formula in Cell F17 to compute the...

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 07 - Quiz 01 Invoice No. 5467-5455 Order No. 89-11-23 Date 2/17/2002 Sales No. 21-83 Terms 3/10, n/30 Item Quantity Total SKU44522 Label Maker 6 \$9.99 \$59.94 SKU47025 Laser/Inkjet Paper 4 \$8.99 \$35.96 SKU46215 Ballpoint Pens 3 \$39.99 \$119.97 SKU46174 Leather Attache Case 3 \$49.99 \$149.97 SKU46243 Shredder 4 \$29.94 \$119.76 SKU12240 Copy Paper 9 \$2.68 \$24.12 List Price \$509.72 Less Returns \$23.20 \$486.52 Subtotal with Discount \$471.92 Sales Tax—6.3% \$29.73 Subtotal \$501.66 Shipping Charges \$46.59 Total Amount Due \$548.25 Directions: a. Enter a formula in Cell F15 to calculate the List Price. b. Enter a formula in Cell F16 to compute the subtotal Less Returned merchandise.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: c. Enter a formula in Cell F17 to compute the Subtotal with the Discount. d. Enter a formula in Cell F18 to compute the Sales Tax. e. Enter a formula in Cell F19 to calculate the Subtotal with Sales Tax amount. f. Enter Shipping Charges of \$46.59 in Cell F20. g. Enter a formula in Cell F21 to calculate the Total Amount Due. h. Format for Currency. Set Decimal places to 2. Set Currency symbol to \$. Stock Number Unit Price i. Save the file as ch07qz01a.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 21 22 23 24 25 26 27 28 29 30 31 32 33...
View Full Document

{[ snackBarMessage ]}