$\backslash$table$[[$E$,$A$,$B$,$C$,$D$,$E$.,$I$],[1,1,6,11,16,,],[2,2,7,12,17,-82,],[3,3,8,13,18,=B$$$2,],[4,4,9,14,19,=$$$B2,],[5,5,10,15,20,$$$8B52,],[6,,,,,,]]$

If column E is copied and pasted into column G$,$ give both the formula and value for each non$-$empty cell in column G$.$

$$ Solution.

Any entry that is absolute $($with a $$)$ will be fixed. The relative references $($without the $$)$ will change all the Bs to Ds because we moved over $2$ columns.

Formulas

$($ show the work on spreadsheet$)$