FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In MS Excel, which function calculates the maximum value of a sequence of numbers?
A
max()
B
min()
C
count()
D
average()
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], …)

Detailed explanation-2: -Returns the largest value in a set of values.

Detailed explanation-3: -If the cells are in a contiguous row or column Select a cell below or to the right of the numbers for which you want to find the smallest number., click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.

Detailed explanation-4: -The MAX Function[1] is categorized under Excel Statistical functions. MAX will return the largest value in a given list of arguments.

Detailed explanation-5: -The Max function finds the maximum value. The Min function finds the minimum value.

There is 1 question to complete.