Microsoft MOS 77-888

From your first practice question to exam day, Getcertkey covers the entire 77-888 journey: a free demo, 62 practice questions in three formats, a full year of free updates, and a clear refund policy. Preparing for the Microsoft Excel 2010 Expert exam has rarely been this straightforward.

Microsoft 77-888 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Excel 2010 Expert
Exam Number:	77-888
Certificate Validity Period:	Lifetime (retired exam, no renewal required)
Exam Price:	$100 USD
Exam Format:	Live software simulation, Performance-based tasks, Hands-on lab
Available Languages:	French, Italian, German, Brazilian Portuguese, Traditional Chinese, Spanish, Dutch, English, Japanese, Simplified Chinese, Arabic, Korean
Related Certifications:	Microsoft Office Specialist (MOS) 2010 77-882 Excel 2010
Real Exam Qty:	25-30 performance-based tasks
Exam Duration:	50 minutes
Passing Score:	700 (on a scale of 1-1000)
Recommended Training:	Microsoft Official Courseware MOS Expert Study Guides
Exam Registration:	Microsoft Learn Exam Page Certiport (MOS Exam Provider)
Sample Questions:
Exam Way:	Proctored onsite at authorized test centers; online proctoring not available for this retired exam
Pre Condition:	No formal prerequisites; recommended to hold MOS Excel 2010 (77-882) or equivalent experience
Official Syllabus URL:	https://learn.microsoft.com/en-us/credentials/certifications/exams/77-888/

Microsoft 77-888 Exam Syllabus Topics:

77-888 Exam FAQs for 2026 Candidates

Which certification does the 77-888 exam lead to?

The 77-888 exam is the official Microsoft exam behind the Microsoft Office Specialist (MOS) Expert certification, validating the skills measured by the Microsoft Excel 2010 Expert credential. It sits at the Expert level of the Microsoft certification program. It also connects to Microsoft Office Specialist (MOS) 2010, 77-882 Excel 2010, so the knowledge you build here carries over to those tracks as well.

How many questions are on the 77-888 exam, and how much time do I get?

The 77-888 exam contains 25-30 performance-based tasks questions to be completed within 50 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the 77-888 exam, and what does it cost?

The passing score for the 77-888 exam is 700 (on a scale of 1-1000), and the official registration fee is $100 USD. Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 62 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the 77-888 exam?

No formal prerequisites; recommended to hold MOS Excel 2010 (77-882) or equivalent experience Requirements can change when Microsoft revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

How do I register for the 77-888 exam?

You can book the Microsoft Excel 2010 Expert exam through the official registration channels below:

• Microsoft Learn Exam Page
• Certiport (MOS Exam Provider)

As for delivery, the exam is offered in the following format: Proctored onsite at authorized test centers; online proctoring not available for this retired exam. Choose the option that suits you best when you book your seat.

What official training is recommended for the 77-888 exam?

Microsoft recommends the following training resources for the Microsoft Excel 2010 Expert exam:

• Microsoft Official Courseware
• MOS Expert Study Guides

Official courses build the foundation; the 62 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.

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

Yes. Getcertkey provides a free 77-888 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-888 exam, and how is my order delivered?

Every Microsoft Excel 2010 Expert 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-888 exam?

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

• Sharing and Maintaining Workbooks — 20% of the exam
• Working with Macros and Forms — 25% of the exam
• Presenting Data Visually — 25% of the exam

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 Expert Sample Questions:

Question #1
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2010. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

A. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
B. Click a cell in the cell range that contains data for using worksheet data as the data source.
C. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.
D. Choose Select a table or range under Choose the data that you want to analyze.
E. Click OK.

Question #2
HOTSPOT
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 #3
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are using a slicer. After filtering the data, you want to delete the slicer. Which of the following steps can you take to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

A. Click the Macro setting, and then delete the slicer from the Macro-enabled slicers list.
B. Click the slicer, and then press Delete.
C. Click the slicer that you want to delete on the Options tab in the Slicer type group.
D. Right-click the slicer, and then click Remove <Name of slicer>.

Question #4
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2010. You have a number of PivotTables in a single report. You want to apply the same filter to all of those PivotTables. For this purpose, you are required to create a slicer in one PivotTable and share it with other PivotTables. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

A. Click anywhere in the PivotTable report for which you want to create a slicer.
B. Click Insert Slicer in the Sort & Filter group on the Options tab.
C. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which
you
want to create a slicer.
D. Hold down CTRL, and then click the items on which you want to filter.
E. Select the Macro enabled checkbox of the PivotTable fields for which you want to create a slicer in the Insert Security dialog box and then click OK.

Question #5
You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You want to find out the matching values in the columns. While doing so, you get an unexpected error that when you attempt to look up or match a lookup_value within an array; Excel is not able to recognize the matching value. You want to store sets of values as text and convert sets of data to text by using Excel's Text To Columns tool. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

A. Select the Text to Columns option from the Data tab at the top of the Excel workbook.
B. Select the cells to convert their data to text.
C. Make sure that all delimiter options are unselected, and then again click Next.
D. Remove the unseen spaces at the start or end of the first Macro cell.
E. SelectText and click the Finish button in Column Data Formats.
F. Select theDelimited option and click Next

Solutions: