Delete the unnecessary values in cells C8, C12, and C16, and close the Support_EX19_EOM5-1_2021.xlsx workbook. In cell C6 of the Dashboard worksheet in the original workbook, use the Paste Link command to create external references to the values in the Support_EX19_EOM5-1_2021.xlsx workbook.
Open the file Support_EX19_EOM5-1_2021.xlsx. Lonnie wants to compare 2021 profit and loss totals to those for 2022 and needs to add the 2021 data to the Dashboard worksheet.In cell H10, create a hyperlink to the workbook Support_EX19_EOM5-1_2021.xlsx, which contains Lewellen profit and loss data from 2021.
In cell H9, create a hyperlink to cell A1 in the Categories worksheet.Use Contact a Lewellen consultant as the ScreenTip text. In cell H8, create a hyperlink to the email address.In cell H7, create a hyperlink to the website. Lonnie first wants to complete the list of links in the range H7:H10. He asks for your help in completing the statement. Lonnie is using an Excel workbook with multiple worksheets to create a profit and loss statement for the firm. The firm also has offices in Charlotte, North Carolina Milwaukee, Wisconsin and Denver, Colorado. Lonnie Holtzman is a financial analyst for the Lewellen Group, a management consulting firm headquartered in Providence, Rhode Island.If cell B6 does not display your name, delete the file and download a new copy from the SAM website.With the file NP_EX19_EOM5-1_ FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:.The program will add the file extension for you automatically. xlsx file extension in the Save As dialog box, do not type it. Save the file as NP_EX19_EOM5-1_ FirstLastName_2.xlsx by changing the “1” to a “2”.Open the file NP_EX19_EOM5-1_ FirstLastName_1.xlsx, available for download from the SAM website.Open the file NP_EX19_EOM5-1_FirstLastName_1
New Perspectives Excel 2019 | Module 5: End of Module Project 1
0 kommentar(er)
