Question

please answer it please ​

Answer 1

a)click inside the cell e2 type the formula =c2*d2

copy the formula upto e5

b) click inside cell price  

Data tab-> Sort and filter group click on AZ (for ascending order)

c) click inside c6 type the formula =max(c2:c5)

d)click inside c7 type the formula =average(c2:c5)

e) click inside e6 type the formula =sum(c2:c5)