When You Paste Formula Cells Using the Paste Button in the Clipboard

question 38

Multiple Choice

When you paste formula cells using the Paste button in the Clipboard group,which of the following is true?

• A) The Paste Options button then lets you paste specific elements of the copied cells.
• B) The formula is copied with cell references you must adjust to avoid worksheet errors.
• C) The Auto Fill Options button appears.
• D) Pointing to the destination cell causes a preview of the cell contents to appear.

---

Definitions:

Population Surveys

Research methods that collect data from a specific population or sample to gather insights on various aspects like health, opinions, or social conditions.

Overweight

A condition characterized by having more body weight than is considered healthy for a certain height, often measured by Body Mass Index (BMI).

Obese

A medical condition characterized by excessive body fat accumulation, increasing the risk of health problems.

Body Mass Index (BMI)

A numerical value calculated from a person's weight and height, used as an indicator to categorize their body weight as underweight, normal weight, overweight, or obese.