DATABASE FUNDAMENTALS
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: -=A1+A2+A3 Adds the values in cells A1, A2, and A3. =SQRT(A1) Uses the SQRT function to return the square root of the value in A1.
Detailed explanation-3: -=CONCATENATE(B2, A2) OK, let’s run this function!
There is 1 question to complete.