Question

important question tell me answer of these​

Answer 1

a. In cell C8 Type:-

   =Sum(C4:C7)

b.Sort

c. In cell D10 Type:-

   =Max(D4:D7)

d. Select cell C9-> go to home tab-> Editing group -> click on the              arrow near the Auto Sum option -> Select Average .A selection box will open using this select cells C4 to C7 -> And click Enter

e.First find the total amount for each item using the auto sum button and similarly using AutoSum find the total

Hope this was helpful....