Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
- 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:
- Open the workbook Support_EX19_CS5-8a_2020.xlsx.
- Return to the All Locations worksheet in the original workbook.
- In cell G5, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5).
- In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number.
- Fill the range G6:G8 with the formula in cell G5, filling without formatting.
- Close the workbook Support_EX19_CS5-8a_2020.xlsx.
I tried the formula below but its not working
workbook Support_EX19_CS5-8a_2020.xlsx.
55 Xv fx ='[Support_EX19_CS5-8a_2020.xlsx]All Locations'!F$5 A B D E F G G 3 Type Mini $ Voice-activated $ Waterproof $ 3 Total $ Q1 2,366 $ 1,812 $ 1,748 $ 5,926 $ 2021 Sales: All Locations Q2 Q3 Q4 Total 2020 Total 2,374 $ 2,421 $ 2,379 $ 9,540 $ 9,174 1,797 $ 1.844 $ 1,863 7,316 $ 6.043 1,755 $ 1,764 $ 1,797 7,064 $ 6,089 5,926 $ 6,029 $ 6,039 $ 23,920 $ 21,306 o in $000 1 A B C D E F G G 1 2 3 2020 Sales: All Locations 4 Type Q1 Q2 Q3 Q4 Total 5 Mini $ 2,290 $ 2,297 $ 2,298 $ 2,289 $ 9,174 6 voice-activated $ 1,509 $ 1,509 $ 1,514 $ 1,511 $ 6,043 7 Waterproof $ 1,517 $ 1,520 $ 1,524 $ 1,528 $ 6,089 8 Total $ 5,316 $ 5,326 $5,336 $5,328 $21,306 9 10 in $000 55 Xv fx ='[Support_EX19_CS5-8a_2020.xlsx]All Locations'!F$5 A B D E F G G 3 Type Mini $ Voice-activated $ Waterproof $ 3 Total $ Q1 2,366 $ 1,812 $ 1,748 $ 5,926 $ 2021 Sales: All Locations Q2 Q3 Q4 Total 2020 Total 2,374 $ 2,421 $ 2,379 $ 9,540 $ 9,174 1,797 $ 1.844 $ 1,863 7,316 $ 6.043 1,755 $ 1,764 $ 1,797 7,064 $ 6,089 5,926 $ 6,029 $ 6,039 $ 23,920 $ 21,306 o in $000 1 A B C D E F G G 1 2 3 2020 Sales: All Locations 4 Type Q1 Q2 Q3 Q4 Total 5 Mini $ 2,290 $ 2,297 $ 2,298 $ 2,289 $ 9,174 6 voice-activated $ 1,509 $ 1,509 $ 1,514 $ 1,511 $ 6,043 7 Waterproof $ 1,517 $ 1,520 $ 1,524 $ 1,528 $ 6,089 8 Total $ 5,316 $ 5,326 $5,336 $5,328 $21,306 9 10 in $000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started