Question: need help with sam projects... sam' Five Points Media GETTING STARTED Open the file IL_EX16_9a_FirstLastName_1.xism, available for download from the SAM website. Save the file
need help with sam projects...

sam' Five Points Media GETTING STARTED Open the file IL_EX16_9a_FirstLastName_1.xism, available for download from the SAM website. Save the file as IL_EX16_9a_FirstLastName_2.xism by changing the "1" to a "2". O If you do not see the .xIsm file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file IL_EX16_9a_FirstLastName_2.xIsm still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. O If cell B6 does not display your name, delete the file and download a new copy from the SAM website. If you see a Message Bar with a security warning at the top of the Excel window, click the Enable Content button in the Message Bar to enable the macros contained in the file. [Mac Hint - If you see a popup with a security warning, click Enable Macros to enable the macros contained in the file.] To complete this project you will need to display the Developer tab. To add this tab to the Excel ribbon, click the File tab to open Backstage View and then click the Options button. In the Excel Options dialog box, click the Customize Ribbon option and click the Developer check box. Click the OK button to close the Excel Options dialog box and confirm the Developer tab appears in the Excel Ribbon. PROJECT STEPS 1. Robert Cisneros is the sales manager for Five Points Media, a company selling subscriptions to online media including movies and TV shows. He has asked you to help him automate a worksheet he will use to analyze sales data each week. Switch to the Week 1 worksheet. Run the Title macro to insert a title for the worksheet in cell Al. 2. Edit cell Al to add 1/6/2020 as the date at the end of the title. 3 . Add totals to the worksheet as follows: a . Assign the Totals macro to the Totals button in column H. b . Use the Totals button to run the Totals macro. 4 . Identify the top five sales for the week by recording a new macro as follows: a. Enter Top as the macro name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
