Task 9 - Analyze payment types The boss is wondering if we can stop accepting some types of credit cards because of the high fees they charge us. Please produce a pivot table with... - Each payment type (AmEx, etc.) on its own row. - One column for each year of data (use Date Rental Begins, per note on page 2). - Total rental revenue calculated in the body of the pivot table. - Format the total revenue as follows: no dollar sign, two decimal places, and use commas as thousands separators. - Rename the sheet to be: "Pivot 1 - Payment Types" Task 10 - Perform a geographic analysis The marketing department wants to know which geographic markets provide the most customers. They'd like you to do an analysis by State (one state per row on the pivot table) that answers the following questions: - How many rentals from that state? - Sort the results in order of descending number of rentals (i.e. the state with the most rentals should be at the top and the fewest at the bottom). - Rename the sheet to be: "Pivot 2 - Geographic Analysis