DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.
|
|
count function
|
|
|
autosum
|
|
|
sum function
|
|
|
count function
|
Explanation:
Detailed explanation-1: -By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
Detailed explanation-2: -The Autosum Excel Function[1] can be accessed by typing ALT + the = sign in a spreadsheet, and it will automatically create a formula to sum all the numbers in a continuous range.
Detailed explanation-3: -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.
There is 1 question to complete.