Question

Answer the following questions (1) to (4) using the following table:

A B C D E

1 P_ID PRODUCT QTY. PRICE TOTAL PRICE

2 1 Pen 10 40

3 2 Pencil 20 5

4 3 Notebook 45 50

5 4 Lunch box 12 250

6 5 Bag 15 800

7

1. Write the formula for calculating the TOTAL PRICE of Pens in cell E2.

2. Write the function for finding maximum of the quantity in cell C7.

3. Write the function for finding average of the price in cell D7.

4. Which feature of Calc is used for displaying the data graphically?​

Answer 1

Answer:

event ICICI bent GTB they've Qawwali