10. 11. Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows: a. b. C d. e. In cell A5, enter a formula without using a function that references cell A5 in the Madison worksheet. Copy the formula from cell A5 to the range A6:A8 without copying the formatting. In cell BS, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison worksheets. Copy the formula from cell BS to the range B6:B8 without copying the formatting. Copy the formulas and the formatting from the range B5:88 to the range CS:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.) Min Jee started to create named ranges in the worksheet and has asked you to complete the work. Create a defined name for the range 85:E5 using Ceramics as the range name. 12. Create names from the range A6:E8 using the values shown in the left column. 13. Apply the defined names Q1 Sales, Q2 Sales, Q3 Sales, and Q4 Sales to the formulas in the range 89:E9. 14. Change the defined name to Total Sales 2021 for the range FS:F8. [Mac Hint: Delete the existing defined name "Totals" and add the new defined name.] 15. 16. Min Jee wants to compare 2021 sales totals to the sales totals for 2020 and needs to add the 2020 data to the Combined Sales worksheet. Open the file Support EX19_5b_Combined 2020.xlsx. Switch back to the original workbook and go to the Combined Sales worksheet. Create external references as follows: a. b. C. d. e. Link cell G5 in the Combined Sales worksheet to cell F5 in the Combined Sales worksheet in the Support EX19_5b_Combined 2020.xlsx workbook. Link cell G6 in the Combined Sales worksheet to cell F6 in the Combined Sales worksheet in the Support EX19_5b_Combined 2020.xlsx workbook. Link cell G7 in the Combined Sales worksheet to cell F7 in the Combined Sales worksheet in the Support EX19_5b_Combined 2020.xlsx workbook. Link cell G8 in the Combined Sales worksheet to cell F8 in the Combined Sales worksheet in the Support EX19_5b_Combined 2020.xlsx workbook. Do not break the links. Close the Support EX19_5b_Combined 2020.xlsx workbook. In cell G9, enter a formula to total the values in the defined range Totals 2020, using the SUM function and the defined range name. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project