What Is the Significance of an Absolute Cell Reference in Excel

question 42

Multiple Choice

What is the significance of an absolute cell reference in Excel?

• A) The cell reference will not change if the formula containing the reference is copied to another location
• B) The cell will always contain the absolute value of any number entered into it
• C) The cell reference changes if the formula containing the reference is copied to another location
• D) It is the only formula used to refer to a cell on another spreadsheet

---

Definitions:

Return On Investment

A measure used to evaluate the efficiency of an investment or compare the efficiency of several different investments, calculated by dividing the benefit (return) of an investment by the cost of the investment.

Performance Measure

Indicators used to evaluate the efficiency, effectiveness, or success of an organization or individual in achieving objectives.

Project Rejection

The process of declining to move forward with a project after evaluating its feasibility, risks, and potential returns.

Operating Asset

An asset used in the daily operations of a business that contributes to generating income.