77-882 무료 덤프문제 온라인 액세스
| 시험코드: | 77-882 |
| 시험이름: | Excel 2010 |
| 인증사: | Microsoft |
| 무료 덤프 문항수: | 90 |
| 업로드 날짜: | 2026-08-19 |
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.
You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team
using Microsoft Excel. You want the report to appear in the following format:
Which of the following conditional formulas will you insert 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?
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?
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.
