DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
MIN
|
|
|
MAX
|
|
|
SUM
|
|
|
COUNT
|
Detailed explanation-1: -Python max() Function The max() function returns the item with the highest value, or the item with the highest value in an iterable. If the values are strings, an alphabetically comparison is done.
Detailed explanation-2: -The MAX function is a premade function in Excel, which finds the highest number in a range. The function ignores cells with text. It will only work for cells with numbers.
Detailed explanation-3: -Explanation: To find the maximum, we must find where the graph shifts from increasing to decreasing. To find out the rate at which the graph shifts from increasing to decreasing, we look at the second derivative and see when the value changes from positive to negative.
Detailed explanation-4: -Substitute the critical number x = 2 in f"(x). So, f(x) is maximum at x = 2. To find the maximum value, substitute x = 2 in f(x). Therefore the maximum value of the function f(x) is 7.