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

You work as an Office Assistant for Blue Well Inc. You are creating a report in a worksheet in Excel. You have prepared a table as shown below:

You want to increase the height of each row in such a manner that all rows have the same height.
Which of the following steps will you take to accomplish the task easily?

Martha works as a Sales Manager for Tech Info Inc. She is creating a sales report on Excel 2007. After preparing the sales report she clicks on the Full Screen view menu.

As soon as she clicks on the view menu, all toolbars and menus disappear. She wants to restore her worksheet status back to the Normal view quickly in minimum steps.
Which of the following steps will she take to accomplish the task?

HOTSPOT -
You work as an Office Assistant for Rainbow Inc. You are creating a report in a workbook in Excel 2007. You want to add a title to a worksheet in decorative text as shown in the image below:

You work as an Office Assistant for Tech Perfect Inc. You have converted a data range into a data table as shown in the image below:
You want to add a total row in the table to calculate the total. The total row will include the sum of the Total First Quarter column. You want to perform this in the easiest and best possible way. Which of the following steps will you take to accomplish the task?

You work as an Office Assistant for Tech Perfect Inc. You have created a complex workbook on Excel 2007. The workbook is a consolidated sales report that contains sales data for the last five years. This report will be circulated to all the company managers having different versions of Excel. You have to ensure the following:
The optimal performances of the workbook backward compatibility with earlier versions of Excel which of the following steps will you take to accomplish the task? Each correct answer represents a part of the solution. Choose two.