Question

- wwung oruci.
31. Given the following spreadsheet. Write the answer followed questions.
Qty
Price
| 10
30
15
50
400
Product
Penal
Pen
Notebook
Books
Lunch Box
Beg
Total
20
10
16
17
550
50
350
i) Calculate the total price of all product and display in cell C8.
(11) Find the maximum price of given price.
(iiFind the minimum price of given price.
(iv) Update the cell C5 by increasing * 150.
(v) Which feature is used to show the graphical representation of above spreadsheet.​

Answer 1

Explanation:

- wwung oruci.

31. Given the following spreadsheet. Write the answer followed questions.

Qty

Price

| 10

30

15

50

400

Product

Penal

Pen

Notebook

Books

Lunch Box

Beg

Total

20

10

16

17

550

50

350

i) Calculate the total price of all product and display in cell C8.

(11) Find the maximum price of given price.

(iiFind the minimum price of given price.

(iv) Update the cell C5 by increasing * 150.

(v) Which feature is used to show the graphical representation of above spreadsheet.

Answer 2

Answer:

6548++-3+2($;33__;_!#!#-#+*