DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is a macro?
|
|
A picture that is inserted in a sheet
|
|
|
a recording of a sequence of commands and typed entries that you can then replay elsewhere in the worksheet
|
|
|
A type of chart
|
|
|
A type of graph
|
Explanation:
Detailed explanation-1: -When you record a macro, the macro recorder records all the steps in Visual Basic for Applications (VBA) code. These steps can include typing text or numbers, clicking cells or commands on the ribbon or on menus, formatting cells, rows, or columns, or even importing data from an external source, say, Microsoft Access.
Detailed explanation-2: -You can easily record a macro in Excel. 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.
Detailed explanation-3: -Answer: Press Alt + 8 or click the Macros button on the Developer tab. In the Macro dialog box, select the desired macro and click Run.
There is 1 question to complete.