Free Microsoft 77-888 Exam Dumps Questions & Answers
| Exam Code/Number: | 77-888Join the discussion |
| Exam Name: | Excel 2010 Expert |
| Certification: | Microsoft |
| Free Question Number: | 62 |
| Publish Date: | Nov 14, 2026 |
| # of views: | 3527 |
|
|
|
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2010. The report worksheet will include the sales made by all the sales managers in the month of January.
In the worksheet, you are required to place a pictorial representation displaying the percentage of
total sales made by each sales manager in January. Which of the following charts will you use to
accomplish the task?
You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. You are creating a business report by using. Microsoft Excel 2010. You have arranged sales data as shown below:
You want to provide pictorial representation of the trend of the sales data in front of each row.
Which of the following actions will you take to accomplish the task with the least amount of
administrative burden?
HOTSPOT
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network.
You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly 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 required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
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?
