Microsoft 77-882 Actual Free Exam Questions & Community Discussion
You work as an Office Assistant for Peach Tree Inc. You have created a report in a workbook
using Microsoft Excel 2010. The report includes a worksheet that contains sales data of the
company. You want to use complex criteria to filter the list. For testing, you have inserted criteria
rows in the sheet. The fragment of the worksheet is shown below:
The list range is defined as A9:D44. For testing, you want to filter the list for all the records of
Mark. You want to ensure that the filtered list does not provide duplicate rows. You also want to
display the filtered list at a new location at the G9 cell position. You open the Advanced Filter
dialog box by clicking the Advance option in the Sort & Filter group on the Data tab. Fill the
Advanced Filter dialog box options to fulfill your requirements.
using Microsoft Excel 2010. The report includes a worksheet that contains sales data of the
company. You want to use complex criteria to filter the list. For testing, you have inserted criteria
rows in the sheet. The fragment of the worksheet is shown below:
The list range is defined as A9:D44. For testing, you want to filter the list for all the records of
Mark. You want to ensure that the filtered list does not provide duplicate rows. You also want to
display the filtered list at a new location at the G9 cell position. You open the Advanced Filter
dialog box by clicking the Advance option in the Sort & Filter group on the Data tab. Fill the
Advanced Filter dialog box options to fulfill your requirements.
Correct Answer:
Explanation:
According to the question, you have to accomplish the following tasks:
Display all the records of Mark.
No duplicate rows should exist in the filtered list.
The filtered list is inserted and displayed in the new location at the G9 cell position.
In order to accomplish the task, you will have to provide entries as shown in the image given
below:
Opting for the Copy to another location radio-button will enforce to display the filtered list in the
specified location (in this case G9). You will have to provide A9:D44 in the List range option to
specify the list to be filtered. Provide range C5:C6 for the Criteria range option. The Copy to
option specifies the location where the filtered data has to be displayed. Provide G9 to accomplish
the task. As the question states that no duplicate records should appear, check the Unique records
only check-box. These steps will copy the filtered data at the G9 cell position as shown in the
image given below:
You work as a Sales Manager for Peach Tree Inc. Your responsibility includes creating sales
reports of the company. You create a report in a workbook in Excel 2010. The report contains a
worksheet that has been formatted by using the conditional formatting feature. You have specified
five conditions for conditional formatting of a list appearing in the sheet. You save the report and
send it to your manager. He informs you that the sheet on which conditional formatting feature is
applied is not appearing according to his requirement. He further specifies that only a few of the
conditions are applying. What is the most likely cause?
reports of the company. You create a report in a workbook in Excel 2010. The report contains a
worksheet that has been formatted by using the conditional formatting feature. You have specified
five conditions for conditional formatting of a list appearing in the sheet. You save the report and
send it to your manager. He informs you that the sheet on which conditional formatting feature is
applied is not appearing according to his requirement. He further specifies that only a few of the
conditions are applying. What is the most likely cause?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a sales report.
The report contains the table shown below.
You want to include a chart in the report to display a graphical comparison of the sales figures for the sales staff listed in the table.
Which type of chart would best illustrate a comparison of the sales figures?
The report contains the table shown below.
You want to include a chart in the report to display a graphical comparison of the sales figures for the sales staff listed in the table.
Which type of chart would best illustrate a comparison of the sales figures?
Correct Answer: B
Vote an answer
You work as a Sales Manager for Blue Well Inc. You have to create a report in Excel 2010 in the
following format:
What is the most likely cause?
following format:
What is the most likely cause?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Alan works as a Sales Manager for MVP Technologies. He is creating a sales report in Microsoft
Excel 2010. In the report, he needs to enter the names of sales executives in one column and the
sales target (in dollars) achieved by them in the next column as shown in the image below:
He wants to ensure that the color of a cell changes automatically to orange when the sales figure
entered in the cell is more than $10,000. Which of the following actions will he take to accomplish
the task?
Excel 2010. In the report, he needs to enter the names of sales executives in one column and the
sales target (in dollars) achieved by them in the next column as shown in the image below:
He wants to ensure that the color of a cell changes automatically to orange when the sales figure
entered in the cell is more than $10,000. Which of the following actions will he take to accomplish
the task?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Martha works as an Office Assistant for Tech Perfect Inc. She uses Microsoft Excel 2010 for
working on a report. She wants to add a picture as a background in her Excel worksheet. She does
not want that picture to be printed while printing. Which of the following steps will she take to
accomplish the task?
working on a report. She wants to add a picture as a background in her Excel worksheet. She does
not want that picture to be printed while printing. Which of the following steps will she take to
accomplish the task?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You work as an Office Assistant for Pecuniary Inc. You are creating a report in a workbook in
Microsoft Excel. 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 Microsoft Excel,
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?
Microsoft Excel. 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 Microsoft Excel,
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You work as the Financial Director at ABC.com. You are using Microsoft Office Excel 2010 to review the end-of-year financial reports from the ABC.com Sales department and from a partner company named Weyland Industries.
Weyland Industries is based in Mexico. The Weyland Industries financial report contains some text written in Spanish. To discover the meaning of the Spanish text, you navigate to the Proofing group on the Review tab and click the Translate button.
Which of the following would also give you the option to translate the Spanish text?
Weyland Industries is based in Mexico. The Weyland Industries financial report contains some text written in Spanish. To discover the meaning of the Spanish text, you navigate to the Proofing group on the Review tab and click the Translate button.
Which of the following would also give you the option to translate the Spanish text?
Correct Answer: D
Vote an answer
You work as the Sales Manager at ABC.com. Sally works as an Office Assistant in the Sales Office.
You have asked Sally to create a sales report on the sales targets for the previous quarter. Sally uses Microsoft Office Excel 2010 to create the report. Sally uses multiple conditional formatting rules to change the styles of the cells according to certain conditions.
Sally completes the report and emails it to you. However, when you open the report, it does not look how it should according to your instructions. You note that only a few of the required conditional formatting rules are applying.
Which of the following actions should you take?
You have asked Sally to create a sales report on the sales targets for the previous quarter. Sally uses Microsoft Office Excel 2010 to create the report. Sally uses multiple conditional formatting rules to change the styles of the cells according to certain conditions.
Sally completes the report and emails it to you. However, when you open the report, it does not look how it should according to your instructions. You note that only a few of the required conditional formatting rules are applying.
Which of the following actions should you take?
Correct Answer: B
Vote an answer
0
0
0
10