Help do it right for 100 point or i will report you 1) Download the Mobsters_1_Template. xls file from the Digital Materials section of 12.15 in the course Content.
2) In cell D167, type the formula for D167 (hint: sum)
3) In cell D168, type the formula for D168 (hint: count)
4) The payout formulas are incorrect for columns H and L. These need to be fixed so the count is correct at the bottom of the tables. Correct the formulas and then ensure the differences is 0 for both tables.
5) Now that your tables have the correct information, use the middle table to answer the top 2 questions to the right of your spreadsheet. Write your answers in the cell next to where is says “”

6) Use the filter feature to answer these questions on the right of the spreadsheet:
7) Clear all filters on this spreadsheet and use conditional formatting to highlight the H column as below:
a. Have all payouts of $4,000,000 or more in green
b. Have all payouts of $3,000,000 or less in red