USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
average
|
|
|
sum
|
|
|
min
|
|
|
max
|
Detailed explanation-1: -In order to drop the lowest score, you will need to use the MIN function. This function locates the minimum value in a range of scores. EXAMPLE: MIN(D2:H2) will return the smallest value in cells D2 through H2.
Detailed explanation-2: -The MIN function checks your data range and returns the smallest value in the set. Its syntax is the following: MIN(number1, [number2], …) number1, [number2], … is the series of values from where you want to get a minimum.
Detailed explanation-3: -One way to do this is by using the MIN function. To use this function, type =MIN( into any cell and then select all of the cells in your Scores column. This will give you the minimum value from that column, which is equivalent to finding out who has the lowest score.
Detailed explanation-4: -Returns the smallest number in a set of values.