DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
A1
|
|
B$1
|
|
$C1
|
|
$D$2
|
Detailed explanation-1: -A relative reference in Excel is a cell address without the $ sign in the row and column coordinates, like A1. When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns.
Detailed explanation-2: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.
Detailed explanation-3: -The default reference style By default, Excel for the web uses the A1 reference style, which refers to columns with letters (A through XFD, for a total of 16, 384 columns) and refers to rows with numbers (1 through 1, 048, 576). These letters and numbers are called row and column headings.