USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
MIN
|
|
|
SUM
|
|
|
AVERAGE
|
|
|
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.
Detailed explanation-2: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-3: -The arithmetic mean, also known as the average, is the total sum of the values divided by the number of values, or data points, in the sample. Here, the call to sum() computes the total sum of the data points in your sample.
Detailed explanation-4: -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-5: -Click a cell below the column or to the right of the row of the numbers for which you want to find the average. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.