If your schedule is already packed, preparing for the 77-882 exam can feel like one commitment too many. TestSimulate keeps things manageable with 90 focused practice questions for Microsoft Excel 2010, so every study session in 2026 actually counts.

Microsoft 77-882 Exam Overview:

Microsoft 77-882 Exam Syllabus Topics:

77-882 Exam FAQ: What to Know Before You Book

Microsoft Excel 2010 Sample Questions:

Question 1

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.

Question 2

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?

A. Wrong syntax used.
B. Search the value 3 in the last column of the range, and then returns the value that is in the
column of the range and on the same row as the lookup value.
C. Search the value 12 in the third column of the range and then returns the value that is contained
in the 12th column of the range and on the same column as the lookup value.
D. Search for the value 12 in the first column of the range, and then returns the value that is
contained in the third column of the range and on the same row as the lookup value.

Question 3

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 deselecting the Shrink to Fit option.
B. You should consider deselecting the Wrap Text option.
C. You should consider configuring the text alignment to use the Fill option.
D. You should consider selecting the Merge Cells option.

Question 4

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 the sharing.
B. You need to disable protection on the workbook.
C. You need to inspect the workbook.
D. You need to disable encryption on the workbook.

Question 5

You work as an Office Assistant for Tech Perfect Inc. You create a worksheet in Excel 2010 that
contains various tables, headings, charts, and SmartArt objects. In order to give it a professional
look, you choose Office theme as shown below:

You like the appearance of the sheet in this theme; however, you want to use the Lucida
Calligraphy font for heading and Arial font for the body text. You often use this font combination
for formatting office sheets. You are required to accomplish the following tasks: Use the font
combination in your current document. Enable Excel to provide this combination in other office
documents too. Choose the required steps to accomplish the tasks.

Solutions: