FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A function that returns the largest values in a set of values
A
MAX function
B
AVERAGE function
C
MIN function
D
SUM function
Explanation: 

Detailed explanation-1: -The max() function returns the item with the highest value, or the item with the highest value in an iterable.

Detailed explanation-2: -MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value. Unlike MAXA function, the MAX function will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.

Detailed explanation-3: -A global maximum of a function is the largest value in the entire range of the function, and a local maximum is the largest value in some local neighborhood., the extremum test succeeds under more general conditions than the second derivative test.

There is 1 question to complete.