DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Developer
|
|
|
Insert
|
|
|
Edit
|
|
|
Page Layout
|
Detailed explanation-1: -Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. For more information, see Show the Developer tab. In the Code group on the Developer tab, click Record Macro.
Detailed explanation-2: -On the Developer tab, in the Code group, click Record Macro.
Detailed explanation-3: -Once you click on the “Record Macro” option under the Developer tab, Excel will automatically start recording the user’s actions in the program. Clicking the “Record Macro” again will stop recording the macro, and save it for later use.
Detailed explanation-4: -Click File > Options > Quick Access Toolbar. In the Choose commands from list, click Macros. Select the macro you want to assign a button to. Click Add to move the macro to the list of buttons on the Quick Access Toolbar.