← Back to exam page

77-882 – Excel 2010

Loading demo links...

Showing 4–5 of 5 questions

Question 4

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?

Select an option, then click Submit answer.

  • ○

    Hide the rows containing subtotals.

  • ○

    Select all the subtotals. From the shortcut menu, click the Remove All Subtotals option.

  • ○

    Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the Data tab. Click the Remove All button.

  • ○

    Delete all the rows containing subtotals.

Question 5

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?

Select an option, then click Submit answer.

  • ○

    Select the sheets containing charts.
    Select the Effects option in the Themes group on the Page Layout page.

  • ○

    Select the sheets containing charts.
    Select the Colors option in the Themes group on the Page Layout page.

  • ○

    Select the sheets containing charts.
    Right-click on the sheet tabs.
    Choose the Tab Color option from the shortcut menu.

  • ○

    Select the sheets containing charts.
    Right-click on the sheet tabs.
    Choose the Sheet Color option from the shortcut menu.