Computer Science, asked by sujitksingh9891, 7 months ago

Which one is not a Function in MS Excel? *



MAX

MIN

AVG

SUM

Answers

Answered by jahnavi61
4

Answer:

option C

AVG is not a function of MS EXCEL

Mark as you wish my friend

Answered by ishwaryam062001
0

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

Similar questions