Microsoft Excel 2010 - 77-882 Exam Questions

QUESTION NO: 1
You work as the Sales Assistant at ABC.com. The Sales Manager has sent you a workbook containing a sales report and asked you to edit it. You open the sales report using Microsoft Office Excel 2010.
You are currently using the default Normal view to view the workbook. You have seen a printed version of the sales report. The printed version has a page header that contains the title of the sales report. However, you cannot see the header when viewing the workbook in normal view.
Which Excel view would display the header and footer placeholders while allowing you to edit the cells in the worksheet?

QUESTION NO: 2
You work as the Sales Manager at ABC.com. Sally works as an Office Assistant in the Sales Office.
You have asked Sally to create a sales report on the sales targets for the previous quarter. Sally uses Microsoft Office Excel 2010 to create the report. Sally uses multiple conditional formatting rules to change the styles of the cells according to certain conditions.
Sally completes the report and emails it to you. However, when you open the report, it does not look how it should according to your instructions. You note that only a few of the required conditional formatting rules are applying.
Which of the following actions should you take?

QUESTION NO: 3
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?

QUESTION NO: 4
You are creating a business report by using Microsoft Excel 2010. You have arranged sales data as
shown below:

You want to provide pictorial representation of the trend of these sales data in front of each row.
Which of the following steps will you choose to accomplish the task involving the least amount of
administrative burden?

QUESTION NO: 5
You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create company sales reports.
You have finished creating a monthly company performance report. You will send the document to the company Managing Director when you have finished it.
The Managing Director will need to ensure that the document he receives is the original document that you created. How can you ensure the integrity of the document?

QUESTION NO: 6
You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You
have inserted the following formula in a cell: VLOOKUP(12, A2:C10, 3, FALSE ) Which of the
following actions will be performed by the formula?

QUESTION NO: 7
You work as an office assistant for Brain Brigade Inc. You are creating an excel sheet. You use the
fill handle quite often to fill or copy series of values to cells. Every time you use the fill handle, the
Auto Fill button appears.

You do not want to display the Auto Fill button. You open the Excel Options window. Mark the
check box that you will clear to accomplish the task.

QUESTION NO: 8
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option
that he will choose to accomplish the task.

QUESTION NO: 9
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?