Introduction to Spreadsheets with Microsoft Excel

Column translation: From E to F – 1 column to the right. Thus, all relative column references in the copied formula are adjusted by 1 column to the right. Row translation: 8-6=2 rows downwards. Thus, all relative row references in the formula are adjusted by 2 rows downwards. All other parts of the formula are copied exactly (without adjustment). ................
................