Part 1

In row 29 for each column B through M calculate the sum of values for these columns (cars sold and $ awarded) to all dealers for sales volume, shipping rebates, sales, and best in class bonuses. Format each cell in this Totals row correctly and make these cells bold. Hint: As we learned back in Assignment 1, since it is a total row you should include $ signs if that cell is money and not include it if it is a sales volume. You can use the Currency format for all of the cells but notice that if you take the $ sign out of a cells format it just converts itself to Number. This is expected and fine.

Part 2

In column O, determine (by displaying the boolean value of either TRUE or FALSE) if this dealership received money during this year for both a shipping rebate (from any quarter) AND a sales volume bonus. Copy the formula down the column to obtain the corresponding value for each dealership. Remember here that double-quoting the letters T-R-U-E like this... "TRUE" as that is a BAD thing because it creates a chunk of text out of the perfectly good boolean value of TRUE. Watch the video called TRUE vs "TRUE" for a full description. On your upcoming exam I see lots of students putting TRUE's and FALSE's in double-quotes and you will lose points for doing this!!! In this class if you ever put your TRUE 's or FALSE 's in double quotes anywhere in any formula you will be doing it wrong!!!

617 G H I J K L M N O P Q R SL C D E Manufacturer Rebates to Dealers 10 20 30 Shipping Rebate: $84 $97 $88 Expected volume: 369 464 477 40 Annual $141 n/a 385 7.40% 8,450 2.50% 6 Additional Inputs: Overall Sales volume bonus 7 equal to or over 7.4% Overall Sales volume bonus if 8 >=2.5 and =2.5 and