Question

Write command for the operations (i) to (iii) based on spreadsheet below:

(i)To calculate the Amount as Unit Price *Qty for each item in Column F.
(ii)To Calculate the Rebate as 7% of Amount if Type is consumable , else calculate Rebate as 11% of Amount in Column G
(iii)To calculate total Rebate across all items in cell G6

Answer 1

◆Ekansh Nimbalkar◆
Hello friend,here is your required commands for the given operations

Ans: (i) At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3 : F5.

(ii)At cell G2,type =IF(C2= "Consumable" , F2*0.07 , F2*0.01) and then copy this formula using mouse Fill handle onto range G3 : G5

(iii)At cell G6,type =SUM(G2 : G5).

Answer 2

Answer:

here is your answer

Explanation:

I wrote it in exam I got full marks