DATABASE FUNDAMENTALS
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: -By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
Detailed explanation-3: -These cell references that adjust itself when the cell is copied are called relative cell references in Excel.
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).