77-888 Exam Training Practice Tests (Microsoft Excel 2010 Expert)]

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 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 anywhere in the PivotTable report for which you want to create a slicer. B. 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. C. Hold down CTRL, and then click the items on which you want to filter. D. Click Insert Slicer in the Sort & Filter group on the Options tab. E. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which
you
want to create a slicer.

Correct Answer: A,C,D,E

Question 2

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to accomplish the task with least administrative burden?

A. Choose one of the pre-built themes. B. Create a new workbook through a template.Copy all data and charts of the report to the new workbook. C. Use the SmartArt option. D. Select all the text of the document.
Change font style to Verdana and font color to light gray. Use vibrant colors for charts.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

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

Correct Answer: A,C,D,E

Question 4

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 the accounting template. B. He will configure form controls. C. He will create a PivotTable report. D. He will use stand-alone slicers.

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

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 included various subtotals in a worksheet in the report to verify data accuracy. You want to remove all subtotals from the sheet before you send it to your manager.
Which of the following steps will you take to accomplish the task with the least administrative effort?

A. Hide the rows containing subtotals. B. Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the Data tab. Click the Remove All button. C. Select all the subtotals.From the shortcut menu, click the Remove All Subtotals option. D. Delete all the rows containing subtotals.

Correct Answer: B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2010.
Your workbook includes several worksheets as shown in the image given below:
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will you take to accomplish the task?

A. Select the sheets containing charts.
Select the Effects option in the Themes group on the Page Layout page. B. Select the sheets containing charts.
Select the Colors option in the Themes group on the Page Layout page. C. Select the sheets containing charts.
Right-click on the sheet tabs.
Choose the Sheet Color option from the shortcut menu. D. Select the sheets containing charts.
Right-click on the sheet tabs.
Choose the Tab Color option from the shortcut menu.

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

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.

Correct Answer:

Microsoft Excel 2010 Expert - 77-888 Exam Practice Test