An Absolute Cell Reference

question 52

Multiple Choice

An absolute cell reference:

• A)causes a potential error.
• B)indicates a cell's specific location and the reference does not change when you copy the formula.
• C)happens only when a formula indirectly refers to the cell containing the formula.
• D)contains both an absolute and a relative cell reference.

---

Definitions:

Personnel Limitation

Constraints or restrictions related to the number or capabilities of staff available for a project or operation.

Net Present Value

A calculation used to evaluate the profitability of an investment, subtracting the present values of cash outflows from the present values of cash inflows.

Binary Variable

A variable that takes on one of exactly two possible values, typically represented or coded as 0 and 1.

Processes

A series of actions or steps taken in order to achieve a particular end, often referring to sequences in manufacturing or computation.