USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
For writing the sum formula in cell A2 with cell B2, the correct one below is ____
|
|
+Sum(A2:B2)
|
|
|
=Sum(A2:B2)
|
|
|
=Sum(A2;B2)
|
|
|
=Sum(A2..B2)
|
|
|
=Sum(A2, B2)
|
Explanation:
Detailed explanation-1: -To create the formula: Type =SUM in a cell, followed by an opening parenthesis (. To enter the first formula range, which is called an argument (a piece of data the formula needs to run), type A2:A4 (or select cell A2 and drag through cell A6).
Detailed explanation-2: -In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
Detailed explanation-3: -=CONCATENATE(B2, A2) OK, let’s run this function!
There is 1 question to complete.