Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

GETTING STARTED - Open the fileNP_EX19_12a_FirstLastName_1.xlsm, available for download from the SAM website. Files downloaded from the SAM website are safe and do not contain

image text in transcribed
GETTING STARTED - Open the fileNP_EX19_12a_FirstLastName_1.xlsm, available for download from the SAM website. Files downloaded from the SAM website are safe and do not contain viruses, but due to a recent Microsoft policy update, macros in downloaded files are disabled by default. To complete this project. you will need to enable macros in the file. To enable macros on this file: - For PC: Open Windows File Explorer and go to the folder where you saved the file. Right-click the file and choose Properties from the context menu. At the bottom of the General tab, select the Unblock checkbox and select Apply, and then click OK. - For Mac: If a dialog box about macros appears, click Enable Macros. - Save the file as NP_EX19_12a_FirstLastName_2.xIsm by changing the " 1 " to a " 2" ". 0 If you do not see the.x1sm 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 NP_EX19_12a_FirstLastName_2.xism still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. - If 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 Developer tab. If this tab does not display, right-click any tab on the ribbon. and then click Customize the Ribbon on the shortcut menu. In the Main Tabs area of the Excel Options dialog box, click the Developer check box, and click OK. PROJECT STEPS 1. Luis Palomba is in charge of community relations for Penta Insurance, a health insurance agency in Minneapolis, Minnesota. Luis is coordinating a program that sends tutors from Penta Insurance to area elementary schools. He is developing an Excel workbook to track and record the tutoring information, and needs to complete it before the upcoming Volunteer Fair. He asks for your help in automating the workbook. Go to the Tutor Summary worksheet and then unprotect it so you can edit the contents

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions