Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel 9E_DLP_Accounting Instructions (Protected View) - Word View Help Tell me what you want to do Layout References Mailings Review ternet can contain viruses. Unless

Excel 9E_DLP_Accounting Instructions (Protected View) - Word View Help Tell me what you want to do Layout References Mailings Review ternet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. . Steps to Perform: Bi f6 40 6 Step 20 40 50 6a 7a 90 11 12a 111 30 80 10 & Open the Excel workbook Excel 9E_DLP_Accounting as xlsx downloaded with this project. Ensure that the Developer tab is enabled. " On Sheet1, with cell A1 selected, begin to record a macro. Name the macro as Accounting_Macro and assign CTRL+r as the Shortcut key. Do not close the Macro dialog box (Mac users, assign OPTION+CMD+r) Store the macro in this workbook, and enter the text Fills-in-report-heading as the description. Close the dialog box. While recording the macro, be sure to follow the steps- exactly as specified. Do not switch between windows or worksheets in between steps." In Sheet 1, in recording mode, insert two blank rows, one at a time, at the top of the worksheet. In cell A1, type DLP-Accounting. Merge and center the text you just typed across the range A1 E1, and then apply the Title cell style. Instructions# In cell-A2, type Quarterly-Report. Merge and center the text you just typed across the range- A2 E2, and then apply the Heading 1-cell style. Enable Editing Center the worksheet horizontally, click cell A1, and then stop recording the macro. Delete rows 1:2, return to cell A1, press-CTRL+R to run the macro and ensure that the macro-works- as expected. In the Microsoft Visual Basic for Applications window, copy the entire Accounting_Macro- macro including the Sub statement to the End Sub statement Paste the code into cell A1-of- Sheet2 In the Microsoft Visual Basic for Applications window, in the fourth line following the first End- With, edit Quarterly Report to indicate Quarterly-Operations Report." On Sheet 1, delete rows 1:2, return to cell A1, press CTRL+R to run the macro again and ensure that the macro works as expected 7 In the Microsoft Visual Basic for Applications window, copy the Accounting_Macro-code- between the first End With and the second With. There should be five lines of code, including- the line that you changed. Paste the code into cell A1 of Sheet3. The VBA code should display- in cells A1 A5 when pasted Save the macro-enabled workbook as an Excel workbook, using the same file name. Click- Yes to save it as a macro-free workbook. Submit the file for grading. Y U W 4+ 8 9 hp f10 ll O O fil P Total Points: F12 [ Points- Possiblen 80 60 Ox 12 15a 15a 10 12 1a 6 0xz 15a 1000 11 XI ins 11 B 8 CI 8 11 CI XX 11 n I II II TI prt sc ] 10C
image text in transcribed
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Kemp, Jeffrey Waybright

2nd edition

978-0132771801, 9780132771580, 132771802, 132771586, 978-0133052152

More Books

Students also viewed these Accounting questions

Question

6. Explain the power of labels.

Answered: 1 week ago

Question

5. Give examples of variations in contextual rules.

Answered: 1 week ago

Question

f. What stereotypes were reinforced in the commercials?

Answered: 1 week ago