USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
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: -Use the SUM function to sum numbers in a range.
Detailed explanation-3: -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-4: -The AVERAGE function used to get the average of a certain range of cells if a condition is met. Other: SUMIF function adds values that meet a given criterion.
Detailed explanation-5: -The formula uses the AVERAGE function to average the cells containing numbers and ignores the empty cells or those containing text. For more information about the AVERAGE function, see the course summary at the end of the course. Up next, AVERAGEIF.