Write command for the operations (i) to (iii) based on the spreadsheet below:
To calculate the Amount as Unit Price*Qty for each item in Column F.
To calculate the Rebate as 7% of Amount if Type is consumable, else calculate Rebate as 11% of Amount in Column G.
To calculate total Rebate across all items in cell G6.