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
|
Detailed explanation-1: -AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument. COUNT: This function counts the number of cells with numerical data in the argument.
Detailed explanation-2: -Description. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
Detailed explanation-3: -The AVERAGE Function[1] is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel.
Detailed explanation-4: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-5: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.