intro to lab excel

(1) [0.5 marks] Determine the City (column C) based on Region (column B) using the IF condition IF Region is equal to "West", then City is "Abu Dhabj", Otherwise City is "Dubai". (2) [0.25 marks] Add ALL borders to cells K10:P12 (inner and outer). Border Color: Red. Border Style: Dashed Line. (3) [0.25 marks] Copy the horizontal table starting in cell K10. Paste Transpose the table in a vertical format in cell K15. (4) [0.5 marks] Determine the VAT (column H) using the VLQOKUP function. Lookup value is Quantity (column F). Table is given in cells K15:M20. (5) [0.5 marks] Compute the Totallice (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