Microsoft 77-602 Exam Practice Questions (P. 5)

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

You work as a Sales Manager for Peach Tree Inc. You have created a report in a workbook in Excel 2007. The segment of a worksheet in the report is shown in the image given below:

The list includes Zones and Months columns. You want to summarize sales data on the basis of these columns. Which of the following steps will you take to accomplish the task with least administrative burden?

Sam works as an Editor for Sam Tech Inc. He has to send an article that contains some important data tables for publishing. He creates those tables in Microsoft Excel. He wants to assure that the content has not been changed or tampered with. Which of the following features will he use to accomplish the task?

You work as a Sales Manager for Tech Perfect Inc. You have created a report in a workbook in Excel 2007. The report contains lots of headings and titles. You have formatted cells through styles. You delete a heading from a cell. However, you see that the formatting of the cell is not deleted. You want to remove the formatting from the cell. Which of the following steps will you take to accomplish the task with least administrative burden?

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:

Now, you want to cancel the selection. Which of the following steps will you take to accomplish the task with least administrative effort?