DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The Data tab on the ribbon
|
|
|
The Developer tab on the ribbon
|
|
|
The context menu in the worksheet
|
|
|
Excel Options
|
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: -The DEVELOPER tab, on the ribbon, is where all of the macro commands are. To have it appear on the ribbon, click FILE > Options > Customize Ribbon, check Developer, and click OK.
Detailed explanation-3: -Excel has a built-in tool for writing macros called the Visual Basic Editor-or VBA Editor for short. To open that, open a spreadsheet and use the shortcut Alt + F11 (for Mac: Fn + Shift + F11 ). The new window that pops up is called the VBA Editor. It’s where you’ll edit and store all of your macros.