FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
A
logical
B
constant
C
consistent
D
calculated
Explanation: 

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.

There is 1 question to complete.