← Back to exam page

77-882 – Excel 2010

Loading demo links...

Showing 1–3 of 5 questions

Question 1

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?

Select an option, then click Submit answer.

  • ○

    Create a new workbook through a template. Copy all data and charts of the report to the new workbook.

  • ○

    Use the SmartArt option.

  • ○

    Choose one of the pre-built themes.

  • ○

    Select all the text of the document. Change font style to Verdana and font color to light gray. Use vibrant colors for charts.

Question 2

Martha works as an Office Executive for Tech Profile Inc. She uses Microsoft Excel 2010 to create office reports. She often needs to fill names of all employees in each department of the company in her reports. Which of the following steps should she take to ease her task?

Select an option, then click Submit answer.

  • ○

    Fill different columns with names of employees department-wise, in an Excel worksheet. Save the sheet as a template file.
    Use this template for creating reports.

  • ○

    Fill different columns with names of employees department-wise, in an Excel worksheet. Copy and paste the columns from the worksheet into a new sheet whenever required.

  • ○

    Create custom lists of employees department-wise in Excel.
    Use the Fill handle to fill the cell with the names of employees.

  • ○

    Fill different columns with names of employees department-wise, in an Excel worksheet. Save the sheet and use it as a template.

Question 3

Martha works as an Office Assistant for Tech Perfect Inc. She uses Microsoft Excel 2010 for working on a report. She wants to add a picture as a background in her Excel worksheet. She does not want that picture to be printed while printing.

Which of the following steps will she take to accomplish the task?

Select an option, then click Submit answer.

  • ○

    Use Insert > Illustrations > Picture to insert the picture

  • ○

    Use Insert > Text > Headers & Footers

  • ○

    Use Page Layout > Page Setup > Print Titles

  • ○

    Use Page Layout > Page Setup > Background option to insert the picture