Final answer:
To display data from cell F22 on the 'All Locations' worksheet in cell B1, use the formula '=All Locations!F22' and then double-click the boundary line of column B's header to resize it for best fit.
Step-by-step explanation:
To display the total sales amount from cell F22 on the All Locations worksheet in cell B1, you need to enter the following formula:
='All Locations'!F22
Once the formula is entered, resize column B for the best fit. To do this, you can double-click the boundary line on the column header between columns B and C, or you can manually drag the boundary to adjust the width until the contents are displayed properly.
Excel formulas with worksheet references are powerful tools to display or calculate data from different parts of a workbook. By using a worksheet reference in your formula, you ensure that the data is dynamically linked and updated across worksheets.