USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUM
|
|
|
AVERAGE
|
|
|
COUNT
|
|
|
MAX
|
|
|
MIN
|
Detailed explanation-1: -COUNT: This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range. MAX: This function determines the highest cell value included in the argument. MIN: This function determines the lowest cell value included in the argument.
Detailed explanation-2: -MIN: This function determines the lowest cell value included in the argument. The AutoSum command allows you to automatically insert the most common functions into your formula, including SUM, AVERAGE, COUNT, MIN, and MAX.
Detailed explanation-3: -The MIN function is a premade function in Excel, which finds the lowest number in a range. The function ignores cells with text. It will only work for cells with numbers. Note: There is another function called MAX, which finds the highest value in a range, the opposite of MIN.
Detailed explanation-4: -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.