77-602

Review 61 77-602 practice questions with answer explanations and community insights.

Question 1

You work as a Sales Manager for Young World Inc. You have created a sales report that needs to be submitted to the head office. Before sending the report to your manager, you want to ensure that the integrity of the document is maintained. You also want to place your signature as shown in the image below: Which of the following steps will you take to accomplish the task?

  1. Insert a Drawing object. Add the signature image to the object. Validate all data entries.
  2. Insert a Signature Line object. Place the digital signature on the Signature Line.
  3. Insert a Text object. Add the signature image to the object. Add a read-only attribute to the workbook.
  4. Insert a WordArt object. Add the signature file to the object. Protect the workbook.

Question 2

You work as a Sales Manager for Dreams Unlimited Inc. Your computer runs Windows Vista Home Premium. You have recently installed Microsoft Office 2007 on your computer. You use Excel to create your reports. As the interface has been changed in the new version, you often use Excel 2007 Help to find out your required commands. Sometimes, when you look at the Ribbon, you might not see all of the icons or the text that is used in some Help topics to describe the commands on the Ribbon. What is the most likely cause?

  1. The Home Premium edition of Vista does not support some of the Office 2007 commands.
  2. The Help file of the Office suite is not current.
  3. You are using Beta version of Excel 2007.
  4. The program window is shrinked.

Question 3

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?

  1. Use Page Layout > Page Setup > Background option to insert the picture
  2. Use Insert > Text > Headers & Footers
  3. Use Page Layout > Page Setup > Print Titles
  4. Use Insert > Illustrations > Picture to insert the picture

Question 4

You work as an Technician in Tech Perfect Inc. You are creating a report in Microsoft Excel. You protect the worksheet elements in the worksheet. Which of the following functionalities will be achieved by your action?

  1. It will limit the access to the worksheet.
  2. It will restrict users to make any changes in the worksheet.
  3. It will hide the confidential data.
  4. It will encryypt the data.

Question 5

You work as a Director for Tech Perfect Inc. The company has several branch offices located throughout the United States. Its network spans the whole country. You are creating a sales report in Excel 2007 that will be distributed to all sales managers of the company. However, you are unaware about the versions of Excel these sales managers are using. You want to ensure that your report is visible to all the sales managers irrespective of which version they are using. You also want to save the workbook in the default format and, before saving the document, check the features you have used that are not supported by earlier versions. Which of the following steps will you take to accomplish the task?

  1. Use the Inspect Document option through the Office button > Prepare.
  2. Use the Mark as Final option through the Office button > Prepare.
  3. Save the report as Excel 97-2003 workbook.
  4. Use the Run Compatibility Checker option through the Office button > Prepare.
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.