Question

1. Metion the ways in which we can link the sheets.
2. How can we set value of one cell by changing the value of another cell?​

Answer 1

• Ways You Can Create a Link Between Tabs in a WorkbookUse the Equal sign to create a reference to a cell.
• ...Use the Paste Link feature to create a link to a data range. .
• ..Create a link to a named range.
• ...Create a hyperlink to another sheet.

Answer 2

Answer:

Create a cell reference to another worksheet

Click the cell in which you want to enter the formula. , type = (equal sign) and the formula you want to use. Click the tab for the worksheet to be referenced. Select the cell or range of cells to be referenced.