Module $9-$ Skills Review

Plan and enable a macro.

a$)$ You need to plan a macro that enters a Total label in cell D$17$ and a formula in cell E$17$ that totals the

managed assets in the range E$3$:E$16.$

b$)$ Write out the steps the macro will perform, and plan to store the macro in the workbook where you will

use it$.$

c$)$ Start Excel, open IL$\_$EX$\_9-2.$xIsx from the location where you store your Data Files, then save it as a

macro$-$enabled workbook named IL$\_$EX$\_9\_$Assets. $($Hint: The file will have the file extension $.$xlsm$.)$

d$)$ Use the Excel Options feature to display the Developer tab if it does not appear on the Ribbon.

e$)$ Using the Trust Center dialog box, enable all macros.

Record a macro.

a$)$ Open the Record Macro dialog box.

b$)$ Name the new macro Total, store it in the current workbook, and enter your name in the Description text

box.

c$)$ Record the macro, entering the label Total in cell D$17.$

d$)$ Right$-$align the label in cell D$17.$

e$)$ Add bold formatting to the label in cell D$17.$

f$)$ Use AutoSum to enter a function in cell E$17$ that totals the range E$3$:E$16.$

g$)$ Stop the recorder, then save the workbook.

Run a macro.

a$)$ Delete the contents of the range D$17$:E$17.$

b$)$ Run the Total macro.

c$)$ Confirm that the total text is right$-$aligned and bolded in cell D$17.$

d$)$ Confirm that the total assets appear in cell E$17.$

e$)$ Clear the cell entries generated by running the Total macro.

a$)$ Save the document as : IL$\_$EX$\_9-2\_$task$3.$xlsm

Page $1$ of $3$

Module $9-$ Skills Review

Edit a macro.

a$)$ Open the Macros dialog box, then open the Total macro for editing.

b$)$ In the Visual Basic window, change the line of code Selection.Font.Bold $=$ True to Selection.Font. Bold $=$

False.

c$)$ Use the Close and Return to Microsoft Excel command on the File menu to return to Excel.

d$)$ Test the Total macro, verifying that the Total label is not bold.

b$)$ Save the document as: IL$\_$EX$\_9-2\_$task$4.$xIsm

Assign a macro to a button.

a$)$ Clear the cell entries generated by running the Total macro.

b$)$ Using the first rectangle shape under Rectangles on the Shapes palette, draw a rectangle in cell A$17.$

c$)$ Label the button with the text Total Assets, then center and middle align the text.

d$)$ Assign the Total macro to the button, then test the button.

e$)$ Verify that the Total label and the total assets are entered in the range D$17$:E$17.$