While copying values in excel, the external reference feature automatically adjusts cell references for the new copy location.
What are the steps to generate external references?
Make an External Reference
Execute the following steps to generate an external reference.
1. Launch all workbooks.
2. Select cell B2 in the Company spreadsheet and enter the equal sign =
Exemplification of External References
3. In the Window group on the View tab, click Switch Windows.
Change Windows
4. Select North. Navigate to the North.
5. Select cell B2 in the North worksheet. Choose a Cell
6. Type a Plus
Steps 3–6 must be repeated for the Mid workbook.
Steps 3–5 must be repeated for the South workbook.
9. Remove the $ symbols from cell B2's formula.
Result:
Excel External References
10. Paste the formula into the remaining cells.
Learn more about external references here,
brainly.com/question/2985666
# SPJ4
