DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The column part will remain the same
|
|
|
The row part will remain the same
|
|
|
Both the column and row will remain the same
|
|
|
Both will change
|
Detailed explanation-1: -For the $B38 cell address, it’s the B column that will remain the same. This option is very practical when you wish to copy a formula but keep the same cell references. You have to think if you need to freeze the column if you wish to copy the formula horizontally.
Detailed explanation-2: -If it is $B38, then the B will not change wherever it is copied, but the 38 will. The $ put in front of the column or row row part of a cell address will freeze that part of the address. For the $B38 cell address, it’s the B column that will remain the same.
Detailed explanation-3: -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. Place a “$” before a row number if you want that to always stay the same.
Detailed explanation-4: -By putting a dollar sign before either the row or column of a cell reference, you can prevent that row or column variable from being changed when you copy and paste the formula containing the reference. The reference “A1” will be modified appropriately whenever copy/pasted.