Question: 1 5 . Min Jee wants to compare 2 0 2 4 sales totals to the sales totals for 2 0 2 3 and needs
Min Jee wants to compare sales totals to the sales totals for and needs to add the data to the Combined Sales worksheet. Open the file SupportEXbCombinedxlsx Switch back to the original workbook and go to the Combined Sales worksheet. Create external references as follows:
a Link cell G in the Combined Sales worksheet to cell F in the Combined Sales worksheet in the SupportEXbCombinedxlsx workbook.
b Link cell G in the Combined Sales worksheet to cell F in the Combined Sales worksheet in the SupportEXbCombinedxlsx workbook.
c Link cell G in the Combined Sales worksheet to cell F in the Combined Sales worksheet in the SupportEXbCombinedxlsx workbook.
d Link cell G in the Combined Sales worksheet to cell F in the Combined Sales worksheet in the SupportEXbCombinedxlsx workbook.
e Do not break the links. Close the SupportEXbCombinedxlsx workbook.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
