When You Copy a Formula from Cell A10 to Cell

question 2

Multiple Choice

When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?

• A) Excel places them on the Clipboard.
• B) Excel changes the cell references in the copied formula to reflect the new location of the formula.
• C) Excel bolds the cell references so you can change them.
• D) Excel displays a button near the copied cell with options for handling the cell references.

---

Definitions:

Jews

Refers to the members of an ethnoreligious group originating from the Israelites or Hebrews of the ancient Middle East, associated with the religion of Judaism.

Irish

Pertaining to Ireland or its people, culture, or language.

Whites

People identified as belonging to a racial group characterized by lighter skin tones, often associated with European ancestry.

American Media

The various forms of media in the United States that disseminate news, entertainment, and advertising.