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-602 Exam - Cheat-Test.com

Free 77-602 Sample Questions:

Q: 1
Martha works as an Office Assistant for Tech Perfect Inc. She uses Excel 2007 for working on a report. She wants to add a picture as a background in her Excel worksheet. She does not want that picture to be printed while printing. Which of the following steps will she take to accomplish the task?
A. Use Page Layout > Page Setup > Print Titles
B. Use Page Layout > Page Setup > Background option to insert the picture
C. Use Insert > Text > Headers & Footers
D. Use Insert > Illustrations > Picture to insert the picture
Answer: B

Q: 2
You want to have validation in place in the shared workbook.

Which of the following steps will you take to accomplish the task?
A. Enable protection for the sheet.
Apply validation rules.
B. Disable sharing of the sheet.
Apply validation rules.
C. Select all the cells that need to be validated.
Ensure that no validation rules are applied previously.
Apply validation rules.
D. Disable protection of the sheet.
Apply validation rules.
Answer: B

Q: 3
You work as an Office Assistant for Dreams Unlimited Inc. You use Excel 2007 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. COUNTIF(B2.B5,"=Yes",C2.C5,"=Yes")
B. COUNTIFS(B2.C5,"=Yes")
C. COUNTIF(B2.C5,"=Yes")
D. COUNTIFS(B2.B5,"=Yes",C2.C5,"=Yes")
Answer: B

Q: 4
You work as a Sales Manager for Net Perfect Inc. You are preparing yearly sales report using Excel 2007. You collaborated this document with your team members so that they can also work on it. After finalization of the document, you have to share it with your sales team over the intranet. Before sharing it you want to ensure that the workbook does not contain items such as comments or ink annotations. You click Office button > Prepare. Choose the required option to accomplish the task.

A.

Answer: A

Q: 5
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Excel 2007. He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will chose to accomplish the task.

A.

Answer: A


© 2014 Cheat-Test.com, All Rights Reserved