FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A series of steps you can record to create a shortcut you can use for things you use a lot
A
parse
B
table
C
filter
D
macro
Explanation: 

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: -In the Developer tab, click Macros to view macros associated to a workbook. Or press Alt+ F8. This opens the Macro dialog box.

Detailed explanation-3: -Select the macro you want to run, by placing your cursor anywhere within the macro, and press F5, or on the menu, go to Run > Run Macro.

Detailed explanation-4: -Macros are small programs that record your actions as you perform a task in Excel. The actions are then saved as a Visual Basic Module, which is a type of program. When you run the macro later, it repeats your keystrokes and thus repeats your actions. This is why macros are great for automating repetitive tasks.

There is 1 question to complete.
Previous
Next