← Back to exam page

77-888 – Microsoft Excel 2010 Expert

Loading demo links...

Showing 1–3 of 10 questions

Question 1

HOTSPOT

You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2010. You want to insert flow-chart in the sheet. Mark the option that you will choose to insert flow- chart symbols in the report. In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple objects provided by Microsoft Office to add them to a document. A single shape or combined multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines, basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and call outs. Users can add text, bullets, numbering, and Quick Styles to these shapes after inserting them in the document. Take the following steps to add a shape in a document:

Hot Area:

Answer is in the explanation below.

Question 2

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.

Select all that apply, then click Submit answer.

  • ○

    History tracking
  • ○

    Onscreen highlighting
  • ○

    Slicer-enabled highlighting
  • ○

    Reviewing of changes
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 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.

Select all that apply, then click Submit answer.

  • ○

    In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.
  • ○

    Click Insert Slicer in the Sort & Filter group on the Options tab.
  • ○

    Hold down CTRL, and then click the items on which you want to filter.
  • ○

    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.
  • ○

    Click anywhere in the PivotTable report for which you want to create a slicer.