COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The Excel MIN function returns the lowest/ smallest numeric value from the selected data cells/ ranges.
Detailed explanation-2: -Returns the smallest number in a set of values.
Detailed explanation-3: -The MIN() function returns the smallest value of the selected column. The MAX() function returns the largest value of the selected column.
Detailed explanation-4: -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-5: -MIN is a function in Excel that returns the minimum value in a range of cells. For example, if you have a list of numbers in a column and you want to find the smallest number in the list, you can use the MIN function to do so.