DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
$
|
|
|
=
|
|
|
*
|
|
|
” “
|
Detailed explanation-1: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-2: -$ symbol in Excel locks a specific cell or rows or columns in a worksheet. The shortcut to lock down a reference in Excel is pressing ALT + F4. This feature is used while working on formulas when we do not want the reference to be changed when copying or dragging the formula to other cell references.
Detailed explanation-3: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same.
Detailed explanation-4: -Summary of absolute cell reference uses: $A1. Allows the row reference to change, but not the column reference. A$1. Allows the column reference to change, but not the row reference.