77-602 Actual Exam Questions

Last updated on Dec. 19, 2024.
Vendor:Microsoft
Exam Code:77-602
Exam Name:MOS: Using Microsoft Office Excel 2007
Exam Questions:61
 

Topic 1 - Exam A

Question #1 Topic 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?

  • A. Insert a Drawing object.
    Add the signature image to the object.
    Validate all data entries.
  • B. Insert a Signature Line object.
    Place the digital signature on the Signature Line.
  • C. Insert a Text object.
    Add the signature image to the object.
    Add a read-only attribute to the workbook.
  • D. Insert a WordArt object.
    Add the signature file to the object.
    Protect the workbook.
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #2 Topic 1

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?

  • A. The Home Premium edition of Vista does not support some of the Office 2007 commands.
  • B. The Help file of the Office suite is not current.
  • C. You are using Beta version of Excel 2007.
  • D. The program window is shrinked.
Reveal Solution Hide Solution   Discussion  

Correct Answer: D 🗳️

Question #3 Topic 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 > Background option to insert the picture
  • B. Use Insert > Text > Headers & Footers
  • C. Use Page Layout > Page Setup > Print Titles
  • D. Use Insert > Illustrations > Picture to insert the picture
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #4 Topic 1

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?

  • A. It will limit the access to the worksheet.
  • B. It will restrict users to make any changes in the worksheet.
  • C. It will hide the confidential data.
  • D. It will encryypt the data.
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

file Viewing page 1 out of 16 pages.
Viewing questions 1-4 out of 61 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago