Скачать или смотреть New Perspectives Excel 2019 | Module 12 End of Module Project 2 | Abernathy Academy Module 12

New Perspectives Excel 2019 | Module 12 End of Module Project 2 | Abernathy Academy Module 12


#New Perspectives Excel 2019#Perspectives Excel 2019#Module 12 End of Module Project 2#Excel 2019 | Module 12#New Perspectives Excel 2019 | Module 12#End of Module Project#Module 12 End of Module#Abernathy Academy#DEVELOP AN EXCEL APPLICATION#Module 12
#Module Project 2#NP_EX19_EOM12-1#NP_EX19_EOM12-1_FirstLastName_1.xlsm#NP_EX19_EOM12-2









Abernathy Academy
DEVELOP AN EXCEL APPLICATION

GETTING STARTED
• Open the file NP_EX19_EOM12-1_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:
o 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.
o For Mac: If a dialog box about macros appears, click Enable Macros.
• Save the file as NP_EX19_EOM12-1_FirstLastName_2.xlsm by changing the “1” to a “2”.
o If you do not see the .xlsm 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_EOM12-1_FirstLastName_2.xlsm 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.
PROJECT STEPS
1. Tarif Hajany is the admissions director at the Abernathy Academy, a private secondary school in Roswell, Georgia. He is developing an Excel workbook to track and record tuition payments from registered students, which he and his staff record weekly. He asks for your help in automating the workbook. Go to the Payments worksheet and then unprotect it so that you can edit the contents.
2. Tarif wants to include a title at the top of the worksheet similar to the ones used in the rest of the workbook. Insert WordArt using the Fill: Gray, Accent color 1; Shadow style. Type Payments by Account as the worksheet title. Change the font size to 28 point, and then move the WordArt to row 1 so that it spans columns C:F.
3. Tarif thought he would print the worksheet, but no longer plans to do so. Clear the print area from the worksheet.
4. Go to the Entry Form worksheet. The Admissions staff will use this worksheet to enter tuition payments and summarize tuition information. Tarif wants to make it easy to record the payments and avoid errors. In cell C3, add a data validation list that accepts only the values in the range I3:I203.
5. In cell C4, create another data validation rule that allows date values greater than or equal to 10/7/2021. Add an input message to the cell with the title Date of Payment and use Enter a date of 10/7/2021 or later. as the input message. Add a Warning alert with the title Invalid Date as use Verify the payment date. as the error message.
6. Hide column I to avoid distracting users with the Account ID list.
7. After users enter the account ID, date, and payment amount, Tarif wants them to click the Enter Payment button to add a record to the Late_Payments table on the Payments worksheet. Record a macro named Enter_Payment stored in the current workbook. With the macro recording, perform the following steps:
· Go to the Payments worksheet, and then click cell H4.
· Insert a table row above, click an empty cell, then reclick on cell H4.
· Go to the Entry Form worksheet, and then copy the data in the range C3:C5.
· Return to the Payments worksheet, click the Paste arrow, and then click the Transpose