Which Type of Cell Reference Adjusts Automatically When Copied to Another

question 23

Multiple Choice

Which type of cell reference adjusts automatically when copied to another cell?

• A) Relative
• B) Mixed
• C) Absolute
• D) Complex

---

Definitions:

Mean Absolute Deviation

A measure of variability that shows the average distance between each data point and the mean of the data set.

Correlation Coefficient

A statistical measure that calculates the strength and direction of a linear relationship between two quantitative variables.

Trend Projection

A forecasting technique that involves analyzing historical data to identify consistent results or directions over time.

Linear Regression

A statistical method used to model the relationship between a dependent variable and one or more independent variables.