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

You work as a Sales Manager for Media Perfect Inc. You have created a report in a workbook in Excel 2007. You want to ensure that the A1 cell displays the current time whenever you open the workbook. For this, you select the A1 cell. Which of the following formulas will you insert to accomplish the task?

You work as a Sales Manager for Blue Well Inc. You have created a sales report in Excel 2007. You are required to publish it to your company's intranet. Before publishing it to the intranet, you want to save the report in PDF format. However, when you try to use the SAVE AS option, you are unable to find the option for saving the document in PDF format.
What is the most likely cause?

You work as an Office Assistant for Blue Well Inc. You have created a workbook in Excel 2007. This workbook will be shared with other users who will collaborate to enter data in the workbook. You want to enable Excel in such a manner that if you have a question regarding the editing done by any collaborator, you can identify who made the changes and verify that it is correct. Which of the following steps will you take to accomplish the task?
Each correct answer represents a complete solution. Choose two.

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2007 to submit it to your manager. You have used several formulas in the report. You want to see which formula is referring to a cell. Which of the following steps will you take to accomplish the task?

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?