Based on the following data write the formula to calculate the following​

(B2 * C2)

SUM(C2:C5)

MAX(B2 : B5)

AVERAGE(B2, B5)

Explanation:

USING EXCEL :

1.)

Total price of all Parker pens in store :

Price of Parker pens * Number of stock in store

(B2 * C2)

(3500 * 20) = Rs. 70000

Takes the values in cell B2 and C2 and multiplies the oroduxt

2.)Total number of all stocks lying in store :

SUM(C2:C5)

C2 + C3 + C4 + C5

(20 + 40 + 25 + 55) = 140

Take the sum of all numeric values in column C

3.) Highest price of pen in store :

Use the max function : MAX(B2 : B5)

Find the maximum. Value with in the range

4.) Average price of pen in store :

AVERAGE(B2, B5)

Calculates the mean value for the data in cell B2 to B5

true never assume something it makes an a** out of u and me.

b 2nd. your welcome yeet