77-427 Online Practice Questions and Answers

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network.

Rick is creating a project through Microsoft Excel 2013. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the following will Rick use to accomplish the task?

A. Gantt Chart Template

B. Form control

C. Trust Center

D. Accounting template

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 default workbook or a workbook loaded from the XLStart folder is opened before running the macro.

B. The workbook is opened programmatically using the Open method.

C. The workbook where a user wants to save the Auto_Open macro already contains a VBAprocedure in its Open event.

D. The workbook is based on the record button that is disabled by default before running the Auto_Open macro.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to 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 using a slicer. After filtering the data, you want to delete the slicer. Which of the following steps can you take to accomplish the task?

Each correct answer represents a complete solution. Choose all that apply.

A. Click the slicer that you want to delete on the Options tab in the Slicer type group.

B. Click the Macro setting, and then delete the slicer from the Macro-enabled slicers list.

C. Click the slicer, and then press Delete.

D. Right-click the slicer, and then click Remove .

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell:

VLOOKUP(12, A2:C10, 3, FALSE )

Which of the following actions will be performed by the formula?

A. Search for the value 12 in the first column of the range, and then returns the value that is contained in the third column of the range and on the same row as the lookup value.

B. Wrong syntax used.

C. Search the value 3 in the last column of the range, and then returns the value that is in the column of the range and on the same row as the lookup value.

D. Search the value 12 in the third column of the range and then returns the value that is contained in the 12th column of the range and on the same column as the lookup value.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to get the trend of the Business data range. For this purpose, you want to use trendlines in the chart. Which of the following steps will you take to apply the trendlines in the chart?

Each correct answer represents a part of the solution. Choose all that apply.

A. Clear the check box of any Trendline fields to disconnect a slicer.

B. Select the type that you want from Trendline options.

C. Click the Insert Trendline arrow, and then click Trendline Connections on the Options tab in the Sort and Filter group.

D. Select a chart and then navigate to the Chart Tools Layout tab.

You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in the report. She wants to know the effects on the cell when the values in different sheets change. She requests that you help her out to accomplish the task. Which of the following steps would you suggest she take in order to accomplish the task?

A. Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Vertical option.

B. Select the cell which is to be monitored. On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

C. Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Cascade option.

D. Select the cell which is to be monitored. On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step of adding the following lines of code to the procedure:

"Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub"

Which of the following are the next steps that you will take to accomplish the task?

Each correct answer represents a part of the solution. Choose all that apply.

A. Under Macro Settings in the Macro Settings category, click Enable all macros, and then click OK.

B. Switch to Excel and save the workbook with the .xslm extension as a macro-enabled workbook and close it.

C. Reopen the workbook.

D. Click OK in the message box.

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. Click OK.

B. Choose Select a table or range under Choose the data that you want to analyze.

C. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.

D. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.

E. Click a cell in the cell range that contains data for using worksheet data as the data source.

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel

2013. Rick wants to trace the project with the actual requirements. For this purpose, he is required to compare month to month, actual v budget, quarter to quarter, year to year variances.

Which of the following will Rick use to accomplish the task?

A. Evaluate Formula

B. Accounting template

C. Form control

D. Trust Center

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet. Which of the following options will you use to accomplish the task?

A. Mark as Final

B. Encrypt with Password

C. Protect Current Sheet

D. Protect Workbook Structure