DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Workbook
|
|
|
Ribbon
|
|
|
Markup
|
|
|
Relative Value
|
Detailed explanation-1: -By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)-in the same row (2).
Detailed explanation-2: -A formula that contains a relative cell reference changes as you copy it from one cell to another. For example, if you copy the formula =A2+B2 from cell C2 to C3, the formula references in C3 adjust downward by one row and become =A3+B3.
Detailed explanation-3: -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).
Detailed explanation-4: -There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.