1. First, navigate to the "Year1" sheet in your Excel workbook.

2. Click on cell B8 to select it. This is where you will enter your formula.

3. Start your formula with an equals sign (=). This tells Excel that you're going to enter a formula, not just text or numbers.

4. Now, you need to reference the cell from the "Salaries" sheet. To do this, type the name of the sheet followed by an exclamation mark. In this case, it would be "Salaries!".

5. After the exclamation mark, type the cell reference you want to display. In this case, it's "B7".

6. Your complete formula should look like this: =Salaries!B7

7. Press Enter to complete the formula. The value from cell B7 on the "Salaries" sheet should now be displayed in cell B8 on the "Year1" sheet.

Remember, if the value in the original cell (Salaries!B7) changes, the value in Year1!B8 will automatically update to match it, because it's referencing that cell.

Question

1. First, navigate to the "Year1" sheet in your Excel workbook.

2. Click on cell B8 to select it. This is where you will enter your formula.

3. Start your formula with an equals sign (=). This tells Excel that you're going to enter a formula, not just text or numbers.

4. Now, you need to reference the cell from the "Salaries" sheet. To do this, type the name of the sheet followed by an exclamation mark. In this case, it would be "Salaries!".

5. After the exclamation mark, type the cell reference you want to display. In this case, it's "B7".

6. Your complete formula should look like this: =Salaries!B7

7. Press Enter to complete the formula. The value from cell B7 on the "Salaries" sheet should now be displayed in cell B8 on the "Year1" sheet.

Remember, if the value in the original cell (Salaries!B7) changes, the value in Year1!B8 will automatically update to match it, because it's referencing that cell.

Knowee AI · Accepted Answer