Can somebody do my grader project? EX16_XL_CH12_GRADER_ML2_HW – Lawn Care 1.3

1

Open the file exploring_e12_grader_h2_LawnCare.xlsx and save it as a Macro-Enabled Template named e12m2LawnCare_LastFirst.

0

2

Change the template theme colors to Green Yellow.

Hint: To change the themes, on the Page Layout tab, use the tools in the Themes group.

4

3

Delete the logo placeholder located in the upper left corner and slogan placeholder located in cell C2.

Hint: Click cell C2 and press DELETE.

2

4

Edit the placeholder text in cell B4 to reflect the company name Shield Lawn Care and apply the Title cell style.
Hint: On the Home tab, in the Styles group, click Cell Styles.

4

5

Unlock cell B19, the range B22:D30, and cell E7.

Hint: Select the desired cell or range of cells to unlock. Click the Home tab, click Format, and click Lock Cell.

4

6

Clear the contents of cells B19, B22:D30, E12:E16, and cell E7.

4

7

Create a macro named Finalize. The macro should insert the current date in cell E7.
Hint: On the Developer tab, in the Code group, click Record Macro. Next, enter the TODAY function in cell E7.

3

8

Create a form control button that spans the range B35:C37, assign the Finalize macro, and edit the button text to Finalize.
Hint: On the Developer tab, in the Controls group, click Insert, and then click Button (Form Control).

4.4

9

Use the Visual Basic Editor to create a new module. Create a new sub procedure within the module named Reset. The sub procedure should clear the contents of cell E7, the ranges B19:C19, and B22:D30.

4

10

Create a form control button that spans the range D35:E36, assign the Reset macro, and edit the button text to Reset.
Hint: On the Developer tab, in the Controls group, click Insert, and then click Button (Form Control).

4.4

11

Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on each worksheet.

Hint: To insert a custom footer, on the Page Layout tab, click the Page Setup dialog box launcher, click Header/Footer, and then click Custom Footer.

4

12

Open the VBA Editor and display the module containing the Finalize code. Copy the code beginning with the text Sub Finalize () and ending with the first instance of the text End Sub. Paste the contents in cell B2 of the Code worksheet.

Display the module containing the Reset code. Copy the code beginning with the text Sub Reset () and ending with the first instance of the text End Sub. Paste the contents in cell E2 of the Code worksheet. Close the VBA Editor.
Hint: On the Developer tab, in the Home group, click Visual Basic.

2.2

13

Save the workbook as an Excel Workbook (.xlsx) and close the workbook. Based on your instructor’s directions, submit e12m2LawnCare_LastFirst.xlsx.

0

Total Points

40