AdollcDc AaBbCcDc AaBb 1 Normal 1 No Spac... Heading 1 Editing Dictate Paragraph Styles Voice bu need to calculate the Average Days on Lot based on MSRP and/or Types using the ventory data n. Enter functions into the Average Days on Lot chart area that calculate the following: Insert a function in K10 that display the Average Days on Lot of all Types Insert a function in L10 that display the Average Days on Lot of all Types that have a color of Red Insert a function in M10 that displays the Average Days on Lot of all Types that have a GPS Insert a function in N10 that displays the Average Days on Lot of all Types that have a MSRP that is higher than 20000 and have a Color of White 0. Save the Workbook Focus DO == Lb Paste Calibri 11 A A BIU-E-A-A- 23 Wrap Text Merge & Center - Number $ - % 19 8.68 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font honen Nuwber N10 * for D G H I E F VIN Search Special Notes 6/18/2017 2 VIN 69716460 Arrival Date Raffle Eligible GPS Yes No Gray No Yes VIN: 1 Year Type Color 69716460 2018 Sedan Red 61234473 2017 Coupe Red 916891001 2017 Coupe White 234771381 2017 Truck White 951767431 2018 SUV 51905311 2018 Coupe Blue 24926742 2018 SUV White 34689659 2017 Sedan Red 65864983 2018 Van Red 24948740 2018 Sedan Black 50481896 2017 Truck Black 200076321 2018 Van Black 79067608) 2018 sedan Red 24509603 2017 Truck White 1306528112017 SUV Blue 33563307 2017 Van 14601 l lor Inventory Scenario Summary Inventory Arrival Date 16/18/2017 11/16/2017 12/28/2017 10/9/2017 9/4/2017 13/15/2017 2/20/2017 2/8/2017 7/15/2017 1/21/2017 10/3/2017 8/25/2017 18/7/2017 12/10/2017 14/4/2017 15/24/2017 Ten MSRP $ 24.989 $ 35,903 S 23,623 3 $ 22,848 S 19,841 S 24,463 S 30.946 S 19,918 S 34,718 S 17.511 S 24,452 S 37,516 S 33,695 $ 26.057 S 26,534 $ 31,193 Le 116 Days on Lot Special Notes 192 Raffle Eligible 46 9 84 119 292 Bonus Eligible 315 Bonus Eligible 327 Bonus Eligible 170 Raffle Eligible 345 Bonus Eligible 90 129 Raffle Eligible 147 Raffle Eligible 22 272 Bonus Eligible 222 Bonus Eligible 16 Yes Yes INo NO NO TIT 19 20 21 22 Read Type here to search AdollcDc AaBbCcDc AaBb 1 Normal 1 No Spac... Heading 1 Editing Dictate Paragraph Styles Voice bu need to calculate the Average Days on Lot based on MSRP and/or Types using the ventory data n. Enter functions into the Average Days on Lot chart area that calculate the following: Insert a function in K10 that display the Average Days on Lot of all Types Insert a function in L10 that display the Average Days on Lot of all Types that have a color of Red Insert a function in M10 that displays the Average Days on Lot of all Types that have a GPS Insert a function in N10 that displays the Average Days on Lot of all Types that have a MSRP that is higher than 20000 and have a Color of White 0. Save the Workbook Focus DO == Lb Paste Calibri 11 A A BIU-E-A-A- 23 Wrap Text Merge & Center - Number $ - % 19 8.68 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font honen Nuwber N10 * for D G H I E F VIN Search Special Notes 6/18/2017 2 VIN 69716460 Arrival Date Raffle Eligible GPS Yes No Gray No Yes VIN: 1 Year Type Color 69716460 2018 Sedan Red 61234473 2017 Coupe Red 916891001 2017 Coupe White 234771381 2017 Truck White 951767431 2018 SUV 51905311 2018 Coupe Blue 24926742 2018 SUV White 34689659 2017 Sedan Red 65864983 2018 Van Red 24948740 2018 Sedan Black 50481896 2017 Truck Black 200076321 2018 Van Black 79067608) 2018 sedan Red 24509603 2017 Truck White 1306528112017 SUV Blue 33563307 2017 Van 14601 l lor Inventory Scenario Summary Inventory Arrival Date 16/18/2017 11/16/2017 12/28/2017 10/9/2017 9/4/2017 13/15/2017 2/20/2017 2/8/2017 7/15/2017 1/21/2017 10/3/2017 8/25/2017 18/7/2017 12/10/2017 14/4/2017 15/24/2017 Ten MSRP $ 24.989 $ 35,903 S 23,623 3 $ 22,848 S 19,841 S 24,463 S 30.946 S 19,918 S 34,718 S 17.511 S 24,452 S 37,516 S 33,695 $ 26.057 S 26,534 $ 31,193 Le 116 Days on Lot Special Notes 192 Raffle Eligible 46 9 84 119 292 Bonus Eligible 315 Bonus Eligible 327 Bonus Eligible 170 Raffle Eligible 345 Bonus Eligible 90 129 Raffle Eligible 147 Raffle Eligible 22 272 Bonus Eligible 222 Bonus Eligible 16 Yes Yes INo NO NO TIT 19 20 21 22 Read Type here to search
