Answer:
See Explanation
Explanation:
Given
Source: B6
Location: F16
I'll list two methods which Samuel can use to achieve his goal
Take for instance, the formula in cell B6 is =SUM(B1:B5)
This style of referencing is called relative cell referencing
If Samuel copies and the pastes the formula like this =SUM(B1:B5), the cell name will be changed in the destination cell; meaning that he wont be able to retain the formula and value.
<em>Method 1: Using Absolute Cell Reference</em>
Sam will have to alter the formula in cell B6 to =SUM($B$1:$B$5)
With this, he has switched from relative reference to absolute reference;
Irrespective of the location Sam wants to paste the formula (as long as the formula is in the same work book), the formula and the value won't change.
So, the formula will still maintain its original text and value, when pasted in cell F16
<em>Method 2: Move The Formula</em>
Alternatively, Sam can move the formula from cell B6 to cell F16.
This can be achieved by
1. Select cell B6
2. Click on Cut on the home tab (or press Ctrl + X)
3. Select cell F16
4. Click on Paste on the home tab (or press Ctrl + V)
