DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
%
|
|
|
$
|
|
|
&
|
|
|
#
|
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.
Detailed explanation-2: -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-3: -In this style, columns are defined by letters and rows by numbers, i.e. A1 designates a cell in column A, row 1.
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.
Detailed explanation-5: -In some scenarios, it becomes important to keep a cell reference constant when it is copied to a different cell. An absolute cell reference always remains the same no matter where it is copied and is often denoted by the “$” symbol.