Computer Science, asked by anjalimittal791920, 9 months ago

what do you understand by linking worksheets​

Answers

Answered by mindfulmaisel
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