DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
+
|
|
|
-
|
|
|
/
|
|
|
*
|
|
|
:
|
Detailed explanation-1: -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-2: -The dollar sign in an Excel cell reference affects just one thing-it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the $ sign before the row and column coordinates makes an absolute cell reference that won’t change.
Detailed explanation-3: -=SUM(ABOVE) adds the numbers in the column above the cell you’re in. =SUM(LEFT) adds the numbers in the row to the left of the cell you’re in. =SUM(BELOW) adds the numbers in the column below the cell you’re in. =SUM(RIGHT) adds the numbers in the row to the right of the cell you’re in.