A Microsoft certification rewards the ambitious, and the Microsoft Excel 2010 exam is the gate they pass through. The 90 practice questions at PracticeVCE treat your pass as our business, not just your purchase.
Microsoft 77-882 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Office Excel 2010 Expert |
| Exam Number: | 77-882 |
| Related Certifications: | Microsoft Office Specialist Excel 2010 Core (77-882 is Expert track; Core is 77-882? / 77-882 Expert is paired with Excel 2010 Core 77-882 is expert part 1 depending on region naming) |
| Exam Price: | USD 100-150 (varies by region) |
| Certificate Validity Period: | No expiration (MOS 2010 certifications do not expire) |
| Available Languages: | French, Japanese, German, English, Spanish |
| Real Exam Qty: | 40-50 performance-based tasks (varies) |
| Exam Duration: | 50 minutes |
| Passing Score: | 700 (on 1000 scale) |
| Exam Format: | Live Microsoft Excel 2010 environment simulation, Performance-based tasks |
| Recommended Training: | Microsoft Learn - Excel training MOS Official Study Guide (Excel 2010 Expert) |
| Exam Registration: | Microsoft Certification Dashboard Pearson VUE Microsoft Exams |
| Sample Questions: | DOWNLOAD DEMO |
| Exam Way: | Proctored exam delivered via authorized testing centers (Pearson VUE) or online proctoring (availability varies by region) |
| Pre Condition: | Recommended: Microsoft Office Specialist Excel 2010 Core certification or equivalent experience with Excel 2010 |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-expert-2010/ |
Microsoft 77-882 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Apply custom formats and layouts | - Apply advanced formatting
|
| Topic 2: Create advanced formulas | - Analyze data with formulas
|
| Topic 3: Manage and present data | - Import and export data
|
| Topic 4: Manage workbook options and settings | - Customize workbook environment
|
Microsoft 77-882 Exam: Read Before You Buy
Microsoft Excel 2010 is an official Microsoft exam, catalogued under exam code 77-882. Passing it awards the Microsoft Office Specialist (MOS) Excel 2010 Expert certification at the Professional level. It also connects with Microsoft Office Specialist Excel 2010 Core (77-882 is Expert track; Core is 77-882? / 77-882 Expert is paired with Excel 2010 Core 77-882 is expert part 1 depending on region naming). It is built for candidates with ambitious aims, and the credential it grants is recognized accordingly.
Microsoft Excel 2010 spans 4 official domains, led by Manage workbook options and settings, Manage and present data, and Apply custom formats and layouts. The complete outline sits above; before getting down to business, look through the whole contents quickly so every later practice session has context.
The Microsoft Excel 2010 exam presents 40-50 performance-based tasks (varies) questions within 50 minutes. A practical tip from successful candidates: mark the most difficult questions during practice, exchange notes on them with friends, and repeat them until they stop being difficult. The PracticeVCE engine makes that loop fast, and the clock stops being a threat.
Passing Microsoft Excel 2010 requires 700 (on 1000 scale), and official registration costs USD 100-150 (varies by region). Retakes bill the full USD 100-150 (varies by region) again, so verify readiness before booking: when your PracticeVCE practice scores clear the requirement repeatedly, including on questions you once marked as difficult, you are ready.
Recommended: Microsoft Office Specialist Excel 2010 Core certification or equivalent experience with Excel 2010
Requirements change from time to time, so confirm the current conditions before registering on the official exam page.
Microsoft Excel 2010 registration is handled through the official channels below.
When you schedule, note that the exam is delivered Proctored exam delivered via authorized testing centers (Pearson VUE) or online proctoring (availability varies by region).
Microsoft recommends the following training for Microsoft Excel 2010 candidates.
Combine any training with the 90 practice questions in the PracticeVCE 77-882 package; one or two focused days of repeated practice after a course is often what locks the knowledge in.
Yes, a free demo of the Microsoft Excel 2010 questions is available before purchase. Afterward, you can track freshness by the updating version number on the website, and whenever questions change we instantly email the details to you, free for 365 days. We even keep sending the latest questions after you pass, so you can follow every tiny change. After expiry, extending updates costs 50% of the regular price.
Your purchase carries a 100% money-back guarantee under clear conditions. Take the Microsoft Excel 2010 exam within 60 days of purchase; if you fail, you may claim a full refund, provided the exam matches your product. Attempts within 3 days of purchase are ineligible, as are downloaded-but-unused products, free materials, and expired orders; the candidate name must match the payer name. Submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and claims are processed within 7 days. Alternatively, exchange for two other exam products of equal value, free, keeping the update service on your original purchase.
Delivery is instant: download after ordering, with an automatic email arriving within one minute. If nothing arrives within 2 hours, do not forget to check your junk mailbox, then contact customer service. Installation is unlimited across your computers.
Microsoft Excel 2010 Sample Questions:
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to edit a Sales report.
The workbook contains twelve worksheets named January through December. Each worksheet contains a sales table listing the names of the Sales staff and the values of their sales for that month. The format and layout of the table is identical on each worksheet.
You add another worksheet named Totals and Analysis to the Sales report workbook. You want to create formulas in the Totals and Analysis worksheet that use references to sales values from the tables on the other worksheets.
What type of cell reference is used to refer to the same cells on multiple worksheets within a workbook?
- A. A Tiered Cell Reference.
- B. A 3-D Cell Reference.
- C. A Multi-Cell Reference.
- D. A Relative Cell Reference.
Correct Answer: B 🗳️
Kara Lang works as the Human Resources manager at ABC.com. She is using Microsoft Office Excel 2010 to create a workbook. The workbook will be used to record days taken off for vacations or illness.
The company contains departments named Sales, Marketing, Production and IT.
Kara often needs to enter the names of company employees when she creates workbooks. Kara wants to be able to use the Fill Handle function to ease the task of entering names in a workbook. She asks you for assistance in enabling the Fill Handle function.
How can you help Kara?
- A. You should advise Kara to create a single workbook saved as a template with the names of the employees listed in separate rows for each department.
- B. You should advise Kara to create a custom list for each department that contains the names of the employees.
- C. You should advise Kara to create a single workbook saved as a template with the names of the employees listed in separate columns for each department.
- D. You should advise Kara to create a workbook saved as a template for each department that contains the names of the employees.
Correct Answer: B 🗳️
You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
The first worksheet in the financial report contains sales figures for each Sales person for the first quarter of the year. The second worksheet contains sales figures for each Sales person for the second quarter of the year. The third worksheet contains formulas that pull data from the sales figures on the first and second worksheets.
You want to view all three worksheets simultaneously so you can see how the totals on the third worksheet are affected by changes to the figures in the first two worksheets. You currently have the workbook open in Excel.
Which combination of the following steps would enable you to view all three worksheets side-byside? Choose two.
- A. Open two more copies of Excel 2010 and open two more copies of the workbook.
- B. Use the File tab > Open function to open two more copies of the workbook.
- C. Navigate to the View tab and use the New Window function to open two more copies of the workbook.
- D. Use the Save As function to save two more copies of the workbook with different names.
- E. Use the Arrange All > Arrange Vertical function to display all three copies of the workbook side-by-side.
- F. Resize the Excel windows to display all three copies of the workbook side-by-side.
Correct Answer: C,E 🗳️
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. Use the Select All Sheets function. Click one of the sheets and enter the value into cell B2.
- C. Configure a 3-D Cell Reference then enter the value into cell B2 on the first sheet.
- D. Enter the value into cell B2 on the first sheet then use Copy and Paste to paste the value into the other sheets.
Correct Answer: A 🗳️
You work as the Financial Controller at ABC.com. You are using Microsoft Office Excel 2010 to edit multiple workbooks. You have workbooks open from different shared folders on the network. Some of the workbooks have the same name.
To avoid any confusion over which workbook you are currently working on, you want to display the full path and file name of the workbook in the workbook.
Which combination of the following actions would configure the workbook to display the filename and path in a worksheet cell? Choose all that apply.
- A. On the Design tab, select the File Name option.
- B. Select a cell in the workbook.
- C. Insert the formula =filename("A1").
- D. Insert the formula =cell("filename").
- E. Navigate to the Insert tab and select the Header and Footer option.
- F. Select the Footer section.
- G. Select the Header section.
Correct Answer: B,D 🗳️
Viewing page 1 out of 18 pages.
Viewing questions 1-5 out of 90 questions.

935 Customer Reviews
