{"id":109283,"date":"2022-12-09T21:05:31","date_gmt":"2022-12-09T21:05:31","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/excel_9g_billing-computer-science-homework-help\/"},"modified":"2022-12-09T21:05:31","modified_gmt":"2022-12-09T21:05:31","slug":"excel_9g_billing-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/excel_9g_billing-computer-science-homework-help\/","title":{"rendered":"Excel_9g_billing | Computer Science homework help"},"content":{"rendered":"<div>\n<p><strong>Excel_9G_Billing<\/strong><\/p>\n<p>\u00a0\u00a0<\/p>\n<h2><strong>Project Description:<\/strong><\/h2>\n<p>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.<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n<p>Open \u00a0\u00a0the Excel workbook <em>Student_Excel_9G_Billing.xlsx <\/em>downloaded with this project. \u00a0\u00a0Save the file in your Excel Chapter 9 folder as an Excel Macro-Enabled \u00a0\u00a0Workbook.<\/p>\n<p>\u00a0<\/p>\n<p>Display the Mortgage Chart \u00a0\u00a0sheet. Record a macro named <strong>Chart_Setup<\/strong> and assign the letter <strong>j<\/strong> as the Shortcut key. Store the macro in This Workbook. \u00a0\u00a0As the description, type<strong> Create footers in chart sheets <\/strong>and then click OK to begin \u00a0\u00a0recording the macro.<\/p>\n<p>\u00a0<\/p>\n<p>On the Page Layout tab, click \u00a0\u00a0Margins, and then click Custom Margins. Display the Header\/Footer tab, and \u00a0\u00a0then insert a Custom Footer on the Mortgage Chart sheet that includes the \u00a0\u00a0File name in the left section and the Sheet name in the right section, and \u00a0\u00a0then Stop Recording the macro.<\/p>\n<p>\u00a0<\/p>\n<p>Display the Macro dialog box and \u00a0\u00a0then Edit the macro code. Click after the apostrophe in the line below the \u00a0\u00a0second comment\u2014<em>Create footers in chart \u00a0\u00a0sheets<\/em>\u2014press SPACEBAR, and then type <strong>Inserts file name and sheet name<\/strong>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>Close and Return to Microsoft Excel. \u00a0\u00a0Add the Chart_Setup macro to the Quick Access Toolbar. Modify the button by \u00a0\u00a0changing it to the pie chart\u2014in the second row, the ninth button. If the pie \u00a0\u00a0chart button is not available, choose another button.<\/p>\n<p>\u00a0<\/p>\n<p>Display the Construction Chart \u00a0\u00a0sheet, and then use the button you assigned to the Quick Access Toolbar to \u00a0\u00a0insert the footer. View the Print Preview to verify that the footer was \u00a0\u00a0inserted.<\/p>\n<p>\u00a0<\/p>\n<p>Display the Summary sheet. \u00a0\u00a0Insert three ActiveX Check Box controls positioned at cell B10, B12, and B14 \u00a0\u00a0and assign the following properties:<br \/>\u00a0<\/p>\n<p>\u00a0\u00a0PROPERTY NAME CAPTION<br \/><strong>CheckBox1<\/strong> <strong>Billing<\/strong> <strong>Billing Verified<\/strong><br \/><strong>CheckBox2<\/strong> <strong>Contact<\/strong> <strong>Contacts Verified<\/strong><br \/><strong>CheckBox3<\/strong> <strong>Manager<\/strong> <strong>Manager Assigned<\/strong><\/p>\n<p>\u00a0<\/p>\n<p>Select all three check box \u00a0\u00a0controls so that you can modify the following properties at the same time. \u00a0\u00a0Change the Height to <strong>18 <\/strong>and the Width to <strong>105 <\/strong>and then change the Font to Bold Italic. With all three check \u00a0\u00a0boxes still selected, Distribute Vertically and then Align Left. Turn off \u00a0\u00a0Design Mode and then select each check box.<\/p>\n<p>\u00a0<\/p>\n<p>Remove the pie chart icon from \u00a0\u00a0the Quick Access Toolbar. Display the file properties. As the Tags, type <strong>billing \u00a0\u00a0summary<\/strong> and as \u00a0\u00a0the Subject, type your course name and section number. Under Related People, \u00a0\u00a0be sure that your name displays as Author. Save your workbook.<\/p>\n<p>\u00a0<\/p>\n<p>On the Developer tab, in the \u00a0\u00a0Code group, click Macros, and then with the Chart_Setup macro selected, click \u00a0\u00a0Edit. Select and Copy the four green comment lines beginning with the <em>Chart_Setup Macro<\/em> line and ending with \u00a0\u00a0the <em>Keyboard Shortcut<\/em> line. Be sure \u00a0\u00a0to include the apostrophe at the beginning of the first selected line. Close \u00a0\u00a0and Return to Microsoft Excel.<br \/>\u00a0<\/p>\n<p>\u00a0\u00a0Insert a new worksheet. Rename the sheet <strong>Macro Code <\/strong>and then Paste the comment code \u00a0\u00a0to cell A1. AutoFit column A and then move the Macro Code sheet to the end of \u00a0\u00a0the workbook after the Construction Chart sheet. Make the Summary sheet the \u00a0\u00a0active sheet.<\/p>\n<p>\u00a0<\/p>\n<p>Click the File tab, and then \u00a0\u00a0click Save As. Navigate to your Excel Chapter 9 folder, and then click the \u00a0\u00a0Save as type arrow. Click Excel workbook. In the File name box, type <strong>Student_Excel_9G_Billing_VBA<\/strong> and then click Save. In the \u00a0\u00a0displayed message box, click Yes. Close your workbook and submit your <em>Student_Excel_9G_Billing_VBA<\/em> file for \u00a0\u00a0grading.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Excel_9G_Billing \u00a0\u00a0 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. \u00a0\u00a0\u00a0\u00a0\u00a0 Open \u00a0\u00a0the Excel workbook Student_Excel_9G_Billing.xlsx downloaded with this project. \u00a0\u00a0Save the file in your Excel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-109283","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/109283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=109283"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/109283\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=109283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=109283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=109283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}