DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
absolute cell reference
|
|
|
relative cell reference
|
|
|
named range
|
|
|
mixed cell reference
|
Detailed explanation-1: -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. Mixed references are used less frequently.
Detailed explanation-2: -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-3: -What Are Mixed Cell References? Mixed cell references are a combination of relative references and absolute reference. There are two distinct types of mixed reference. Either the column is locked while the row changes when the formula is copied, or the row is locked while the column changes when the formula is copied.