Cashback Offer from 1st to 15th March 2021. Get Flat 20% Cashback credited to your account for a minimum transaction of $80. Post Your Question Today!

Question Details Normal
$ 15.00

Excel Chapter 12: Templates, Styles, and, Macros

Question posted by
Online Tutor Profile
request

Templates, Styles, and, Macros

 

Project Description:

You are the accounts receivables manager for DLJ Enterprises, a national textile company headquartered in Detroit, Michigan. As part of your daily tasks, you mail invoices to the various companies that use your services. After years of manually creating invoices, you have decided to create a template invoice that can easily be modified for each user. You have also decided to add macros to this template to provide the ability to clear contents and print.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Download and open the file named exploring_e12_grader_a1.xlsx, and then save the file as e12c2Invoice_LastFirst in the macro-enabled template file format, replacing LastFirst with your name.

0

2

Click the VIEW tab in the ribbon, and click Headings in the Show group. 

5

3

Click cell B3 and type DLJ Enterprises. (include the period).

5

4

Apply the Note Cell Style to cells C8:C10 and B15:C16. Apply 60% Accent 3 to cells B8:B10 and H8:H16.

5

5

Record a macro named ClearInvoice. The macro should clear the contents of the range C8:C10, then the range B15:C16, then the range I8:I16, and finally the range B21:I34. (Do not clear the contents in all of the ranges simultaneously.) Once completed, stop the macro recorder and save the template.

20

6

Create a new macro button named Reset that spans the range B47:D52 and assign the ClearInvoice macro as its action.

10

7

Open the VBA Editor and create a new module. Create a new function named freight. Craft this function to calculate cost * rate.

20

8

Apply the function to cell I37 using .10 as the rate. Save the template.

5

9

Unlock the following cells: C8:C10, B15:C16, I8:I16, and B21:I34.

15

10

Delete any data that is currently in cells: C8:C10, B15:C16, I8:I16, and B21:I34.

5

11

Open the VBA Editor and select the module containing the macro button source code. Copy the code beginning with the text Sub ClearInvoice() and ending with the text End Sub. Create a new worksheet named Code to the right of the Basic Invoice sheet. Paste the code in cell B3 on the Code worksheet. The copied code will fill the range B3:B18.

5

12

Open the VBA Editor and select the module containing the custom function. Copy the code beginning with the text Function freight(cost, rate) and ending with the text End Function. Paste in cell B20 of the Code worksheet. The copied code will fill the range B20:B24.

5

13

Save the file as an Excel Workbook with the name e12c2Invoice_solution. Ensure that the workbooks are displayed in the following order: Basic Invoice and Code. Close the workbook and exit Excel. Submit the e12c2Invoice_solution.xlsx workbook as directed.

0

 

Total Points

100

Available Answers
$ 20.00

[Solved] Templates, Styles, and, Macros

  • This Solution has been Purchased 1 time
  • Submitted On 15 Nov, 2016 07:28:25
Answer posted by
Online Tutor Profile
solution
I have done it P...
Buy now to view the complete solution
$ 5.00

[Solved] Excel Chapter 12: Templates, Styles, and, Macros

  • This Solution has been Purchased 2 time
  • Submitted On 15 Nov, 2016 04:56:18
Answer posted by
Online Tutor Profile
solution
please find the attached ...
Buy now to view the complete solution

The benefits of buying study notes from CourseMerit

Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton
Only 45 characters allowed.
closebutton

$ 629.35