{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch08qz01a

ch08qz01a - c Enter formulas in Column E to calculate...

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

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

{[ snackBarMessage ]}

Ask a homework question - tutors are online