Microsoft 77-602 - MOS: Using Microsoft Office Excel 2007 Exam
Page: 3 / 13
Total 61 questions
Question #11 (Topic: )
You work as an Office Assistant for Net Perfect Inc. You are working on Excel 2007 to
create a sales report for the current week. Your workbook contains four worksheets. You
have tabulated data in the first sheet. In the second worksheet, few cells contain formulas
that refer to the first worksheet.
You want to view both worksheets side-by-side to see how modifying data in the first
worksheet changes the formula's result in the second sheet.
Which of the following steps will you use to accomplish the task?
create a sales report for the current week. Your workbook contains four worksheets. You
have tabulated data in the first sheet. In the second worksheet, few cells contain formulas
that refer to the first worksheet.
You want to view both worksheets side-by-side to see how modifying data in the first
worksheet changes the formula's result in the second sheet.
Which of the following steps will you use to accomplish the task?
A. Save a copy of the workbook with a different name. Open both copies in Excel. Use the Arrange Horizontal option in the Arrange Windows dialog-box.
B. Click the New Window option on the View tab's Window group. Use the Arrange Vertical option in the Arrange Windows dialog-box.
C. Select both the sheets. Click the Landscape Orientation option on the Page Layout tab's Page Setup group.
D. Save a copy of the workbook with a different name. Open both copies in Excel. Use the Arrange Vertical option in the Arrange Windows dialog-box.
Answer: B
Question #12 (Topic: )
You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating
sales reports for the Sales department. You use Excel 2007 to create these reports. You
have created a yearly sales report. The fragment of the report is shown below:
[Microsoft-77-602-6.0/Microsoft-77-602-19_2.png]
sales reports for the Sales department. You use Excel 2007 to create these reports. You
have created a yearly sales report. The fragment of the report is shown below:
[Microsoft-77-602-6.0/Microsoft-77-602-19_2.png]
Answer: [Microsoft-77-602-6.0/Microsoft-77-602-20_2.png]
[Microsoft-77-602-6.0/Microsoft-77-602-20_3.png]
Question #13 (Topic: )
You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating
sales incentive report of all sales managers for every quarter. You are using Microsoft
Excel to create a worksheet for preparing the report. You have inserted the sales figures of
all sales managers as shown in the image given below:
[Microsoft-77-602-6.0/Microsoft-77-602-21_2.png]
You have to calculate the first quarter incentives for all sales managers. The incentive
percentage (provided in cell B3) is fixed for all sales managers. The incentive will be
calculated on their total first quarter sales. You have to write a formula in the cell F8. Then
you will drag the cell border to the cell F12 to copy the formula to all the cells from F8 to
F12. In the first step, you select the F8 cell. Which of the following formulas will you insert
to accomplish the task?
sales incentive report of all sales managers for every quarter. You are using Microsoft
Excel to create a worksheet for preparing the report. You have inserted the sales figures of
all sales managers as shown in the image given below:
[Microsoft-77-602-6.0/Microsoft-77-602-21_2.png]
You have to calculate the first quarter incentives for all sales managers. The incentive
percentage (provided in cell B3) is fixed for all sales managers. The incentive will be
calculated on their total first quarter sales. You have to write a formula in the cell F8. Then
you will drag the cell border to the cell F12 to copy the formula to all the cells from F8 to
F12. In the first step, you select the F8 cell. Which of the following formulas will you insert
to accomplish the task?
A. =B3/100 * $E$8
B. =$B$3/100 * E8
C. =&B&3/100 * E8
D. =B3/100 * E8
E. =B3/100 * &E&8
Answer: B
Question #14 (Topic: )
You work as a Sales Manager for Tech Perfect Inc. You are creating a weekly sales report.
Before finalizing the report, you want to verify the correctness of all formulas that are used
in the report.
For this, you want to print the report displaying all formulas, instead of their values. Which
of the following steps will you take to accomplish the task?
Before finalizing the report, you want to verify the correctness of all formulas that are used
in the report.
For this, you want to print the report displaying all formulas, instead of their values. Which
of the following steps will you take to accomplish the task?
A. Click the Show Formula option in the Formula Auditing group on the Formula tab. Use the Print option to print the report.
B. Select the Show Formula option in the Print dialog box.
C. Click the Print Formula option in the Formula Auditing group on the Formula tab. Use the Print option to print the report.
D. Select the Print Formula option in the Print dialog box.
Answer: A
Question #15 (Topic: )
You work as an Office Assistant for Media Perfect Inc. You are creating a report in a
workbook in Excel 2007. You have to insert a Venn-diagram in a worksheet. Mark the
option you will choose to accomplish the task.
[Microsoft-77-602-6.0/Microsoft-77-602-23_2.png]
workbook in Excel 2007. You have to insert a Venn-diagram in a worksheet. Mark the
option you will choose to accomplish the task.
[Microsoft-77-602-6.0/Microsoft-77-602-23_2.png]
Answer: [Microsoft-77-602-6.0/Microsoft-77-602-23_3.png]
[Microsoft-77-602-6.0/Microsoft-77-602-23_4.png]
