DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What function was used to find the lowest grade?
|
average
|
|
sum
|
|
min
|
|
max
|
Explanation:
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: -Returns the smallest number in a set of values.
Detailed explanation-4: -The MAX function in Excel returns the highest value in a set of data that you specify.
There is 1 question to complete.