1. What is the sale price for the item with an original selling price of $49.79?

Round your answer to the nearest cent. $

2.

What is the sale price and markdown rate for the leather/vinyl rocker?

Sale price:	$
Markdown rate: (Round to one decimal place)

sc5 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin | Chapter 9-Exercise 06 Chapter 9- Exercise 06 Selling Price Sunny's Casual Patio Furniture Sale Price Markdown Rate S329.99 S115.00 $12700 S240.49 $190.75 S135.60 45% 27% 89% 20% 64% 10 12 13 15 Directions: a. Enter formulas in Column B to calculate Sale Price 16 for each item shown in Column A. b. Format Column B for Currency, 2 Decimal places, 17 and $ 18 C. Save the file as ch09ex06a xlsx. 19 20 23 ch09ex06.xlsx - +100% O Type here to search 10:10 AM 4 ENG 3/10/2019 ch09ex05 (1) [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin Chapter 09 . Exercise 05 Chapter 09 - Exercise 05 Beir's Furniture Shoppe Original Sale Price Markdown Markdown Item Rate Selling Price $608.00 $143.00 $159.00 S1,017.00 $699.00 $555.00 $1,999.00 Amount 6 Dining set $353.00 $69.00 $99.00 Counter stool 8 Men's valet 9 Bombe chest 10 Leather/inyl rocker 11 Chairlottoman set 12 Leather sofa 13 Wing chair $418.00 $300.00 $299.00 $1,299.00 S56.00 15 Directions: 16 a. Enter formulas in the appropriate columns to calculate the missing information. 17 b. Format Columns C and D for Currency, 2 Decimal places, and S 18 C. Format Column D for Percentage with 1 Decimal place 19 d. Save the file as ch09ex05a.xlsx 20 21 23 25 ch09ex05.xlsx - +100% 1011 AM O Type here to search 4 ENG 3/10/2019