The advantage of using macro is Options :Duplicate work has to be doneDuplicate work is avoidedDaily systematic report is easy to be dispensedBoth 2 and 3

What is the primary benefit of using macros in spreadsheets?Options :They improve the visual appeal of the worksheetThey automate repetitive tasksEase of useAll of above

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

Why is a macro used in place of a function? It increases code size. It increases execution time. It reduces execution time. It reduces code size.

Ch9-Q1 You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together.What characteristics should worksheets have and what advantages do they have?Multiple answers:Multiple answers are accepted for this questionSelect one or more answers and submit. For keyboard navigation...SHOW MOREaThat the different worksheets have identical data structure.bAny changes you make on one worksheet are made in all the other worksheets in the group in the exact same location on the worksheets.cWorksheets need to belong to different Workbooks.dTo be able to group them Links must be established with one another.

n the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:Why is being able to make use of  multiple analysis tools useful for some projects?How is working with data in spreadsheets and with SQL different? How are they similar?