Question

1. Write formula in C9 to find lowest value of column ‘PRICE’.
2. Write the cell range of all the numerical values of column ‘QTY’
3. Write the cell address which stores largest/maximum value of column ‘PRICE’.
4. How many values are stored in range C2 : D6?

Answer 1

Answer:

the number of the total+Qty