Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows:
a. Open the workbook Support_EX19_CS5-8a_2020.xlsx.
b. Return to the All Locations worksheet in the original workbook.
c. In cell G5, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5).
d. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number.
e. Fill the range G6:G8 with the formula in cell G5, filling without formatting.
f. Close the workbook Support_EX19_CS5-8a_2020.xlsx.
Reading books is a great way to learn. Here are some of the books we recommend.
Steps 'a' and 'b' are self-explanatory.
c. Select G5 in All Locations worksheet and enter
=. Then go to Support_EX19_CS5-8a_2020.xlsx workbook and select F5. It should fill='[Support_EX19_CS5-8a_2020.xlsx]All Locations'!$F$5.d. We need to change the absolute reference to a mixed reference, with a relative reference to the row number. Change$F$5 to $F5 . So the new formula would be
='[Support_EX19_CS5-8a_2020.xlsx]All Locations'!$F5.e. Copt the formula of G5. Select G6:G8, right-click, and choose the Formula option in the paste.
Video Explanation