6.Write the uses of the following functions in Excel:
(a)SUM (b) AVERAGE (c) MAX
(d) MIN
Pls give the answer quickly an take it seriously.
THANK YOU
(a)SUM (b) AVERAGE (c) MAX
(d) MIN
Pls give the answer quickly an take it seriously.
THANK YOU
Add an Answer
More Questions From This User See All
Answers & Comments
Answer:
Basic Excel formulas and functions with examples and links to related ... Excel will insert a SUM formula for you automatically. ... To average cells based on condition, use the following ...
Answer:
(a)The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
(b)The Microsoft Excel AVERAGE function returns the average (arithmetic mean) of the numbers provided. The AVERAGE function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.
(c) The Microsoft Excel MAX function returns the largest value from the numbers provided. The MAX function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.
(d)The Microsoft Excel MIN function returns the smallest value from the numbers provided. The MIN function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.
Explanation:
hope it helps...