Question: SHOW EXCEL IN EVERY STEP The answers should display advanced excel skills and NOT using SUM.PLEASE PRESENT YOUR ANSWERS USING THE SEQUENCE BELOWHere are the deliverables for the exam: (FOLLOW REQUIRED SEQUENCE!) #1 present monthly dollar amount pertaining 5 ITEMS as follows: a) gross sales, b) gross promotions, c) refunds, d) fees and e) net sales#2 present number of units for A - E corresponding to #1 above#3 present on a per unit basis the gross sales, gross promotions, refunds, fees, and net sales#4 provide a one-page paragraph describing the observations and commentaries you have after your analysis in #1-#3Hint: MSRP is $1500 per unit and delivery fee is $250 with total price to customers of $2500 (this will be helpful to know in the analyses and quantification of gross promotions deducted from gross sales per month)Heres the data. SHOW THE EXACT EXCEL STEP BY STEP

1. **State the problem:** We need to analyze monthly sales data for 5 items with the following metrics: gross sales, gross promotions, refunds, fees, and net sales. 2. **Step 1: Present monthly dollar amounts for the 5 items** - Use Excel formulas to calculate each metric without using SUM. - Assume data is in columns for each month and rows for each item. - For gross sales, input raw data or calculate as units sold * MSRP. - For gross promotions, calculate as the difference between MSRP and actual sales price per unit times units sold. - Refunds and fees are given or calculated. - Net sales = gross sales - gross promotions - refunds - fees. **Excel example for net sales in cell F2:** `=C2-D2-E2-F2` where C2=Gross Sales, D2=Gross Promotions, E2=Refunds, F2=Fees. 3. **Step 2: Present number of units for A-E corresponding to #1** - Use COUNTIF or direct input for units sold per item. 4. **Step 3: Present per unit basis values** - Calculate per unit values by dividing dollar amounts by units sold. - Use formula like `=C2/B2` where C2 is dollar amount and B2 is units. - Use `\cancel{}` in LaTeX to show division simplification if needed. 5. **Step 4: Observations and commentary** - Discuss trends such as which items have highest promotions, refunds, or fees. - Comment on net sales efficiency. - Use MSRP $1500 and delivery fee $250 to interpret promotions. **Note:** - All Excel formulas should avoid SUM and use direct arithmetic or functions like COUNTIF. - Show intermediate steps with formulas. **Final answer:** This is a data analysis task requiring Excel formulas for each step, showing calculations for dollar amounts, units, and per unit values, followed by a detailed commentary.