FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following functions finds the lowest value in a range of cells?
A
=MAX( )
B
=AVG( )
C
=MIN( )
D
=LOW( )
Explanation: 

Detailed explanation-1: -The MIN function is a premade function in Excel, which finds the lowest number in a range. The function ignores cells with text. It will only work for cells with numbers. Note: There is another function called MAX, which finds the highest value in a range, the opposite of MIN.

Detailed explanation-2: -The MIN function checks your data range and returns the smallest value in the set. Its syntax is the following: MIN(number1, [number2], …) number1, [number2], … is the series of values from where you want to get a minimum.

Detailed explanation-3: -Returns the smallest number in a set of values.

Detailed explanation-4: -The MIN function returns the smallest numeric value in the data provided. The MIN function can be used to return the smallest value from any type of numeric data.

There is 1 question to complete.