nnie Holtzman is a financial analyst for the Lewellen Group, a management consult m headquartered in Providence, Rhode Island. The firm also has offices in Charlotte orth Carolina; Milwaukee, Wisconsin; and Denver, Colorado. Lonnie is using an Exce orkbook with multiple worksheets to create a profit and loss statement for the firm. ks for your help in completing the statement. to the Dashboard worksheet. Lonnie first wants to complete the list of links in the nge H7:H10. In cell H7, create a hyperlink to the www.lewellen.example.net ebsite. cell H8, create a hyperlink to the info@lewellen.example.net email address. Use ontact a Lewellen consultant as the ScreenTip text. cell H9, create a hyperlink to cell Al in the Categories worksheet. cell H10, create a hyperlink to the workbook Support_EX19_EOM5-1_2021.xIsx, hich contains Lewellen profit and loss data from 2021. onnie wants to compare 2021 profit and loss totals to those for 2022 and needs to ad he 2021 data to the Dashboard worksheet. Open the file Support_EX19_EOM5- 2021.xlox. Copy the values in the range C6:C19. In cell C6 of the Dashboard orksheet in the original workbook, use the Paste Link command to create external eferences to the values in the Support_EX19_EOM5-1_2021.xisx workbook. Delete