In Some Situations, When Cell References Should Not Be Modified

question 46

Multiple Choice

In some situations, when cell references should not be modified when moved to a new location, a(n) _____ reference should be used.

• A) absolute
• B) fixed
• C) relative
• D) constant

---

Definitions:

Mean

The average of a set of numbers, calculated by adding them up and dividing by the count of numbers.

Mean Household Income

The average amount of money earned by households in a particular demographic or area.

Households in Michigan

The units of living quarters where the occupants live together, located within the geographical limits of Michigan.

Box and Whisker Plot

A graphical method to depict groups of numerical data through their quartiles, highlighting the median and variability of the data set.