Answer:
(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
