Different candidates prepare for 77-888 in different ways, so Actual4dump provides Microsoft Excel 2010 Expert material as a printable PDF, a Windows Desktop Test Engine, and a browser-based Online Test Engine. Each option gives you access to 62 practice questions in a format suited to your routine.

Microsoft 77-888 Exam Overview:

Microsoft 77-888 Exam Syllabus Topics:

Common Questions About Microsoft Excel 2010 Expert

Microsoft Excel 2010 Expert Sample Questions:

Question 1

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2010. 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. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.
B. Click OK.
C. Choose Select a table or range under Choose the data that you want to analyze.
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.

Question 2

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the
company's high selling products. You input a formula for calculating the monthly sell of a particular product but your Excel cell shows a string of # symbols instead of returning a value as
shown below: Which of the following are the reasons that are causing the above problem? Each correct answer

represents a complete solution. Choose all that apply.

A. Excel is trying to show the contents of the cell as a date or time stored as positive numeric values within Excel, but the cell contains a negative value.
B. The cell is not wide enough for displaying the calculated value.
C. The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
D. You are inserting a new column, next to a column that is already formatted as text.

Question 3

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

A. Slicer-enabled highlighting
B. Onscreen highlighting
C. History tracking
D. Reviewing of changes

Question 4

HOTSPOT
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2010 application on the network. You open the application and see various changes in Excel 2010. You have to open an existing worksheet through the application. You are unable to find the Office button.
Mark the option that you will click to accomplish the task.

Question 5

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2010. You have a number of PivotTables in a single report. You want to apply the same filter to all of those PivotTables. For this purpose, you are required to create a slicer in one PivotTable and share it with other PivotTables. 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 Insert Slicer in the Sort & Filter group on the Options tab.
B. Click anywhere in the PivotTable report for which you want to create a slicer.
C. Select the Macro enabled checkbox of the PivotTable fields for which you want to create a slicer in the Insert Security dialog box and then click OK.
D. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which
you
want to create a slicer.
E. Hold down CTRL, and then click the items on which you want to filter.

Solutions: