What is a macro in VBA?*1 pointA data structureA loopA set of instructions to automate a taskA type of variable

What is a function in VBA?*1 pointA loopA set of instructions to automate a taskA data structureA predefined set of code that performs a specific task

1. What is the purpose of using macros in MS Excel?*A. To create data tablesB. To generate pivot chartsC. To automate repetitive tasksD. To protect workbook structure2. Which tab and dropdown menu in Excel allow you to view and run macros?*A. Data Tab » MacroB. View Tab » MacroC. Insert Tab » MacroD. Home Tab » Macro3. How can you create a macro in Excel using VBA code?*A. Use the Data TabB. Enter instructions in the Visual Basic EditorC. Record actions with the Macro RecorderD. Use the Review Tab4. What does the VLOOKUP function do in Excel?*A. Searches for a value vertically down in a tableB. Records macrosC. Creates data tablesD. Protects workbook structure5. In VLOOKUP, what does the range_lookup parameter set to TRUE do?*A. Returns an exact matchB. Gives the closest match without going overC. Protects worksheet structureD. Records macros6. How can you email a workbook in MS Excel?*A. Choose Data » Email WorkbookB. Select Review Tab » EmailC. Choose File » Save and SendD. Use the Home Tab » Email7. What is the purpose of protecting a worksheet in Excel?*A. To create data tablesB. To prevent accidental deletion of critical dataC. To generate pivot chartsD. To edit macros8. How can you remove a password from a protected workbook in Excel?*A. Delete the existing password symbolsB. Use the Data TabC. Choose File » Info » Protect WorkbookD. Enter a new password9. What is a Data Table in Excel used for?*A. Recording macrosB. Creating pivot chartsC. Seeing different results by altering an input cellD. Protecting workbook structure10. How can you insert a Pivot Chart in Excel?*A. Choose Insert Tab » Pivot TableB. Use Data Tab » Pivot ChartC. Choose Review Tab » Pivot ChartD. Select Insert Tab » PivotTable dropdown » PivotChart

What is the purpose of a variable in VBA?*1 pointTo create a loopTo define a functionTo store dataTo format cells

What is macro in programming language? Write an algorithmfor macro definition

What is a user-defined function in VBA?