DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=TOTAL
|
|
|
=IF
|
|
|
=SUM
|
|
|
=ADD
|
Detailed explanation-1: -Here’s a formula that uses two cell ranges: =SUM(A2:A4, C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787. To create the formula: Type =SUM in a cell, followed by an opening parenthesis (.
Detailed explanation-2: -Excel SUM is a math and trig function that adds values. The syntax of the SUM function is as follows: SUM(number1, [number2], …) The first argument is required, other numbers are optional, and you can supply up to 255 numbers in a single formula.
Detailed explanation-3: -The correct answer is SUM. SUM is used for the addition in MS Excel. The SUM function is located in the Home tab in the ribbon. SUM function adds all numbers in a range of cells and returns the result in MS Excel.