DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In the Function Library, which of the following categories will you find the MAX and MIN functions?
|
|
Logical
|
|
|
Financial
|
|
|
Math & Trig
|
|
|
Statistical
|
Explanation:
Detailed explanation-1: -The Excel MAX function can tell you what the largest numeric value is in a range of cells. The opposite of MAX is the MIN function, which returns the smallest numeric value in a range of cells.
Detailed explanation-2: -The MIN() function returns the smallest value of the selected column. The MAX() function returns the largest value of the selected column.
Detailed explanation-3: -Click the Formulas tab on the Ribbon. Click the More Functions button in the Function Library group of commands. Place the mouse pointer over the Statistical option from the drop-down list of options.
There is 1 question to complete.