Online Access Free 77-882 Practice Test
| Exam Code: | 77-882 |
| Exam Name: | Excel 2010 |
| Certification Provider: | Microsoft |
| Free Question Number: | 90 |
| Posted: | Oct 08, 2025 |
You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for
creating various types of reports. You have created a report in the format given below:
In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the
B7 cell. Which of the following formulas will provide the required result?
You work as an Office Assistant for Peach Tree Inc. You have created a report in a workbook
using Microsoft Excel 2010. The report includes a worksheet that contains sales data of the
company. You want to use complex criteria to filter the list. For testing, you have inserted criteria
rows in the sheet. The fragment of the worksheet is shown below:
The list range is defined as A9:D44. For testing, you want to filter the list for all the records of
Mark. You want to ensure that the filtered list does not provide duplicate rows. You also want to
display the filtered list at a new location at the G9 cell position. You open the Advanced Filter
dialog box by clicking the Advance option in the Sort & Filter group on the Data tab. Fill the
Advanced Filter dialog box options to fulfill your requirements.
You work as a Help Desk Technician for Tech Perfect Inc. Rick, a Sales Manager, uses Microsoft
Excel 2010 to prepare sales reports. He is creating a sales report in which he wants to compare the
relative magnitude of the targets achieved by his sales team members as shown in the image given
below:
He wants your help in formatting the table in the required way. Choose the required steps to
accomplish the task.
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?
