DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Developer
|
|
|
Data
|
|
|
Formulas
|
|
|
Insert
|
Detailed explanation-1: -On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box.
Detailed explanation-2: -The Developer tab is a very useful addition to the Excel ribbon that allows you to access a number of advanced features such as VBA macros, ActiveX and Form controls, XML commands, and more.
Detailed explanation-3: -There are nine tabs on the Excel Ribbon: File, Home, Insert, Page Layout, Formulas, Data, Review, View, and Help. The Home tab is the default tab when Excel is opened.
Detailed explanation-4: -When you choose the Macro button on the Developer tab, it opens the Macros dialog box, which gives you access to VBA subroutines or macros that you can access from a particular document or application. The Visual Basic button opens the Visual Basic Editor, where you create and edit VBA code.
Detailed explanation-5: -Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it.