Chat with us, powered by LiveChat In this project, you will assist Erica Ramirez, Sales Manager, to create a macro that enters footer information on chart sheet - School Writers

In this project, you will assist Erica Ramirez, Sales Manager, to create a macro that enters footer information on chart sheet

Excel_9G_Billing

  

Project Description:

In this project, you will assist Erica Ramirez, Sales Manager, to create a macro that enters footer information on chart sheets. You will also create several check boxes to indicate manager approval on sales bonuses.

     

Open   the Excel workbook Student_Excel_9G_Billing.xlsx downloaded with this project.   Save the file in your Excel Chapter 9 folder as an Excel Macro-Enabled   Workbook.

 

Display the Mortgage Chart   sheet. Record a macro named Chart_Setup and assign the letter j as the Shortcut key. Store the macro in This Workbook.   As the description, type Create footers in chart sheets and then click OK to begin   recording the macro.

 

On the Page Layout tab, click   Margins, and then click Custom Margins. Display the Header/Footer tab, and   then insert a Custom Footer on the Mortgage Chart sheet that includes the   File name in the left section and the Sheet name in the right section, and   then Stop Recording the macro.

 

Display the Macro dialog box and   then Edit the macro code. Click after the apostrophe in the line below the   second comment—Create footers in chart   sheets—press SPACEBAR, and then type Inserts file name and sheet name 

 

Close and Return to Microsoft Excel.   Add the Chart_Setup macro to the Quick Access Toolbar. Modify the button by   changing it to the pie chart—in the second row, the ninth button. If the pie   chart button is not available, choose another button.

 

Display the Construction Chart   sheet, and then use the button you assigned to the Quick Access Toolbar to   insert the footer. View the Print Preview to verify that the footer was   inserted.

 

Display the Summary sheet.   Insert three ActiveX Check Box controls positioned at cell B10, B12, and B14   and assign the following properties:
 

  PROPERTY NAME CAPTION
CheckBox1 Billing Billing Verified
CheckBox2 Contact Contacts Verified
CheckBox3 Manager Manager Assigned

 

Select all three check box   controls so that you can modify the following properties at the same time.   Change the Height to 18 and the Width to 105 and then change the Font to Bold Italic. With all three check   boxes still selected, Distribute Vertically and then Align Left. Turn off   Design Mode and then select each check box.

 

Remove the pie chart icon from   the Quick Access Toolbar. Display the file properties. As the Tags, type billing   summary and as   the Subject, type your course name and section number. Under Related People,   be sure that your name displays as Author. Save your workbook.

 

On the Developer tab, in the   Code group, click Macros, and then with the Chart_Setup macro selected, click   Edit. Select and Copy the four green comment lines beginning with the Chart_Setup Macro line and ending with   the Keyboard Shortcut line. Be sure   to include the apostrophe at the beginning of the first selected line. Close   and Return to Microsoft Excel.
 

  Insert a new worksheet. Rename the sheet Macro Code and then Paste the comment code   to cell A1. AutoFit column A and then move the Macro Code sheet to the end of   the workbook after the Construction Chart sheet. Make the Summary sheet the   active sheet.

 

Click the File tab, and then   click Save As. Navigate to your Excel Chapter 9 folder, and then click the   Save as type arrow. Click Excel workbook. In the File name box, type Student_Excel_9G_Billing_VBA and then click Save. In the   displayed message box, click Yes. Close your workbook and submit your Student_Excel_9G_Billing_VBA file for   grading.

Grader – Instructions Excel 2019 Project

Excel_9G_Billing

Project Description:

In this project, you will assist Erica Ramirez, Sales Manager, to create a macro that enters footer information on chart sheets. You will also create several check boxes to indicate manager approval on sales bonuses.

Steps to Perform:

Step

Instructions

Points Possible

1

Open the Excel workbook Student_Excel_9G_Billing.xlsx downloaded with this project. Save the file in your Excel Chapter 9 folder as an Excel Macro-Enabled Workbook.

0

2

Display the Mortgage Chart sheet. Record a macro named Chart_Setup and assign the letter j as the Shortcut key. Store the macro in This Workbook. As the description, type Create footers in chart sheets and then click OK to begin recording the macro.

20

3

On the Page Layout tab, click Margins, and then click Custom Margins. Display the Header/Footer tab, and then insert a Custom Footer on the Mortgage Chart sheet that includes the File name in the left section and the Sheet name in the right section, and then Stop Recording the macro.

1

4

Display the Macro dialog box and then Edit the macro code. Click after the apostrophe in the line below the second comment—Create footers in chart sheets—press SPACEBAR, and then type Inserts file name and sheet name

10

5

Close and Return to Microsoft Excel. Add the Chart_Setup macro to the Quick Access Toolbar. Modify the button by changing it to the pie chart—in the second row, the ninth button. If the pie chart button is not available, choose another button.

1

6

Display the Construction Chart sheet, and then use the button you assigned to the Quick Access Toolbar to insert the footer. View the Print Preview to verify that the footer was inserted.

15

7

Display the Summary sheet. Insert three ActiveX Check Box controls positioned at cell B10, B12, and B14 and assign the following properties: PROPERTY NAME CAPTION CheckBox1 Billing Billing Verified CheckBox2 Contact Contacts Verified CheckBox3 Manager Manager Assigned

15

8

Select all three check box controls so that you can modify the following properties at the same time. Change the Height to 18 and the Width to 105 and then change the Font to Bold Italic. With all three check boxes still selected, Distribute Vertically and then Align Left. Turn off Design Mode and then select each check box.

15

9

Remove the pie chart icon from the Quick Access Toolbar. Display the file properties. As the Tags, type billing summary and as the Subject, type your course name and section number. Under Related People, be sure that your name displays as Author. Save your workbook.

8

10

On the Developer tab, in the Code group, click Macros, and then with the Chart_Setup macro selected, click Edit. Select and Copy the four green comment lines beginning with the Chart_Setup Macro line and ending with the Keyboard Shortcut line. Be sure to include the apostrophe at the beginning of the first selected line. Close and Return to Microsoft Excel. Insert a new worksheet. Rename the sheet Macro Code and then Paste the comment code to cell A1. AutoFit column A and then move the Macro Code sheet to the end of the workbook after the Construction Chart sheet. Make the Summary sheet the active sheet.

15

11

Click the File tab, and then click Save As. Navigate to your Excel Chapter 9 folder, and then click the Save as type arrow. Click Excel workbook. In the File name box, type Student_Excel_9G_Billing_VBA and then click Save. In the displayed message box, click Yes. Close your workbook and submit your Student_Excel_9G_Billing_VBA file for grading.

0

Total Points

100

Created On: 10/04/2019 1 GO19_XL_CH09_GRADER_9G_HW – Billing 1.0

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?