Microsoft 77-602 Exam Questions

Question 6 of 61

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?

PMT()

NOW()

TIME()

TIMEVALUE()

Correct Answer: B

Question 7 of 61

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?

The document is not protected.

The required add-ins are not installed.

Excel 2007 does not support saving documents in PDF format.

The Save as PDF option is available under the Office button > Publish.

Correct Answer: B

Question 8 of 61

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.

Enable the Show Comments feature.

Turn on the Change Tracking feature.

Share the workbook.

Add a History worksheet to the workbook.

Correct Answer: B, C

Question 9 of 61

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?

Select the cell. On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

Select the cell. Choose the Trace Precedents in the Formula Auditing group in the Formula tab.

Select the cell. On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

Select the cell. Choose the Trace Dependents in the Formula Auditing group in the Formula tab.

Correct Answer: D

Question 10 of 61

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?

xlsm

xls

xlsx

xlsb

Correct Answer: A