Which one is not a Function in MS Excel? *
MAX
MIN
AVG
SUM
Answers
Answer:
option C
AVG is not a function of MS EXCEL
Mark as you wish my friend
Answer:
AVG is not a function in MS Excel. It's an abbreviation for average which is a mathematical operation. The functions in MS Excel are MAX, MIN, and SUM.
Explanation:
From the above question,
They have given :
AVG is not a function in MS Excel. It's an abbreviation for average which is a mathematical operation. The functions in MS Excel are MAX, MIN, and SUM.
MAX, MIN, AVERAGE, and SUM are all functions in Microsoft Excel.
MAX returns the largest value in a set of values.
MIN returns the smallest value in a set of values.
AVERAGE returns the average of a set of values.
SUM adds a set of values.
There are many functions in Microsoft Excel. Some common functions include:
- SUM: Adds up a range of values
- AVERAGE: Calculates the average of a range of values
- COUNT: Counts the number of cells in a range that contain numbers
- MAX: Returns the largest value in a range of values
- MIN: Returns the smallest value in a range of values
- IF: Performs a conditional test and returns one value if the condition is true and another value if the condition is false
- VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column
- INDEX: Returns the value of a cell in a specified row and column of a table
- LEFT: Returns a specified number of characters from the beginning of a text string
- RIGHT: Returns a specified number of characters from the end of a text string
This is just a small sample of the functions available in Microsoft Excel.
For more such related questions : https://brainly.in/question/39298120
#SPJ3