DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=5*10+20
|
|
|
=$A$10/100
|
|
|
+F18+F19/2
|
|
|
=F21+$58/3
|
Detailed explanation-1: -Relative Cell References This is the most widely used type of cell reference in formulas. 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-2: -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-3: -Relative, absolute and mixed cell references. There are three types of cell references in Excel: relative, absolute and mixed. When writing a formula for a single cell, you can go with any type.
Detailed explanation-4: -A$7 – relative column, absolute row.