A dollar sign before the number means the row won't change; if you enter "\(=B\$1+C1\)" into cell \(D1\) and then copy it to cell \(D2\), it will change to "\(=B\$1+C2\)". And a dollar sign before bot...A dollar sign before the number means the row won't change; if you enter "\(=B\$1+C1\)" into cell \(D1\) and then copy it to cell \(D2\), it will change to "\(=B\$1+C2\)". And a dollar sign before both the column and the row means that nothing will change; if you enter "\(=\$B\$1+C1\)" into cell \(D2\) and then copy it into cell \(E2\), it will change to "\(=\$B\$1+D2\)". So if you had \(100\) numbers in column \(B\), you could enter "\(=B1-\text {AVERAGE}(B\$1:B\$100)\)" in cell \(C1\), copy i…
