Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help understanding how to do C and D of this question. What is in red I got wrong. this is the formula that I
Need help understanding how to do C and D of this question. What is in red I got wrong.
this is the formula that I got wrong: ='[Support_EX19_CS5-8a_2020.xlsx]All Locations'!$F5
The first picture shown is what I got wrong.
The second picture shows on the left the one I need a formula for and the one on the right the one that i need to reference.
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.xisx. 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.xIsX. Create links to an external workbook. Create a formula using a function. In the All Locations worksheet, the formula in cell G5 should contain a mixed reference to cell F5 in the Support_EX19_CS5-8a_2020.xlsx workbook, with a relative reference to the row number. Copy a formula into a range. In the All Locations worksheet, cell G5 contains an incorrect formula. 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.xisx. 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.xIsX. Create links to an external workbook. Create a formula using a function. In the All Locations worksheet, the formula in cell G5 should contain a mixed reference to cell F5 in the Support_EX19_CS5-8a_2020.xlsx workbook, with a relative reference to the row number. Copy a formula into a range. In the All Locations worksheet, cell G5 contains an incorrect formula
Step 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