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:

American Economy

The economic system of the United States, characterized by a mix of private and public enterprises and a liberal market economy.

United States

A country located in North America, comprising 50 states and a federal district, known for its large economy and diverse population.

Free Trade

An economic strategy permitting the free movement of goods in and out of countries without the imposition of tariffs, quotas, or any form of restrictions.