You work as an Office Assistant for Blue well Inc. You want to record a macro and save it with the name "Auto_Open" so that the macro will run whenever you open the workbook containing the macro.
While doing so, you observe that the Auto_Open macro fails every time. Which of the following are the causes of this?
Each correct answer represents a complete solution. Choose all that apply.

• A. The workbook is based on the record button that is disabled by default before running the Auto_Open macro.
• B. The workbook where a user wants to save the Auto_Open macro already contains a VBAprocedure in its Open event.
• C. The workbook is opened programmatically using the Open method.
• D. The default workbook or a workbook loaded from the XLStart folder is opened before running the macro.

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have two budget situations in which one is the worst case and the other is the best case. You want to create both situations on the same worksheet and then switch between them with the change in requirements. Which of the following will you use to accomplish the task?

• A. Scenario
• B. Solver add-in
• C. Goal Seek
• D. Data table

Which of the following steps will you take to merge copies of a shared workbook? Each correct
answer represents a part of the solution. Choose all that apply.

• A. In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook containing changes to be merged, and then click OK.
• B. Open the copy of the shared workbook to merge the changes.
• C. Click Compare and Merge Workbooks on Macro Enabled Access Toolbar.
• D. Add Compare and Merge Workbooks.
• E. Click Compare and Merge Workbooks on Quick Access Toolbar.
• F. Save the workbook if prompted.

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2013. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A. Choose Select a table or range under Choose the data that you want to analyze.
• B. Click a cell in the cell range that contains data for using worksheet data as the data source.
• C. Click OK.
• D. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
• E. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

• A. Create a slicer connected with the PivotTable.
• B. Use an existing slicer connected with another PivotTable.
• C. Create a slicer by disabling Macros associated with the PivotTable.
• D. Create a copy of a slicer connected with the PivotTable.