Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Microsoft 77-882 Exam - Cheat-Test.com

Free 77-882 Sample Questions:

Q: 1
You work as an Office Assistant for Tech Perfect Inc. You create a worksheet in Excel 2010 that contains various tables, headings, charts, and SmartArt objects. In order to give it a professional look, you choose Office theme as shown below:

You like the appearance of the sheet in this theme; however, you want to use the Lucida Calligraphy font for heading and Arial font for the body text. You often use this font combination for formatting office sheets. You are required to accomplish the following tasks:
Use the font combination in your current document. Enable Excel to provide this combination in other office documents too.
Choose the required steps to accomplish the tasks.

A.

Answer: A

Q: 2
Alan works as a Sales Manager for MVP Technologies. He is creating a sales report in Microsoft Excel 2010. In the report, he needs to enter the names of sales executives in one column and the sales target (in dollars) achieved by them in the next column as shown in the image below:

He wants to ensure that the color of a cell changes automatically to orange when the sales figure entered in the cell is more than $10,000. Which of the following actions will he take to accomplish the task?
A. Use the conditional formatting feature.
B. Use a style.
C. Use the AutoFormat feature.
D. Use the AutoCorrect feature.
Answer: A

Q: 3
You work as an Office Assistant of Mark World Inc. You have created a report in a workbook in Excel 2010. You want to change the layout of the worksheet from portrait to landscape.
Mark the option that you will choose to accomplish the task.

A.

Answer: A

Q: 4
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.

A.

Answer: A

Q: 5
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?
A. COUNTIFS(B2:C5,"=Yes")
B. COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")
C. COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
D. COUNTIF(B2:C5,"=Yes")
Answer: C

Q: 6
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.

A.

Answer: A


© 2014 Cheat-Test.com, All Rights Reserved