Free Microsoft 77-882 Exam Dumps Questions & Answers

Kara Lang works as the Human Resources manager at ABC.com. She is using Microsoft Office Excel 2010 to create a workbook. The workbook will be used to record days taken off for vacations or illness.
The company contains departments named Sales, Marketing, Production and IT.
Kara often needs to enter the names of company employees when she creates workbooks. Kara wants to be able to use the Fill Handle function to ease the task of entering names in a workbook. She asks you for assistance in enabling the Fill Handle function.
How can you help Kara?

• A.You should advise Kara to create a workbook saved as a template for each department that contains the names of the employees.
• B.You should advise Kara to create a single workbook saved as a template with the names of the employees listed in separate rows for each department.
• C.You should advise Kara to create a single workbook saved as a template with the names of the employees listed in separate columns for each department.
• D.You should advise Kara to create a custom list for each department that contains the names of the employees.

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
The workbook will be used to track deployments of the company's product to customers. The workbook will be updated by members of the deployment team and by other users in the Sales department. You save the workbook and share it.
One month later, you modify the workbook by adding a formula to a cell in one of the worksheets. The formula pulls data from other worksheets in the workbook. The formula does not work as expected. You suspect that the some of the data in the workbook is invalid.
You select some cells and want to validate the data. You navigate to the Data tab but the Data Validation option is unavailable.
What do you need to do before you can configure data validation rules?

• A.You need to disable encryption on the workbook.
• B.You need to disable protection on the workbook.
• C.You need to disable the sharing.
• D.You need to inspect the workbook.

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?

• A.Use Insert > Text > Headers & Footers
• B.Use Page Layout > Page Setup > Background option to insert the picture
• C.Use Insert > Illustrations > Picture to insert the picture
• D.Use Page Layout > Page Setup > Print Titles

You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create company sales reports.
You are creating a sales report for the first quarter of the year. You type a title "First Quarter Sales Report" into cell A1. The title appears as shown below.

You want the title to appear in one line as shown below.

How can you make the title appear on one line?

• A.You should consider configuring the text alignment to use the Fill option.
• B.You should consider deselecting the Shrink to Fit option.
• C.You should consider deselecting the Wrap Text option.
• D.You should consider selecting the Merge Cells option.

You work as an Office Assistant for Media Perfect Inc. You are creating a report in a workbook in
Microsoft Excel 2010. You have to insert a Venn-diagram in a worksheet. Mark the option you
will choose to accomplish the task.

Correct Answer:

Explanation:
In order to accomplish the task, you will have to choose the SmartArt option. Through the
SmartArt option in Office 2010, you can insert complex graphics, such as a Venn-diagram in a
document. SmartArt is a group of easily editable and formatted diagrams provided in Microsoft
Excel. There are 115 preset SmartArt graphics layout templates, such as List, Process, Cycle,
Hierarchy, etc. SmartArt graphics can automatically change their colors, fonts, and effects to
match the document's theme. The SmartArt option appears under the Insert tab.

Each SmartArt graphic maps the text outline onto the graphic and automatically resizes the graphic
for best fit. A number of quick styles can be used for each graphic shapes. Users can also manually
change SmartArt graphics colors, fonts, and effects to match the document's theme. Reference:
Microsoft Excel Help, Contents: "Learn more about SmartArt graphics"