Microsoft Excel 2010 - 77-882 Exam Practice Test
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:
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?
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:
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?
Correct Answer: A
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the
company. You create a report in a workbook in Excel 2010. A worksheet in the report contains a
list. The fragment of the sheet is shown below:
The list contains the sales data of all sales managers of the company. You want to format all the
cells that contain the value "Mark" in the Sales Manager column, so that they appear differently.
You have to do it with the least administrative burden. Choose the required steps that you will take
to accomplish the task. You work as an
company. You create a report in a workbook in Excel 2010. A worksheet in the report contains a
list. The fragment of the sheet is shown below:
The list contains the sales data of all sales managers of the company. You want to format all the
cells that contain the value "Mark" in the Sales Manager column, so that they appear differently.
You have to do it with the least administrative burden. Choose the required steps that you will take
to accomplish the task. You work as an
Correct Answer:
Explanation:
In order to accomplish the task with the least administrative burden, you will have to take the
following steps: Select the Sales Managers column.
Click the Conditional Formatting option in the Style group on the Home tab, and then click the
Text that Contains option from the sub-menu.
FactWhat are conditional formats in Excel?
In Excel, conditional formats are format settings that are applied by Excel only when contents of a
cell meet the specified criteria. The conditional formatting feature of Excel provides the facility to
implement conditional formats. It allows users to automatically apply formatting on cells
depending on the values of cells or the values of formulas in the cells. Although the format painter
can be effectively used for copying the formatting of a cell to other cells, it involves lot of
administrative efforts.
You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report ready for a meeting with ABC.com senior management.
You want to print a table from your financial report.
Which combination of the following steps will print the table without printing the rest of the worksheet? Choose three.
You want to print a table from your financial report.
Which combination of the following steps will print the table without printing the rest of the worksheet? Choose three.
Correct Answer: B,D,E
Vote an answer
Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in
the log. Plowing through all the records will be time taking. Which option can be used to view
only the relevant records?
the log. Plowing through all the records will be time taking. Which option can be used to view
only the relevant records?
Correct Answer: B
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
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: D
Vote an answer
Explanation: Only visible for PassTestking 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 workbook.
You want to insert a Hierarchy Table like the one shown below into a worksheet.
Which Excel function should you use to insert a Hierarchy Table?
You want to insert a Hierarchy Table like the one shown below into a worksheet.
Which Excel function should you use to insert a Hierarchy Table?
Correct Answer: B
Vote an answer
You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
The first worksheet in the financial report contains sales figures for each Sales person for the first quarter of the year. The second worksheet contains sales figures for each Sales person for the second quarter of the year. The third worksheet contains formulas that pull data from the sales figures on the first and second worksheets.
You want to view all three worksheets simultaneously so you can see how the totals on the third worksheet are affected by changes to the figures in the first two worksheets. You currently have the workbook open in Excel.
Which combination of the following steps would enable you to view all three worksheets side-byside? Choose two.
The first worksheet in the financial report contains sales figures for each Sales person for the first quarter of the year. The second worksheet contains sales figures for each Sales person for the second quarter of the year. The third worksheet contains formulas that pull data from the sales figures on the first and second worksheets.
You want to view all three worksheets simultaneously so you can see how the totals on the third worksheet are affected by changes to the figures in the first two worksheets. You currently have the workbook open in Excel.
Which combination of the following steps would enable you to view all three worksheets side-byside? Choose two.
Correct Answer: A,C
Vote an answer
You work as an Office Assistant of Mark World Inc. You have created a report in a workbook in
Excel 2010. You want to change the layout of the worksheet from portrait to landscape. Mark the
option that you will choose to accomplish the task.
Excel 2010. You want to change the layout of the worksheet from portrait to landscape. Mark the
option that you will choose to accomplish the task.
Correct Answer:
Explanation:
The question specifies that you have to change the layout of the worksheet from portrait to
landscape. The Portrait layout is the default configuration of Excel. The Orientation option in the
Page Setup group of the Page Layout tab is used to switch the pages in portrait of landscape
layouts. In order to accomplish the task, click the Orientation option in the Page Setup group of the
Page Layout tab, and then click the Landscape option.
John works as an Accounts Auditor for ABC.com. He is using Microsoft Office Excel 2010 to create a workbook.
John enters the following formula into a cell:
VLOOKUP (15, A4:D11, 4, FALSE)
Which two of the following options describe what action the formula performs? Choose two.
John enters the following formula into a cell:
VLOOKUP (15, A4:D11, 4, FALSE)
Which two of the following options describe what action the formula performs? Choose two.
Correct Answer: C,D
Vote an answer