DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The ____ sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range.
|
|
AVERAGE function
|
|
|
AutoComplete list
|
|
|
Function Argument dialog box
|
|
|
Formula bar
|
Explanation:
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 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.
There is 1 question to complete.