DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUM function
|
|
|
default column width
|
|
|
series
|
|
|
non-contiguous range
|
Detailed explanation-1: -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.
Detailed explanation-2: -Description. The Microsoft Excel SUM function adds all numbers in a range of cells and returns the result. The SUM function is a built-in function in Excel that is categorized as a Math/Trig Function.
Detailed explanation-3: -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-4: -SUM: This function adds all the values of the cells in the argument.
Detailed explanation-5: -The [sum range] is the range where the function calculates the sum. Note: The [sum range] is optional. If not specified, the function calculates the sum of the same range as the condition.