Microsoft 77-882 valid exam dumps : Excel 2010

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.

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a Sales Report.
The sales report contains a table that lists the sales figures for each month for each of the Sales Account Managers. A column in the table uses the SUM() function to provide a value for the total annual sales for each of the Sales Account Managers.
The cell that contains the annual total sales for one of the Sales Account Managers displays the formula as shown below whereas the totals for all the other Sales Account Managers are displayed as values.

How can you display the formula as a value?

• A. You should consider removing the blank space in the cell before the formula.
• B. You should consider clicking the Evaluate Formula option on the Formulas tab.
• C. You should consider changing the format of the cell.
• D. You should consider deselecting the Show Formulas option on the Formulas tab.

You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create and edit workbooks.
Your workbook has multiple worksheets and each worksheet has many rows of information.
You want to make several formatting changes to every cell in the workbook. You need to ensure that every cell has the same formatting.
What is the easiest way to apply several formats to the cells throughout a workbook?

• A. You should consider selecting all cells and selecting the Format option on the Home tab.
• B. You should consider pressing Ctrl + A and configuring the required formatting options.
• C. You should consider using the Custom Views function on the View tab.
• D. You should consider using the Cell Styles function on the Home tab.

You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook.
The workbook has twelve worksheets. The worksheets are named January through December and have rows labeled according to each day of the month.
You want to enter a value in the cell B2 on each worksheet.
What is the easiest way to insert the same value into the same cell on all worksheets in a workbook?

• A. Use the Select All Sheets function and enter the value into cell B2 on the active sheet.
• B. Configure a 3-D Cell Reference then enter the value into cell B2 on the first sheet.
• C. Enter the value into cell B2 on the first sheet then use Copy and Paste to paste the value into the other sheets.
• D. Use the Select All Sheets function. Click one of the sheets and enter the value into cell B2.

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. Choose one of the pre-built themes.
• B. Use the SmartArt option.
• 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.