Microsoft 77-602 - MOS: Using Microsoft Office Excel 2007 Exam
Page: 2 / 13
Total 61 questions
Question #6 (Topic: )
You work as a Sales Manager for Media Perfect Inc. You have created a sales report in a
workbook in Excel 2007. You want to display the file name with complete path of the
current document in A1 cell as shown in the image below: Which of the following steps will
you take to accomplish the task?
[Microsoft-77-602-6.0/Microsoft-77-602-9_2.png]
workbook in Excel 2007. You want to display the file name with complete path of the
current document in A1 cell as shown in the image below: Which of the following steps will
you take to accomplish the task?
[Microsoft-77-602-6.0/Microsoft-77-602-9_2.png]
A. Insert the following formula in cell A1: =filename("A1")
B. Click the Header & Footer option in the Text group of the Insert tab. Select the Footer section. Click the File Name option in the Header & Footer Elements group of the Design tab.
C. Click the Header & Footer option in the Text group of the Insert tab. Select the Header section. Click the File Name option in the Header & Footer Elements group of the Design tab.
D. Insert the following formula in cell A1: =cell("filename")
Answer: D
Question #7 (Topic: )
You work as an Office Assistant for Pecuniary Inc. You are creating a report in a workbook
in Excel 2007. The company borrowed a sum of $1000000 at 6% interest rate, which is to
be paid within 24 months. You are required to prepare a report in a workbook in Excel
2007, which shows the calculation of monthly installments to be paid to repay the loan.
Which of the following formulas will you use to accomplish the task?
in Excel 2007. The company borrowed a sum of $1000000 at 6% interest rate, which is to
be paid within 24 months. You are required to prepare a report in a workbook in Excel
2007, which shows the calculation of monthly installments to be paid to repay the loan.
Which of the following formulas will you use to accomplish the task?
A. PMT(1000000, 6/12, 24, 0, 0)
B. PMT(6/12, 24, 1000000, 0,0)
C. PMT(6%/12, 24, 1000000, 0, 0)
D. PMT(1000000, 6%/12, 24, 0, 0)
Answer: C
Question #8 (Topic: )
You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet
in Excel 2007. You want to insert flow-chart in the sheet. Mark the option that you will
choose to insert flowchart symbols in the report.
[Microsoft-77-602-6.0/Microsoft-77-602-11_2.png]
in Excel 2007. You want to insert flow-chart in the sheet. Mark the option that you will
choose to insert flowchart symbols in the report.
[Microsoft-77-602-6.0/Microsoft-77-602-11_2.png]
Answer: [Microsoft-77-602-6.0/Microsoft-77-602-11_3.png]
Question #9 (Topic: )
You work as a Sales Manager for Deep Lake Inc. You create a report in Excel 2007. This
report will be used by your sales team members to fill daily sales data. You save the report
with the name Daily Sales Report. After saving the report, you share it to all your team
members. You want to validate entries in some of the cells in the report. You open Daily
Sales Report and try to validate one of the cells. However, you find that the validation
option is not enabled.
[Microsoft-77-602-6.0/Microsoft-77-602-14_2.png]
You want to have validation in place in the shared workbook. Which of the following steps
will you take to accomplish the task?
report will be used by your sales team members to fill daily sales data. You save the report
with the name Daily Sales Report. After saving the report, you share it to all your team
members. You want to validate entries in some of the cells in the report. You open Daily
Sales Report and try to validate one of the cells. However, you find that the validation
option is not enabled.
[Microsoft-77-602-6.0/Microsoft-77-602-14_2.png]
You want to have validation in place in the shared workbook. Which of the following steps
will you take to accomplish the task?
A. Disable protection of the sheet. Apply validation rules.
B. Enable protection for the sheet. Apply validation rules.
C. Disable sharing of the sheet. Apply validation rules.
D. Select all the cells that need to be validated. Ensure that no validation rules are applied previously. Apply validation rules.
Answer: C
Question #10 (Topic: )
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel.
The report worksheet will include the sales made by all the sales managers in the month of
January.
[Microsoft-77-602-6.0/Microsoft-77-602-16_2.png]
In the worksheet, you are required to place a pictorial representation displaying the
percentage of total sales made by each sales manager in January. Which of the following
charts will you use to accomplish the task?
The report worksheet will include the sales made by all the sales managers in the month of
January.
[Microsoft-77-602-6.0/Microsoft-77-602-16_2.png]
In the worksheet, you are required to place a pictorial representation displaying the
percentage of total sales made by each sales manager in January. Which of the following
charts will you use to accomplish the task?
A. Line
B. Pie
C. Bar
D. Column
Answer: B
