USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Numbers
|
|
|
Text
|
|
|
Dates
|
|
|
Times
|
Detailed explanation-1: -MAX will ignore text, True/False, and empty cells. If none of the provided cells contain numerical values, MAX will simply return 0.
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: -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: -S function. Estimates standard deviation based on a sample (ignores logical values and text in the sample).
Detailed explanation-5: -Returns the smallest number in a set of values.