Free Microsoft 77-882 Exam Dumps Questions & Answers

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

You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
The columns in a table in the worksheet are set to the default width. This causes some of the text in some cells to not be displayed. You want to increase the column width so that the text in the cells is displayed. You also want to ensure that all columns in the table are the same width.
Which combination of the following actions is the easiest way to accomplish the task? Choose two.

• A.  Drag the border of one of the selected columns to the required width.
• B.  On the Home tab, select Format then Column Width and enter the required width.
• C.  Select all the required columns.
• D.  Select individual columns.
• E.  Select all the cells in the table.
• F.  On the Home tab, select Format then Format Cells.

You work as the Financial Controller at ABC.com. You are using Microsoft Office Excel 2010 to edit multiple workbooks. You have workbooks open from different shared folders on the network. Some of the workbooks have the same name.
To avoid any confusion over which workbook you are currently working on, you want to display the full path and file name of the workbook in the workbook.
Which combination of the following actions would configure the workbook to display the filename and path in a worksheet cell? Choose all that apply.

• A.  Select a cell in the workbook.
• B.  Insert the formula =cell("filename").
• C.  Insert the formula =filename("A1").
• D.  Navigate to the Insert tab and select the Header and Footer option.
• E.  On the Design tab, select the File Name option.
• F.  Select the Footer section.
• G.  Select the Header section.

Sarah works as an Office Assistant for Perfect Wear Inc. She has created a sales report in a
worksheet using Microsoft Excel 2010. She has inserted a chart to summarize data visually. She
wants to print a chart without printing the rest of the accompanying worksheet. Choose the
required steps that Sarah will take to accomplish the task. Select an item from the right pane. Click
button to move the selected item to the left pane. Click button to move the item back to the right
pane. Click and buttons to sort the list, if required.

Correct Answer:

Explanation:
In order to accomplish the task, Sarah will have to take the following steps:
Select the chart.
Click the File button and select the Print option. Click the Print button.
When a user first selects the chart and then gives the print command, Excel adds and selects the
Selected Chart option in Settings. This is the only option that is enabled.

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a sales summary that will be printed out and handed to senior management.
You want to ensure that you can print the sales summary in a single page without the need for scaling.
How can you configure Excel to display a worksheet as it would appear on a printed page while you are working on the spreadsheet?

• A.  You should consider using the Print Area function on the Page Layout tab.
• B.  You should consider using the Draft view.
• C.  You should consider using the Print Layout view.
• D.  You should consider using the Page Layout view.