I am having trouble with a question for an assignment that I am working on for a class.

Here is the assignment: Scenario

The potential for corporate fraud is always a consideration when using or even adopting an AIS. Even simple tools like Excel are useful in drawing information from accounting records found in an AIS. S&S is not exempted from this concern. Although this is not a normal duty for you, Ashton has asked you to analyze sales data for its stores. He expects this task will pay dividends later as you evaluate AIS solution controls. He did not share any expenses or specific fraud data.

Instructions

Update the Historical Sales Data Download Historical Sales Datafile to generate a descriptive status of sales and fraud data.

Do the following:

1. In Column F, Row 1, add the title "Estimated_Fraud"
2. Develop a formula that calculates fraud expenses at 5 % of weekly sales.
3. Generate a descriptive status of sales and fraud data. You will store the results in a separate workbook.
4. Develop pivot tables that identify the following:
   • Top 5 stores with estimated fraudulent expenses.
   • Top 5 departments with estimated fraudulent expenses.
   • Top 5 holidays with estimated fraudulent expenses.
   • Here is some of the Excel Workbook that I am trying to do:

AutoSave Debbie_Godbolt-Week6Fraud... - Saved to this PC O Search DG File Home Insert Page Layout Formulas Data Review View Automate Help Aptos Narrow - 11 ~ A A General Conditional Formatting ~ Insert Ex AYO % Format as Table 1X Delete Paste B I U - - C- A Sort & Find & Add-ins Cell Styles ~ Format Filter ~ Select Clipboard S Font Alignment IN Number Styles Cells Editing Add-ins J12 B C D E F G H M O 1 Store Dept Date Weekly Sales IsHoliday Estimated_Fraud Store Departments Holidays 2/5/2020 24924.5 FALSE 0 Row Labels JT Sum of Estimated Fraud Row Labels Ju Sum of Estimated Fraud Row Labels IT Sum of Estimated_Fraud 2/12/2020 46039.49 TRUE 0.05 20 36.2 82 23.4 TRUE 135.45 2/19/2020 41595.55 FALSE 13 36 8 79 22.8 FALSE 1345.55 2/26/2020 19403.54 FALSE 0 10 36.1 10 22.8 Grand Total 1481 1 3/5/2020 21827.9 FALSE 0 4 36 3 25.05 1 3/12/2020 21043.39 FALSE 36.1 23 1 3/19/2020 22136.64 FALSE 36.15 Grand Total 117.05 3/26/2020 26229.21 FALSE Grand Total 217.65 4/2/2020 57258.43 FALSE o 4/9/2020 42960.91 FALSE 4/16/2020 17596.96 FALSE 4/23/2020 16145.35 FALSE 4/30/2020 16555.11 FALSE 5/7/2020 17413.94 FALSE 5/14/2020 18926.74 FALSE 5/21/2020 14773.04 FALSE 5/28/2020 15580.43 FALSE 6/4/2020 17558.09 FALSE 6/11/2020 16637.62 FALSE 6/18/2020 16216.27 FALSE 6/25/2020 16328.72 FALSE 7/2/2020 16333.14 FALSE 7/9/2020 17688 76 FALSE 25 716/2020 17150.84 FALSE of_Historical_Sales_Data Ready Accessibility: Investigate 5 86-F Search O O Cloudy