Question

Use ___________ Macro to start the macro recorder.

a. Tools > Macros > Record
b. Tools > Record > Record Macro

c. Data > Macros > Record
d. None of these​

Answer 1

Answer:

Option (b) is correct.

Use Tools> Record > Record Macro Macro to start the macro recorder.

Explanation:

Macro In Excel

In Excel, macro code is a programming code written in the VBA (Visual Basic for Applications) language.

The idea behind using macro code is to automate an action that you perform manually in Excel.

For example, you can use a code to print only the cells of a particular range with just one click instead of selecting the range.

Use Macros

Before using these codes, make sure you have your Developer tab on your Excel ribbon to access the VB editor in your Excel file.

• Once you have activated the Developer tab you can use the steps below to paste the VBA code into the VB editor.

• Go to your Developer tab and click "Visual Basic" to open the Visual Basic Editor.
• In the "Project Window" on the left, right-click on the name of your workbook and enter a new module.
• Just paste your code into the module and close it.
• Now, go to your Developer tab and click on the Macro button.
• This will show you a window with the list of macros present in your file from where you can run the macro from that list.

#SPJ3

Answer 2

Option d is correct.

Explanation:

• When you create a macro, the macro recorder creates a code file in Visual Basic for Applications or VBA that contains all the stages. You can do these actions by entering text or numbers, selecting cells or instructions from the ribbon or menus, styling the cells, rows, or columns, or even importing data from another application, like Microsoft Access. The versatile Visual Basic programming language's subset called Visual Basic Application is bundled with the majority of Office apps. Although VBA allows you to automate operations within and between Office apps, the Macro Recorder can accomplish your goals just as well without any programming or VBA knowledge.
• The Developer tab, which is by default hidden, is where we will find Macros and VBA tools, so the first step is to make it visible.
• We need to click Record Macro in the Code category under the Developer tab. Thus, Tools and data tab is inappropriate here and thus option a, b and c are incorrect.

Thus, option d is correct.

Learn more here

https://brainly.in/question/31158098

Learn more

https://brainly.in/question/27686351