DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
|
|
Formula Finder
|
|
|
Range Finder
|
|
|
Calculation Finder
|
|
|
Function Finder
|
Explanation:
Detailed explanation-1: -Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.
Detailed explanation-2: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
There is 1 question to complete.