Read the assignment instruction document – A1_Macys Data Analysis.pdf thoroughly to understand the problem and task that you have been charged with. Download the attached Excel document A1_MacysDeptStore.xlsx and perform the necessary operations using Excel to demonstrate your understanding of Excel and and skills in data analysis.

For full credit, your solution must meet the required elements of each category defined in the Grading Rubric.