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

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 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.
Background image of page 1
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

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