Spreadsheet Tool : OO Calc I — Question 24
Back to all questionsQuestion 25
Now move back the moved data range to the original position and make changes in the marks obtained by students. Notice total, average and class average. What happens ? Why does this happen ? What is this feature called ?
When we move back the moved data range to the original position and make changes in the marks obtained by students, the Total, Average, and Class Average values will automatically update to reflect the changes. This behavior is known as "relative referencing" i.e., the cell references within the formula are adjusted based on their relative positions when we copy or move the formula to different cells.
When we make changes to the marks obtained by students, the formulas for Total, Average, and Class Average are using relative references to the cells containing the student's marks. As a result, when we move the data range back to the original position, the formulas automatically adjust to reference the correct cells, and the calculations update accordingly.