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

To Get this Solution Contact us on Email and WhatsApp is given in Video
WhatsApp no : +923114151799
Email address: [email protected]

#NewPerspectives

#Excel2019

#Module12

#Project1

#EndOfModuleProject

#NewPerspectives, #Excel2019, #Module12, #Project1, #EndOfModuleProject

Go to the Payments worksheet and then unprotect it so that you can edit the contents.

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.

Clear the print area from the worksheet.

Go to the Entry Form worksheet. In cell C3, add a data validation list that accepts only the values in the range I3:I203.

In cell C4, create another data validation rule that allows date values greater than or equal to 10/7/2021. Add an input message with the title Date of Payment and use Enter a date of 10/7/2021 or later. as the message. Add a Warning alert with the title Invalid Date and the error message Verify the payment date.

Hide column I.

Record a macro named Enter_Payment stored in the current workbook. While recording, do the following:

Go to the Payments worksheet, and then click cell H4.

Insert a table row above, click an empty cell, then reselect cell H4.

Go to the Entry Form worksheet, and copy the range C3:C5.

Return to the Payments worksheet, use Paste → Transpose.

Select cell L1.

Return to the Entry Form worksheet, press ESC, and then click cell B15.

Stop recording the macro.

Edit the Enter_Payment macro in the VBA editor. After Range("B15").Select, insert:

ActiveCell.FormulaR1C1 = "Payment information entered"
Range("C3").Select

#NewPerspectivesExcel2019Module1EndofModuleProject1
#NewPerspectivesExcel2019Module1EndofModuleProject2
#NewPerspectivesExcel2019Module2EndofModuleProject1
#NewPerspectivesExcel2019Module2EndofModuleProject2
#NewPerspectivesExcel2019Module3EndofModuleProject1
#NewPerspectivesExcel2019Module3EndofModuleProject2
#NewPerspectivesExcel2019Module4EndofModuleProject1
#NewPerspectivesExcel2019Module4EndofModuleProject2
#NewPerspectivesExcel2019Module5EndofModuleProject1
#NewPerspectivesExcel2019Module5EndofModuleProject2
#NewPerspectivesExcel2019Module6EndofModuleProject1
#NewPerspectivesExcel2019Module6EndofModuleProject2
#NewPerspectivesExcel2019Module7EndofModuleProject1
#NewPerspectivesExcel2019Module7EndofModuleProject2
#NewPerspectivesExcel2019Module8EndofModuleProject1
#NewPerspectivesExcel2019Module8EndofModuleProject2
#NewPerspectivesExcel2019Module9EndofModuleProject1
#NewPerspectivesExcel2019Module9EndofModuleProject2
#NewPerspectivesExcel2019Module10EndofModuleProject1
#NewPerspectivesExcel2019Module10EndofModuleProject2
#NewPerspectivesExcel2019Module11EndofModuleProject1
#NewPerspectivesExcel2019Module11EndofModuleProject2
#NewPerspectivesExcel2019Module12EndofModuleProject1
#NewPerspectivesExcel2019Module12EndofModuleProject2
#NewPerspectivesExcel2019Module1SAMProject1a
#NewPerspectivesExcel2019Module1SAMProject1b
#NewPerspectivesExcel2019Module2SAMProject1a
#NewPerspectivesExcel2019Module2SAMProject1b
#NewPerspectivesExcel2019Module3SAMProject1a
#NewPerspectivesExcel2019Module3SAMProject1b
#NewPerspectivesExcel2019Module4SAMProject1a
#NewPerspectivesExcel2019Module4SAMProject1b
#NewPerspectivesExcel2019Module5SAMProject1a
#NewPerspectivesExcel2019Module6SAMProject1a
#NewPerspectivesExcel2019Module7SAMProject1a
#NewPerspectivesExcel2019Module7SAMProject1b
#NewPerspectivesExcel2019Module8SAMProject1a
#NewPerspectivesExcel2019Module8SAMProject1b
#NewPerspectivesExcel2019Module9SAMProject1a
#NewPerspectivesExcel2019Module9SAMProject1b
#NewPerspectivesExcel2019Module10SAMProject1a
#NewPerspectivesExcel2019Module10SAMProject1b
#NewPerspectivesExcel2019Module11SAMProject1a
#NewPerspectivesExcel2019Module11SAMProject1b
#NewPerspectivesExcel2019Module12SAMProject1a
#NewPerspectivesExcel2019Module12SAMProject1b


Save and close. Assign the macro to the Enter Payment button.

Enter the following into C3:C5 of the Entry Form worksheet and run the macro:

C
AC-1027
10/7/2021
3100

Test the Clear macro by clicking the Clear Entries button.

In the merged cell E4, use GETPIVOTDATA to display the number of registered students from cell B9 of the Summary PivotTable on the Payment Summary worksheet. In G4, display the total tuition billed from cell C9. In G8, display the total tuition paid from cell D9.

Unlock cells C3:C5, then protect the Entry Form worksheet (no password).