If the Cell Reference $A5 in a Formula Is Copied

question 81

Multiple Choice

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell.

• A)$A5
• B)$A7
• C)$C5
• D)$C7

---

Definitions:

High School GPA

A cumulative measure that reflects the average grade of a student throughout their high school career, typically on a 4-point scale.

Regression Line

A line through a scatter plot of data points that best expresses the relationship between those points, often used in predictive analytics.

The Intercept

In the context of linear regression, it represents the value of the dependent variable when all independent variables are zero.

Predicted Point

An estimated value derived from a statistical model indicating where a data point should fall based on the model's parameters.