DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The formula for writing the sum in cell B2 with cell C2 is correct below
|
|
+Sum(B2 ____ C2)
|
|
|
=Sum(B2:C2)
|
|
|
=Sum(B2;C2)
|
|
|
=Sum(B2, C2)
|
Explanation:
Detailed explanation-1: -All Excel formulas begin with an equal to sign (=) For example, to add up values in cells B1 through B5, you can either: Type the entire equation: = B1+B2+B3+B4+B5. Use the SUM function: = SUM(B1: B5) Press the Enter key to complete the formula.
Detailed explanation-2: -The correct formula to add two numbers in two cells A1 and A2 of a spreadsheet is =A1+A2. In a spreadsheet, the SUM function is responsible for adding values.
There is 1 question to complete.