DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Use the ____ function to display the highest value in a range.
|
|
MAX
|
|
|
MIN
|
|
|
both choices
|
|
|
none of the choices
|
Explanation:
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: -The Max function finds the maximum value. The Min function finds the minimum value.
There is 1 question to complete.