Explain why you should use cell references instead of typing values in formulas.

What will be an ideal response?


The values could change. If you enter values in a formula, you would have to edit the formulas, which could introduce other errors. You should enter values in other cells and then use those cell references in the formulas. That way, when you change individual cell values, the results of the formulas will automatically update.

Computer Science & Information Technology

You might also like to view...

When configuring a radio button form control, the value of the ______ of each radio button must be the same

a. name b. id c. value d. none of the above

Computer Science & Information Technology

Brackets indicate to Access that a mathematical calculation is necessary

Indicate whether the statement is true or false

Computer Science & Information Technology

Imagine that you are faced with an ethical dilemma at work, and you must determine the "right," or ethical, course of action. List the eight steps you will go through to make this decision, including some of the questions you'll ask yourself at each step in the process.

What will be an ideal response?

Computer Science & Information Technology

Gordon is conducting a risk assessment for his organization and determined the amount of damage that flooding is expected to cause to his facilities each year. What metric has Gordon identified?

A. ALE B. ARO C. SLE D. EF

Computer Science & Information Technology