Microsoft MCSA 77-882

Certification exams change, and Getcertkey keeps pace: the 77-882 practice question set is reviewed continuously and updated free of charge for 365 days. Your Microsoft Excel 2010 preparation stays aligned with the current exam throughout 2026 and beyond.

Microsoft 77-882 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Microsoft Office Specialist (MOS): Excel 2010
Exam Number:	77-882
Related Certifications:	77-887: Excel 2010 Expert 77-885: Access 2010 77-887: Word 2010 Expert 77-884: Outlook 2010 77-881: Word 2010 77-883: PowerPoint 2010
Exam Duration:	90 minutes
Available Languages:	French, Korean, Arabic (Saudi Arabia), Chinese (Simplified), German, Dutch, Chinese (Traditional), English, Spanish, Japanese, Russian, Vietnamese
Exam Format:	Multiple choice, Performance-based tasks
Sample Questions:
Exam Way:	Proctored at an authorized testing center
Pre Condition:	No prerequisites
Official Syllabus URL:	https://www.certiport.com/portal/desktopdefault.aspx?page=common/pagelibrary/mos2010.html

Microsoft 77-882 Exam Syllabus Topics:

Common Questions About the Microsoft 77-882 Exam

What is the Microsoft Excel 2010 exam all about?

The 77-882 exam is the official Microsoft exam behind the MCSA certification, validating the skills measured by the Microsoft Excel 2010 credential. It sits at the Core level of the Microsoft certification program. It also connects to 77-881: Word 2010, 77-883: PowerPoint 2010, 77-884: Outlook 2010, 77-885: Access 2010, 77-887: Word 2010 Expert, 77-887: Excel 2010 Expert, so the knowledge you build here carries over to those tracks as well.

Are there any prerequisites for the 77-882 exam?

No prerequisites Requirements can change when Microsoft revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

Can I try the 77-882 practice questions before I buy?

Yes. Getcertkey provides a free 77-882 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Microsoft revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the 77-882 exam, and how is my order delivered?

Every Microsoft Excel 2010 purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the 77-882 exam?

The Microsoft Excel 2010 exam blueprint is organized into 8 domains. The first three are:

• Applying Formulas and Functions
• Presenting Data Visually
• Managing the Worksheet Environment

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

Microsoft Excel 2010 Sample Questions:

Question 1

You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating sales
reports for the Sales department. You use Microsoft Excel 2010 to create these reports. You have
created an yearly sales report. The fragment of the report is shown below:

As the report is quite wide, printing this report involves three A4 size pages. You want the first
column (column A) to repeat in every printed page. Mark the option that you will choose to
accomplish the task.

Question 2

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 deselecting the Show Formulas option on the Formulas tab.
C. You should consider clicking the Evaluate Formula option on the Formulas tab.
D. You should consider changing the format of the cell.

Question 3

Which of the following features of Office 2010 houses options to configure options that affect the
document as a whole or the application itself?

A. Backstage View
B. Ribbons
C. Office Button
D. Tabs

Question 4

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?

A. You should consider selecting Protect and Share Workbook.
B. You should consider adding a digital signature to the document.
C. You should consider marking the document as final.
D. You should consider selecting the Restrict Permission option.
E. You should consider encrypting the document.

Question 5

You work as a Sales Manager for Peach Tree Inc. Your responsibility includes creating sales
reports of the company. You create a report in a workbook in Excel 2010. The report contains a
worksheet that has been formatted by using the conditional formatting feature. You have specified
five conditions for conditional formatting of a list appearing in the sheet. You save the report and
send it to your manager. He informs you that the sheet on which conditional formatting feature is
applied is not appearing according to his requirement. He further specifies that only a few of the
conditions are applying. What is the most likely cause?

A. Some of the conditions are cross referencing in the specified conditional format conditions.
B. You have not saved the Excel workbook in .xlsm format.
C. The manager is using Excel 2003 or earlier version of Excel.
D. Specified rules are conflicting.

Solutions: