Question

Heya mates!!
pls refer to the attachment nd provide the answer.
Jai Hind

Answer 1

(b) Sort option in Sort and Filter group under Data tab

(c) =MAX(C2:C5)

(d) Text Highlight Colour option in Font group under Home tab

Answer 2

a. The price is 800 as it asked to calculate the total price in cell C2 with no. of copies in cell D2.Therefore C2 x D2=E2 ,i.e,200 × 4 = 800.So the Total Price in cell E2 is 800.