DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
logical
|
|
|
constant
|
|
|
consistent
|
|
|
calculated
|
Detailed explanation-1: -When you set up a worksheet, you should use cell references in formulas whenever possible, rather thanconstant values. The use of a cell reference allows you to change a value in multiple formulas bychanging the value in a single cell. The cell references in a formula are calledassumptions.
Detailed explanation-2: -a combination of cell references, operators, values, and/or functions used to perform calculations. You should use cell references in formulas instead of constant values so that: you can change the input values without changing the formulas.
Detailed explanation-3: -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.