Excel_9e_operations | Computer Science homework help



Project Description:

In the following project, you will assist Bill Roman, Project Director, in creating a macro that will assign an operations department heading required on all reports. You will modify the macro by changing the Visual Basic Code. 


Navigate to your Excel Chapter 9   folder, and then double-click the Excel file you downloaded from MyLab IT   that displays your name—Student_Excel_9E_Operations.xlsx.   Verify that the Developer tab is enabled and the Macro Settings are set to   Disable all macros with notification. Display the Save As dialog box,   navigate to your Excel Chapter 9 folder, set the Save as type to Excel   Macro-Enabled Workbook, and then save your file.


With cell A1 active, record a   macro with the name Operations_Header and the shortcut key Ctrl + m. (Mac users, use   Option + Command + m.) Store the macro in This Workbook. As the description,   type Fills   in Operations report heading and then click OK to begin recording the macro.


Insert two blank rows at the top   of the worksheet, and then click cell A1. Type WPHRC Operations Department and then Merge & Center the   text you typed across the range A1:E1. Apply the Title cell style. In cell   A2, type Quarterly Report and then Merge & Center the text you typed   across the range A2:E2. Apply the Heading 1 cell style. Center the worksheet   Horizontally, click cell A1, and then stop recording the macro.


Delete rows 1:2, click cell A1,   and then test the macro.


On the Developer tab, in the   Code group, click Macros. Verify that the Operations_Header macro is   selected, and then click Edit. Scroll down and locate the first instance of End With, and then in the fourth line   following End With, edit Quarterly Report to indicate Quarterly   Operations Report.


Click File, and then click Close   and Return to Microsoft Excel. Delete rows 1:2, click cell A1, and then use   the keyboard shortcut to run the macro to test that Quarterly Operations Report displays as the subtitle of the   report.


Insert a footer with the file   name in the left section, and then display the worksheet in Print Preview to   verify that the worksheet is centered horizontally. Display the file   properties. As the Tags, type operations department report 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. Select your Operations_Header macro, and then click   Edit. Select and Copy all of the code. Close and Return to Microsoft Excel.   In the sheet tab area, click New sheet to insert a new worksheet. Rename the   inserted sheet Macro Code and then with cell A1 active, Paste the code to the   new worksheet. AutoFit column A.


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_9E_Operations_VBA and then click Save. In the   displayed message box, click Yes. Close your file and submit your   Student_Excel_9E_Operations_VBA file as directed.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages