Excel ch 8 SimNet

Edit the code for the FormatPieChart macro in the Visual Basic Editor.

In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Macros button. Inside the Macro dialog from the Macro name: list, you selected FormatPieChart. Inside the Macro dialog, you clicked the Edit button.

Run the FormatPieChart macro.

In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Macros button. Inside the Macro dialog, you clicked the Run button.

Begin recording a new macro.

In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Record Macro button.

Record a new macro with the name NewTheme. Do not assign a shortcut key or description. The macro should apply the Facet theme and then use the AutoFit Column Width command to resize the selected columns.

In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Record Macro button. Inside the Record Macro dialog, you typed NewTheme in the Macro Name: input, clicked the OK button. In the Page Layout Ribbon Tab in the Themes Ribbon Group, you clicked the Themes button. In the Themes menu, you selected the Facet option. In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. In the Format menu, you clicked the AutoFit Column Width menu item. In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Stop Recording button.

Add a form control button to run the CreateQ1Chart macro. The button should be placed at approximately cell A1.

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Developer Ribbon Tab in the Controls Ribbon Group, you clicked the Insert button. In the Insert menu, you clicked the Button (Form Control) button. You inserted Button 1 form control into the sheet. Inside the Assign Macro dialog, you clicked the OK button.

You can save an Excel macro-enabled template in any folder.

True

You must save a workbook that includes macros as a macro-enabled workbook.

True

Add the Developer tab to the Ribbon.

You opened the backstage view, clicked the Options navigation button, and clicked the Customize Ribbon tab. Inside the Excel Options dialog, you checked the Developer check box, clicked the OK button.

Change the security setting to disable all macros and display a warning in the Message Bar so you can choose to enable them on a case-by-case basis.

You opened the backstage view, clicked the Options navigation button, and clicked the Trust Center tab. Inside the Excel Options dialog, you clicked the Trust Center Settings... button. You clicked the Macro Settings tab. Inside the Trust Center dialog, you selected the Disable all macros with notification Radio Button, clicked the OK button. Inside the Excel Options dialog, you clicked the OK button.

Save this file as a template that allows macros.

You opened the backstage view, clicked the Save As navigation button, clicked the Save as type drop-down, clicked the Excel Macro-Enabled Template (*.xltm) item, and clicked the Save button.

This workbook includes macros. Save it using the file type that allows macros.

You opened the backstage view, clicked the Save As navigation button, clicked the Save as type drop-down, clicked the Excel Macro-Enabled Workbook (*.xlsm) item, and clicked the Save button.

Edit the code for the FormatPieChart macro to change the chart style from 42 to 252. Save your changes.

You pressed the Ctrl + C keyboard shortcut, clicked cell A1. In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Macros button. Inside the Macro dialog from the Macro name: list, you selected FormatPieChart. Inside the Macro dialog, you clicked the Edit button. You edited the macro code, clicked the Save button.

Change the button text to: Create Q1 Pie Chart

You right-clicked the form button. In the Form Button Right-Click menu, you clicked the Edit Text menu item. You pressed the Enter key.