DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
max()
|
|
|
min()
|
|
|
count()
|
|
|
average()
|
Detailed explanation-1: -The MAX Function[1] is categorized under Excel Statistical functions. 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.
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 finds the maximum value. The Min function finds the minimum value.
Detailed explanation-5: -Because the number of bits of memory in which the number is stored is finite, it follows that the maximum or minimum number that can be stored is also finite. For Excel, the maximum number that can be stored is 1.79769313486232E+308 and the minimum positive number that can be stored is 2.2250738585072E-308.