Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Databases Technologies And Applications

Authors: Zongmin Ma

1st Edition

1599041219, 978-1599041216

More Books

Students also viewed these Databases questions

Question

Describe how language emerges.

Answered: 1 week ago

Question

What are negative messages? (Objective 1)

Answered: 1 week ago