Free Microsoft 77-882 Exam Dumps Questions & Answers
| Exam Code/Number: | 77-882Join the discussion |
| Exam Name: | Excel 2010 |
| Certification: | Microsoft |
| Free Question Number: | 90 |
| Publish Date: | Nov 13, 2026 |
| # of views: | 2838 |
|
|
|
You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is
creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used
many formulas in her report. She wants to monitor a cell which contains a formul a. The formula
refers to many other cells that are located in different worksheets in the report. She wants to know
the effects on the cell when the values in different sheets changes. She requests you to help her out
to accomplish the task. Which of the following steps will you advice her to accomplish the task?
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 Media Perfect Inc. Your responsibility includes creating sales
reports for the Sales department. You use Microsoft Excel 2010 to create these reports. You have
created an yearly sales report. The fragment of the report is shown below:
As the report is quite wide, printing this report involves three A4 size pages. You want the first
column (column A) to repeat in every printed page. Mark the option that you will choose to
accomplish the task.
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 these sales data in front of each row.
Which of the following steps will you choose to accomplish the task involving the least amount of
administrative burden?
Your work at ABC.com includes the preparation of company documents using Microsoft Office 2010. You are using Microsoft Office Excel 2010 to create a workbook.
The workbook contains sensitive information. You want the word CONFIDENTIAL to be displayed on every page when the workbook is printed.
You have a picture file named confidential.gif that contains the required CONFIDENTIAL message.
What should you do with the picture file?


