USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Mixed
|
|
|
Absolute
|
|
|
Relative
|
|
|
Vlookup
|
Detailed explanation-1: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.
Detailed explanation-2: -Absolute references point to a cell at an exact location. When a cell containing a formula with absolute references is moved or copied, the reference does not change.
Detailed explanation-3: -Here is what happens when you select the reference and press the F4 key. Press F4 key once: The cell reference changes from A1 to $A$1 (becomes ‘absolute’ from ‘relative’). Press F4 key two times: The cell reference changes from A1 to A$1 (changes to mixed reference where the row is locked).
Detailed explanation-4: -Relative cell references contain no dollar signs (i.e., A1). Mixed cell references have dollar signs attached to either the letter or the number in a reference but not both (i.e., $A1 or A$1). Absolute cell references have dollar signs attached to each letter or number in a reference (i.e., $A$1).