Explain the functions used for Calculating the following for a Column in MS-Excel:  a)Averageb)Total b)Minimum c)Maximum[5]

Sure, here are the functions used for calculating the following for a column in MS-Excel:

a) Average: The AVERAGE function is used to calculate the average of a set of values in a specific range of cells. Here's how to use it:

Step 1: Click on the cell where you want the average to appear. Step 2: Type =AVERAGE( Step 3: Click and drag to select the range of cells for which you want the average. Step 4: Close the parenthesis and press Enter.

b) Total: The SUM function is used to calculate the total of a set of values. Here's how to use it:

Step 1: Click on the cell where you want the total to appear. Step 2: Type =SUM( Step 3: Click and drag to select the range of cells you want to total. Step 4: Close the parenthesis and press Enter.

c) Minimum: The MIN function is used to find the smallest number in a range of cells. Here's how to use it:

Step 1: Click on the cell where you want the minimum value to appear. Step 2: Type =MIN( Step 3: Click and drag to select the range of cells from which you want the smallest number. Step 4: Close the parenthesis and press Enter.

d) Maximum: The MAX function is used to find the largest number in a range of cells. Here's how to use it:

Step 1: Click on the cell where you want the maximum value to appear. Step 2: Type =MAX( Step 3: Click and drag to select the range of cells from which you want the largest number. Step 4: Close the parenthesis and press Enter.