USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
MAX
|
|
|
MIN
|
|
|
both choices
|
|
|
none of the choices
|
Detailed explanation-1: -The MAX function in Excel returns the highest value in a set of data that you specify. The syntax is as follows: MAX(number1, [number2], …) Where number can be represented by a numeric value, array, named range, a reference to a cell or range containing numbers.
Detailed explanation-2: -The largest value in a data set is often called the maximum (or max for short), and the smallest value is called the minimum (or min). The difference between the maximum and minimum value is sometimes called the range and is calculated by subtracting the smallest value from the largest value.
Detailed explanation-3: -Answer. The Excel MAX function returns the largest numeric value in a range of values.
Detailed explanation-4: -Description. Returns the largest number in a field (column) of records in a list or database that matches conditions you that specify.