Management-Mini-Case-Need-to-use-Excel-management-homework-help

First of all, need to use Excel answer questions within the text of the case. Need Excel chart.

A. Build a mileage lookup table to reference in other sheets.

B. Develop an Expense worksheet with the necessary information.

C. Create a macro and apply advanced filtering to the data.

D. Create a table with all of Ms. Lapeerâ€™s desired information.

After that, please answer Information specification questions.

5. Identify sales positions by division.

6. Identify which division had the lowest expenses for the week.

7. Identify which S1 sales representative(s) submitted hotel and airfare expenses this past week.

8. Identify which individuals went over their mileage limits.