DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
|
|
sum function
|
|
|
countblank function
|
|
|
average function
|
|
|
min function
|
Explanation:
Detailed explanation-1: -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-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.
Detailed explanation-3: -In cell O9, type =AVERAGE(B9:M9) and then press Enter.
There is 1 question to complete.