Creating and editing macros in Excel 365

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Which two statements describe how to navigate the VBA Editor in Excel 365?

-Expand projects to view or select the objects within them via the Project pane -Use the Modules pane to edit the code for a selected module

How can you differentiate between a macro-free workbook and a macro-enabled workbook icon?

The macro-enabled workbook icon has an exclamation point in the corner

Sequence the steps you would take to modify a macro in Excel 365. In this case, you want to assign a keyboard shortcut to the macro.

1.Navigate to the Developer tab 2.Open the Macro window 3.Select the macro to modify 4.Open the Macro Options window 5.Specify the keyboard shortcut

Sequence the steps you would take to edit a macro in Excel 365.

1.Navigate to the Developer tab 2.Open the Macro window 3.Select the macro you wish to edit 4.Select the option to edit the macro

Sequence the steps you would take to import a macro into a new workbook in Excel 365.

1.Navigate to the Developer tab 2.Open the VBA Editor 3.Right-click the module in the Project pane 4.Select the option to import a file 5.Navigate to and open the file to import

Sequence the steps you would take to manage macros security settings via the Ribbon in Excel 365. In this case, you want to access the Trust Center and enable Trust Center logging.

1.Navigate to the Developer tab on the Ribbon 2.Select the option to configure macro security settings 3.Navigate to the Message Bar tab 4.Select the option to enable Trust Center logging

Sequence the steps you would take to enable macros for a single session in Excel 365.

1.Navigate to the Info page in the Backstage view 2.Select the option to enable all workbook content 3.Open the Microsoft Office Security Options window 4.Select the option to enable content for one session

Sequence the steps you would take to run a macro via the View tab in Excel 365.

1.Open the View tab on the Ribbon 2.Navigate to the Macro window 3.Select the macro you wish to run 4.Select the option to run the macro

Place the steps to record a macro to a new workbook, in the order in which they should be performed in Excel 365.

1.Open the View tab on the Ribbon 2.Navigate to the Record Macro window 3.Store the macro in a new workbook 4.Start recording the macro

Sequence the steps to add the Macro Recording tool to the status bar in Excel 365. Then use the tool to name and record a macro in the workbook.

1.Right-click the status bar 2.Add the Macro Recording tool to the status bar 3.Activate the Macro Recording tool 4.Specify a name for the macro recording 5.Start recording the macro in the workbook


Set pelajaran terkait

Macroeconomics- all homeworks/quizzes

View Set

Exam #1 Principles of Entrepreneurship

View Set

Consumer Behavior Test 2 Chapter 3

View Set