what do you understand by linking worksheets
Answers
Answered by
3
By linking the worksheets, we can eliminate having the same data to be maintained in multiple spreadsheets.
Explanation:
- In MS Excel, an external cell reference or a link can be defined as a formula in which it dynamically pulls the data from other worksheet.
- The ability of creating the links or any kind of external cell reference would eliminate maintaining same data in multiple sheets. This will result in,
- Reducing errors
- Saving the time
- Improving the data integrity
- For example, if we want to store product prices, we can create a worksheet named 'Master Price List' and store in it and we can link other sheets related to it.
To know more about linking of spreadsheet
Can you link to spreadsheet only ?
https://brainly.in/question/13664604
Similar questions