help for excel module 5 a, question num 15

Name: Full Tutorial of Module 5: SAM Project 1a | New Perspectives Excel 2019
Uploaded: 2023-10-08T20:40:29Z

Question

Edra wants to compare 2021 sales totals to the sales totals for 2020 and needs to add the 2020 data to the Consolidated Sales worksheet. Open the file Support_EX19_5a_2020_Sales.xlsx. Switch back to the NP_EX19_5a_FirstLastName_2.xlsx workbook and go to the Consolidated Sales worksheet. Create external references as follows:
a. Link cell G6 in the Consolidated Sales worksheet to cell F6 in the Consolidated Sales 2020 worksheet in the Support_EX19_5a_2020_Sales.xlsx workbook.
b. Link cell G7 in the Consolidated Sales worksheet to cell F7 in the Consolidated Sales 2020 worksheet in the Support_EX19_5a_2020_Sales.xlsx workbook.
c. Link cell G8 in the Consolidated Sales worksheet to cell F8 in the Consolidated Sales 2020 worksheet in the Support_EX19_5a_2020_Sales.xlsx workbook.
d. Link cell G9 in the Consolidated Sales worksheet to cell F9 in the Consolidated Sales 2020 worksheet in the Support_EX19_5a_2020_Sales.xlsx workbook.
e. Do not break the links. Close the Support_EX19_5a_2020_Sales.xlsx workbook.
In cell G10, enter a formula to total the values in the defined range Totals_2020, using the SUM function and the defined range name.

davidmacago · Answer

Open Support_EX19_5a_2020_Sales.xlsx file. Go back to main file and click on cell G6. Type = and go to the Support_EX19_5a_2020_Sales.xlsx file and click on cell F6. And then hit enter. It must extract value from F6 and add in the G6 of main file. If you click on G6 it must have ='[Support_EX19_5a_2020_Sales.xlsx]Consolidated Sales 2020'!F6 formula. Repeat same for others.
In cell G10 of the "Consolidated Sales" worksheet in main file, enter the formula =SUM(Totals_2020) to total the values in the defined range Totals_2020.

Video instructions:

Answers