7. Employees at Julias Cookies can use their personal vehicles to travel to customer sites. An employee who chooses to do so is reimbursed based on mileage. Sometimes employees abuse the system. A red flag exists when an employee reports more miles than their monthly average. Test the data between the transaction dates 7/1/2025 and 12/31/2025 for above-average mileage. (Hint: Use a line chart.) Identify the employee(s).

8. How many total miles did the employee(s) from question 7 report for the month for which they potentially committed this type of fraud?

Take it to the next level!

9. When booking a flight, an employee books and pays for the flight in advance, which means they can submit their air ticket reimbursement prior to their trip. After they come back from the trip, some employees may claim reimbursement again, along with their other expenses, accidentally or with the intent of defrauding the company. Test the data to see if there were any duplicated ticket numbers in the data set. How many air tickets were reimbursed twice?

10. Which employee had duplicate reimbursements of airline tickets?

I only need to know how to solve it, not the answers! FOR EX: #1, using a pivot table for the data, what category would you put in filter, column, row, values? Thank you!