Spreadsheets: relative referencing
The tutor points out an elegant feature of spreadsheets. Formulas in Excel default to relative referencing. Consider the following illustration: Let’s imagine you input 101 in cell e10. Then, in f11, you input the formula =e10. Of course, when you …