PDF Version DemoSecond-attempt candidates are the most honest judges of study material, and they keep choosing ActualPDF. The Microsoft Excel 2010 package offers 90 verified 77-882 practice questions for people who want the next attempt to be the last.
Microsoft 77-882 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Office Specialist (MOS): Excel 2010 |
| Exam Number: | 77-882 |
| Related Certifications: | 77-885: Access 2010 77-881: Word 2010 77-887: Word 2010 Expert 77-887: Excel 2010 Expert 77-883: PowerPoint 2010 77-884: Outlook 2010 |
| Exam Format: | Performance-based tasks, Multiple choice |
| Available Languages: | Vietnamese, French, German, Chinese (Simplified), Russian, Dutch, Spanish, Japanese, English, Chinese (Traditional), Korean, Arabic (Saudi Arabia) |
| Exam Duration: | 90 minutes |
| 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:
| Section | Objectives |
|---|---|
| Topic 1: Managing Worksheets and Workbooks | -
|
| Topic 2: Creating Cell Data | -
|
| Topic 3: Formatting Cells and Worksheets | -
|
| Topic 4: Sharing Worksheet Data | -
|
| Topic 5: Applying Formulas and Functions | -
|
| Topic 6: Analyzing and Organizing Data | -
|
| Topic 7: Presenting Data Visually | -
|
| Topic 8: Managing the Worksheet Environment | -
|
Microsoft 77-882 Exam: FAQ for Serious Candidates
Microsoft Excel 2010 is an official Microsoft exam, listed under exam code 77-882. A passing result earns you the MCSA certification at the Core level. It also ties into 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, extending its value across your certification roadmap. Employers read this credential as verified competence, which is why it keeps appearing in job requirements.
No prerequisites
Requirements evolve, so confirm the current conditions before registering on the official exam page.
Yes. ActualPDF provides a free download demo of the Microsoft Excel 2010 material, so you can check the content before choosing a version. After purchase, a one-year warranty covers you: the latest version is sent to you as it releases, free for 365 days, and after expiry you can extend the update service at a 50% discount.
Your purchase is covered by a 100% money-back guarantee with clear conditions. Take the Microsoft Excel 2010 exam within 60 days of purchase; if you fail, provide your unqualified result by submitting a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the full refund is processed within 7 days. The exam must match your product, candidate and payer names must match, and attempts within 3 days of purchase, unused downloads, free materials, and expired orders are not covered. Alternatively, exchange for two other exam products of equal value, free, or wait for updates while keeping your original product's update service.
Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, which works 7/24 and normally replies within two hours. Installation is unlimited across your computers.
The Microsoft Excel 2010 syllabus spans 8 domains, led by Creating Cell Data, Managing Worksheets and Workbooks, and Analyzing and Organizing Data. The complete topic list is published above; candidates who study the map first rarely get lost later.
Microsoft Excel 2010 Sample Questions:
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. 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. - B. 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. - C. Wrong syntax used.
- D. 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.
Explanation: Only visible for ActualPDF members. You can sign-up / login (it's free).
Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You have a formula in a spreadsheet that reads data from an external source and performs a calculation to calculate current Sales figures. You want to include a function in the spreadsheet to display the current time whenever the spreadsheet is opened or when the spreadsheet is calculated.
Which Excel function should you make use of in your spreadsheet?
- A. You should make use of the NOW() function.
- B. You should make use of the TIMEVALUE() function.
- C. You should make use of the TIME() function.
- D. You should make use of the DATEVALUE() function.
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 configuring the text alignment to use the Fill option.
- C. You should consider selecting the Merge Cells option.
- D. You should consider deselecting the Wrap Text option.
You work as an Office Assistant for Blue Well Inc. You are creating a report in a worksheet in
Excel. You have prepared a table as shown below:
You want to increase the height of each row in such a manner that all rows have the same height.
Which of the following steps will you take to accomplish the task easily?
- A. Select all rows in the table. Click the Format option in the Cells group on the Home tab. Click
Row Height. In the Row Height dialog box, provide the required value. - B. Select all rows in the table. Drag the border of one of the selected rows to the required height.
- C. Select individual rows. Drag the border of rows to the required height.
- D. Select all rows in the table. Right-click on the selected rows and click the Row Height option. In
the Row Height dialog box, provide the required value.
Explanation: Only visible for ActualPDF members. You can sign-up / login (it's free).
You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook. The workbook was created by the Sales Manager who has asked you to fill in the sales figures in the table.
When you click in one of the cells, you see a message as shown below.
What function did the Sales Manager use to configure the alert message?
- A. The Data Validation function.
- B. The Protect Workbook function.
- C. The Allow Users to Edit Ranges function.
- D. The Share Workbook function.
