Answered step by step
Verified Expert Solution
Question
1 Approved Answer
these are sub questions you giys already solved first 4 (5) [0.5 marks ] Compute the TotalPrice ( column I) = Quantity (column F) *
these are sub questions you giys already solved first 4
(5) [0.5 marks ] Compute the TotalPrice ( column I) = Quantity (column F) * (Transport Cost (B27) + UnitPrice (column G) + VAT (column H)) (6) [0.25 marks] Change Number Format of QrderDate (column A) to Short Date. Format UnitPrice (G) and TotalPrice (I) to AED Currency format with 1 decimal place. (7) [0.25 marks] Compute Avg Cost (cell B28) based on TotalPrice (column I). Find the Max Qty (cell B29) based on the maximum value of Quantity (column F). (8) [0.5 marks] Rename Sales-Section sheet by changing Section to your IT Section. Change Your Name in cell B30 to your name and add your ID as a comment to cell B30 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started