Microsoft 77-882 - Excel 2010 Exam
Page: 2 / 5
Total 25 questions
Question #6 (Topic: )
You work as an Office Assistant for Media Perfect Inc. You are creating a report in
Microsoft Excel 2010. The report worksheet will include the sales made by all the sales
managers in the month of January.
[Microsoft-77-882-5.0/Microsoft-77-882-5_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?
Microsoft Excel 2010. The report worksheet will include the sales made by all the sales
managers in the month of January.
[Microsoft-77-882-5.0/Microsoft-77-882-5_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. Column
B. Line
C. Pie
D. Bar
Answer: C
Question #7 (Topic: )
You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales
report of the Sales department. You use Microsoft Excel 2010 to prepare sales reports.
You have created a quarterly sales report of the department. After entering required data
and inserting charts, you want to give a professional look to the document. You want to
produce the document with soothing graphic effects, soft fonts, and light colors. Which of
the following steps will you take to accomplish the task with least administrative burden?
report of the Sales department. You use Microsoft Excel 2010 to prepare sales reports.
You have created a quarterly sales report of the department. After entering required data
and inserting charts, you want to give a professional look to the document. You want to
produce the document with soothing graphic effects, soft fonts, and light colors. Which of
the following steps will you take to accomplish the task with least administrative burden?
A. Use the SmartArt option.
B. Create a new workbook through a template. Copy all data and charts of the report to the new workbook.
C. Select all the text of the document. Change font style to Verdana and font color to light gray. Use vibrant colors for charts.
D. Choose one of the pre-built themes.
Answer: D
Question #8 (Topic: )
You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing
sales reports of the company. You have created a sales report in a workbook of Excel
2010. Your workbook includes several worksheets as shown in the image given below:
[Microsoft-77-882-5.0/Microsoft-77-882-7_2.png]
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will you take to accomplish the task?
sales reports of the company. You have created a sales report in a workbook of Excel
2010. Your workbook includes several worksheets as shown in the image given below:
[Microsoft-77-882-5.0/Microsoft-77-882-7_2.png]
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will you take to accomplish the task?
A. Select the sheets containing charts. Select the Effects option in the Themes group on the Page Layout page.
B. Select the sheets containing charts. Select the Colors option in the Themes group on the Page Layout page.
C. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Tab Color option from the shortcut menu.
D. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Sheet Color option from the shortcut menu.
Answer: C
Question #9 (Topic: )
You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010
for creating various types of reports. You have created a report in the format given below:
In the A7 cell, you are required to put a formula so that it can fulfill the description provided
in the B7 cell. Which of the following formulas will provide the required result?
for creating various types of reports. You have created a report in the format given below:
In the A7 cell, you are required to put a formula so that it can fulfill the description provided
in the B7 cell. Which of the following formulas will provide the required result?
A. COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")
B. COUNTIFS(B2:C5,"=Yes")
C. COUNTIF(B2:C5,"=Yes")
D. COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
Answer: D
Question #10 (Topic: )
You are creating a business report by using Microsoft Excel 2010. You have arranged
sales data as shown below:
You want to provide pictorial representation of the trend of these sales data in front of each
row. Which of the following steps will you choose to accomplish the task involving the least
amount of administrative burden?
sales data as shown below:
You want to provide pictorial representation of the trend of these sales data in front of each
row. Which of the following steps will you choose to accomplish the task involving the least
amount of administrative burden?
A. Use charts.
B. Use illustrations.
C. Use conditional formatting.
D. Use spark lines.
Answer: D
