Discuss the difference between a relative cell reference and an absolute cell reference. Include the following information in your answer: how the two types of cell addresses are designated, what happens when each type of cell reference is copied, and when it is appropriate to use each type of reference.
What will be an ideal response?
A relative cell reference is used when the relationship to the formula must be preserved; it is the most commonly used type of cell reference in Excel. An absolute cell reference is used when the exact cell reference must be maintained in all formulas referencing the cell address. Absolute cell references do not change even if formulas are copied to other locations. Relative cell addresses change when copied to reflect the appropriate column and row where the formula is being copied. The $ symbol placed before a column letter or row number in a cell address makes that portion of the cell reference absolute. It is appropriate to use an absolute cell reference (or mixed cell reference) when the value of a column, row, or cell address MUST be used in a formula. All other times, relative cell references may be used.
You might also like to view...
Which of the following is a negative of binary search?
a. It requires significantly more memory than linear search. b. It is slower than linear search. c. The data must be in sorted order. d. None of the above.
The font of a chart's caption and labels in a PowerPoint slide should be ________ or larger
Fill in the blank(s) with correct word
The shape of a mesh can be manipulated by direction lines.
Answer the following statement true (T) or false (F)
No modeling tool is perfect. For example, BPM easily shows gateways that depend on a condition, but most project management software does not have that built-in capability. Programmers can create macros or custom scripts to handle such situations, but that can be expensive and time-consuming. Some project managers have discovered that they can create an alternative task series by making certain tasks active or inactive, depending on a specific condition. In Microsoft Project Professional help, search for information about active tasks, and write a summary of your research. Then create a PERT segment that shows the business process model you created in Task 1.
What will be an ideal response?