USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
MIN
|
|
|
AVERAGE
|
|
|
COUNT
|
|
|
MAX
|
Detailed explanation-1: -e AVERAGE function adds a range of cells and then divides by the number of cell entries, determining the mean value of all values in the range.
Detailed explanation-2: -Using functions SUM: This function adds all the values of the cells in the argument. 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-3: -The function AVERAGE is used to determine the average of the values in selected cells. Since the average is calculated by obtaining the sum of selected cell values and then dividing the sum by the number of selected cells, the correct answer is the AVERAGE function.
Detailed explanation-4: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.