NP_EX19_10b
Question Description
·Open the file NP_EX19_10b_FirstLastName_1.xlsx, available for download from the SAM website.
·Save the file as NP_EX19_10b_FirstLastName_2.xlsx by changing the “1” to a “2”.
oIf you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
·To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
oSupport_EX19_10b_History.csv
oSupport_EX19_10b_Restore.accdb
·With the file NP_EX19_10b_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
oIf cell B6 does not display your name, delete the file and download a new copy from the SAM website.
·To complete this project, you need to add the Power Pivot tab to the ribbon as follows:
From the File tab, click the Options button. In the Data Options section of the Data tab, click the checkbox next to Enable Data Analysis add-ins: Power Pivot, Power View and 3D Map, and click OK
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."