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: -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: -The MAX function in Excel returns the highest value in a set of data that you specify. The syntax is as follows: MAX(number1, [number2], …)
Detailed explanation-3: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-4: -The MAX function is a premade function in Excel, which finds the highest number in a range. The function ignores cells with text. It will only work for cells with numbers. Note: There is another function called MIN, which finds the lowest value in a range, the opposite of MAX.
Detailed explanation-5: -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.