Free Microsoft 77-888 Exam Dumps Questions & Answers

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick wants to display data series, categories, data markers, and axes in the report. Which of the
following actions will Rick take to accomplish the task?

• A.  He will create a PivotTable report.
• B.  He will create a PivotChart report.
• C.  He will use stand-alone slicers.
• D.  He will configure form controls.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-
based network.
Rick has to perform the following tasks:
Summarize large amounts of data. Analyze numeric data.
Answer unexpected questions about data.
Which of the following actions will Rick take to accomplish the task?

• A.  He will create a PivotTable report.
• B.  He will create the accounting template.
• C.  He will use stand-alone slicers.
• D.  He will configure form controls.

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You select the Encrypt with Password option as a protection measure for the document you are sharing. Now, you have to specify a password in the Password box in the Encrypt Document dialog box appeared for editing the document. But you have forgotten the password. What will happen in this situation?

• A.  You will use a new password.
• B.  You will ask Microsoft to retrieve the password.
• C.  You will fetch the password from the list in which you have saved it.
• D.  You will create a new document.

Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in the log. Plowing through all the records will be time taking. Which option can be used to view only the relevant records?

• A.  All filter
• B.  Autofilter
• C.  Sort
• D.  Find

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 disconnect the slicer. You have clicked anywhere in the PivotTable report. Which of the following steps will you take next to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.  Clear the check box of any PivotTable fields for which you want to disconnect a slicer.
• B.  Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
• C.  Click the slicer, and then press Delete.
• D.  Right-click the slicer, and then click Remove <Name of slicer>.