FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which ribbon tab in Excel 2016 provides access to macro settings and form controls?
A
Developer
B
Data
C
Formulas
D
Insert
Explanation: 

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.

There is 1 question to complete.