Can Excel AZ Testler Formulas Data New Teb Revi Share Home Insert Page Layout Table Name Summarise with Pivot Table Remove Duplicates Reside Table Convert to Range Properties Tools Table Tools Help Design Tel me what you want to do 2 Header Row First Column Total Row Last Column Banded Rows Banded Columns Table Style Option Export Refresh Denali Tales Make K M N 0 2009 A9 Make 28 Harley Davidson 29 Honda 10 Toyota 31 Ford 12 Ford 33 Chevrolet 14 Jeep 35 Chevrolet 36 Mitsubishi 17 Honda Ford 39 Dodge 40 Chevrolet 4 Model Sportster Gold Wing Tacoma Ranger Mustang Camaro Wrangler Impala Diamante Civic Body Year Motorcycle Motorcycle 2010 pickup 2008 Pickup 1995 Sport 2000 Sport 2005 Convertible 2005 Sedan 4-door 2009 2000 Pickup 15 Coupe 2005 2004 Color Black Red Black Black White White White Maroon Blue Mileage Price 82,000 $ 7,500.00 76,000 S 10,100.00 75,000 $ 14,000.00 125,000 $4,700.00 171.0007,500.00 115,000 $8.000.00 112,000 $ 10.200.00 112,000 S 6,100.00 61,000 519,000.00 145000 3,200.00 138000 S 3,700.00 137,000 $3,300.00 158,000 S 7,200.00 Inspected No NO No NO NO No Yes Yes Yes Yes White Silver Intrepid Silverado Yes Car Inventory Ready O 00:28:52) Go To Summary Project 1 of 7: Car Inventory Restart Project Submit Project UE 5 The Discounted Price is 95 percent of the "Price o Enter a formula in cells 10:40 that calculates the "Discounted Price for each car, Mark Complete Mark for Review Mark for Feedback Type here to search O