ch08qz01a - c. Enter formulas in Column E 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 ______________________________ Chapter 08 - Quiz 01 Cost $96.70 25.0% $24.18 $120.88 $128.93 $57.58 10.4% $5.99 $63.57 $64.26 $3.64 36.0% $1.31 $4.95 $5.69 $16.57 55.0% $9.11 $25.68 $36.82 $6.78 14.2% $0.96 $7.74 $7.90 $78.12 20.0% $15.62 $93.74 $97.65 $10.50 12.0% $1.26 $11.76 $11.93 $11.56 10.8% $1.25 $11.67 $12.96 Directions: a. Enter formulas in Column C to calculate Markup Amount. b. Enter formulas in Column D to calculate Selling Price when Markup Rate is based on Cost.
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 formulas in Column E to calculate Selling Price when Markup Rate is based on Selling Price. d. Format Column C through Column E for Currency. Set Decimal places to 2. Set Currency to $. Markup Rate Markup Amount Selling Price Markup Rate Based on Cost Selling Price Markup Rate Based on Selling Price e. Save the file as ch08qz01a.xls. A B C D E 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