Question

Q6. Write steps of cell refrence to another worksheet using sheet reference.​

Answer 1

Answer:

${\bf{\red{ANSWER \: \: }}}$

Explanation:

To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2

Answer 2

⭐⭐⭐To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address.

...

Start typing the formula =19%* in cell B2 on sheet VAT.

Switch to sheet Sales, and click on cell B2 there. ...

Press Enter to complete the formula.⭐⭐⭐