BUSINESS ADMINISTRATION
COMPUTER APPLICATION IN BUSINESS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Vlookup
|
|
Pivot Table
|
|
Macro
|
|
Formatting
|
Detailed explanation-1: -Record a macro In the Code group on the Developer tab, click Record Macro. Optionally, enter a name for the macro in the Macro name box, enter a shortcut key in the Shortcut key box, and a description in the Description box, and then click OK to start recording.
Detailed explanation-2: -Tip. Do not select any cells after you’ve started recording the macro. This will ensure that all the formatting applis to the selection, not a specific range. Click Stop Recording on either the Developer tab or the Status bar.
Detailed explanation-3: -Instructions on How to Record a Macro in Excel: To record a macro in Excel, click the “View” tab in the Ribbon. Then click the “Macros” drop-down button in the “Macros” button group. Then select the “Record Macro…” command to open the “Record Macro” dialog box.