Microsoft 77-602 - MOS: Using Microsoft Office Excel 2007 Exam
Page: 1 / 13
Total 61 questions
Question #1 (Topic: )
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:
[Microsoft-77-602-6.0/Microsoft-77-602-2_2.png]
Which of the following steps will you take to accomplish the task?
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:
[Microsoft-77-602-6.0/Microsoft-77-602-2_2.png]
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.
Answer: B
Question #2 (Topic: )
You work as an Office Assistant for Pecuniary Inc. You have created a report in a
workbook in Excel 2007. You want to quickly format headings and titles in the workbook.
Mark the option that you will choose to accomplish the task.
[Microsoft-77-602-6.0/Microsoft-77-602-3_2.png]
workbook in Excel 2007. You want to quickly format headings and titles in the workbook.
Mark the option that you will choose to accomplish the task.
[Microsoft-77-602-6.0/Microsoft-77-602-3_2.png]
Answer: [Microsoft-77-602-6.0/Microsoft-77-602-3_3.png]
[Microsoft-77-602-6.0/Microsoft-77-602-3_4.png]
Question #3 (Topic: )
Shelly works as an Office Assistant for Star Publishing Co. She creates a report that
includes a list of books, along with the author's name. By mistake, she enters the incorrect
spelling of an author's name that appears most often in the whole report. She wants to
change incorrect spelling of the author's name with the correct spelling in the whole report.
Choose the option that he will use to accomplish the task.
[Microsoft-77-602-6.0/Microsoft-77-602-5_2.png]
includes a list of books, along with the author's name. By mistake, she enters the incorrect
spelling of an author's name that appears most often in the whole report. She wants to
change incorrect spelling of the author's name with the correct spelling in the whole report.
Choose the option that he will use to accomplish the task.
[Microsoft-77-602-6.0/Microsoft-77-602-5_2.png]
Answer: [Microsoft-77-602-6.0/Microsoft-77-602-5_3.png]
[Microsoft-77-602-6.0/Microsoft-77-602-5_4.png]
Question #4 (Topic: )
Rick works as an Office Assistant for Tech Perfect Inc. He uses Microsoft Excel 2007 for
creating reports. He is working on a report in which he has used few macros. He saves the
report in macroenabled workbook format. Which of the following extensions will Excel use
to save the workbook?
creating reports. He is working on a report in which he has used few macros. He saves the
report in macroenabled workbook format. Which of the following extensions will Excel use
to save the workbook?
A. xlsm
B. xls
C. xlsx
D. xlsb
Answer: A
Question #5 (Topic: )
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel.
You have selected all worksheets available in the workbook as shown below:
[Microsoft-77-602-6.0/Microsoft-77-602-8_2.png]
Now, you want to cancel the selection. Which of the following steps will you take to
accomplish the task with least administrative effort?
You have selected all worksheets available in the workbook as shown below:
[Microsoft-77-602-6.0/Microsoft-77-602-8_2.png]
Now, you want to cancel the selection. Which of the following steps will you take to
accomplish the task with least administrative effort?
A. Click on one of the selected sheets.
B. Double-click on one of the selected sheets.
C. Click any unselected sheet.
D. Right-click the selected sheets. Click the Ungroup Sheets option from the shortcut menu.
E. Click the Single Sheet options in the Sheet Options group on the Page Layout tab.
Answer: D
