DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Mixed
|
|
|
Absolute
|
|
|
Relative
|
|
|
Name Box
|
Detailed explanation-1: -For example, $A$15 is an absolute reference to cell A15.
Detailed explanation-2: -But, if you type the formula as an absolute reference such as = $A$1+$A$2, and then copy the formula to any other location, it remains fixed as = $A$1+$A$2. You will learn how to make an absolute cell reference in the next section, so stay tuned.
Detailed explanation-3: -An absolute reference in Excel is a cell address with the dollar sign ($) in the row or column coordinates, like $A$1. The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves.
Detailed explanation-4: -Absolute references An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. If it precedes the column or row (but not both), it’s known as a mixed reference. You will use the relative (A2) and absolute ($A$2) formats in most formulas.
Detailed explanation-5: -An absolute reference is designated in the formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both. You will most likely use the $A$2 format when creating formulas that contain absolute references.