Your firm has been contracted to perform the fraud examination. The attorney for Southern Appalachian Insurance Company added an additional assignment: analyze the bank transactions from September 1, 2015, through February 29, 2016. Access the Study section 4-2, How to Use Excel Pivot to Analyze and Summarize Data, and download the Excel Data sheet provided before conducting the specific requirements of this case. The results of your assignment will be used as a summary schedule in your report, a schedule attached to the report, and possibly a courtroom audiovisual should you be called to testify as an expert witness. Your assignment (in general) is, as follows: Assign categories (using the dropdown choices provided) to the disbursement transactions to assist in summarizing transactions. Insert a PivotTable in a new worksheet and obtain the total quantities (count) of transactions and total dollars (sum) for each category. Make at least three new PivotTables (Exercises 1, 2, and 3): Deposits (Amount Deposit and Deposit Category) Check and Debit Card Disbursements (Check Category, Payee per Check/Debit, Amount Check/Debit) (unscrubbed) Check and Debit Card Disbursements (Check Category, Payee per Check/Debit, Amount Check/Debit) (scrubbed) Sort the total dollars per category in descending order. Enhance the scrubbed PivotTables for report and courtroom presentation purposes: Add an appropriate title and use proper "$" signs, decimal format, etc. Checklist: Make sure to ad