Gilberto also wants to display the total accessory sales from the previous year. This data is stored in another workbook. In cell B12 of Gilberto's workbook, insert a formula using an external reference to cell B10 in the Accessories worksheet in the Support_EX19_EOM5-1_Accessories.xlsx workbook. How to do this in excel step by step
To create a formula using an external reference to another workbook in Excel, follow these steps:
1. Open both workbooks - the one you want to display the total accessory sales in (Gilberto's workbook) and the one where the data is stored (Support_EX19_EOM5-1_Accessories.xlsx).
2. In Gilberto's workbook, select the cell where you want to display the total accessory sales (in this case, cell B12).
3. Start typing your formula by entering an equal sign "=".
4. Click on the other workbook's window and navigate to the Accessories worksheet.
5. Click on cell B10 in the Accessories worksheet to select it in the formula.
6. Press Enter to complete the formula.
After following these steps, the formula in cell B12 of Gilberto's workbook should display the total accessory sales from cell B10 in the Accessories worksheet of the Support_EX19_EOM5-1_Accessories.xlsx workbook.