Microsoft Excel 2010 - 77-882 Exam Practice Test
Question 1
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: A
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 2
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option
that he will choose to accomplish the task.
Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option
that he will choose to accomplish the task.
Correct Answer:
Explanation:
The Fill command is used to fill the active cell with the content of the adjacent cell. The Fill
command is run through Home tab > Editing group > Fill.
Click the Down, Right, Up, Left, or Series option to fill cells.
Reference:
Microsoft Excel Help, Contents: "Fill data automatically in worksheet cells"
Question 3
Your work at ABC.com includes the preparation of workbooks using Microsoft Office Excel 2010.
You have finished a lengthy report about product sales for the past year and project sales for the next year. The workbook lists the name of a product multiple times.
The company releases a new version of the product and the product name is changed to reflect the update.
You want to use the Replace dialog box to change every instance of the product name throughout the spreadsheet.
Which of the following key combinations opens the Replace dialog box?
You have finished a lengthy report about product sales for the past year and project sales for the next year. The workbook lists the name of a product multiple times.
The company releases a new version of the product and the product name is changed to reflect the update.
You want to use the Replace dialog box to change every instance of the product name throughout the spreadsheet.
Which of the following key combinations opens the Replace dialog box?
Correct Answer: A
Question 4
Your work at ABC.com includes the preparation of company spreadsheets using Microsoft Office Excel 2010.
You are preparing a financial report that will be emailed to company managers. You want to add a background image of the company logo to the spreadsheet. The background image should not be printed if a manager decides to print a copy of the spreadsheet.
How should you configure the spreadsheet?
You are preparing a financial report that will be emailed to company managers. You want to add a background image of the company logo to the spreadsheet. The background image should not be printed if a manager decides to print a copy of the spreadsheet.
How should you configure the spreadsheet?
Correct Answer: B
Question 5
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: D
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 6
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs
the Microsoft Excel 2010 application on the network. You open the application and see various
changes in Excel 2010. You have to open an existing worksheet through the application. You are
unable to find the Office button. Mark the option that you will click to accomplish the task. Click
on the Correct Spot in the Image. Doing so will place the target icon at the clicked spot.
the Microsoft Excel 2010 application on the network. You open the application and see various
changes in Excel 2010. You have to open an existing worksheet through the application. You are
unable to find the Office button. Mark the option that you will click to accomplish the task. Click
on the Correct Spot in the Image. Doing so will place the target icon at the clicked spot.
Correct Answer:
Explanation:
You will have to click File button to accomplish the task. Clicking the File button will open the
full- screen Backstage View of the sheet.
FactWhat is Backstage View?
Backstage View, introduced in Microsoft Office 2010, is a feature of MS Office to configure
options that affect the document as a whole, or the application itself. Backstage View can be In
Excel and houses the following commands: Saving, opening, and closing a document as well as
opening a new one Printing a document Changing Excel options Backstage View, a full-window
file menu, replaces the Office button of Office 2007 and can be accessed by pressing the File menu
button. It provides easy access to task-centered functions such as printing and sharing.
Reference:
Microsoft Office Help, Contents: "The File Button"
Question 7
Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You are working on a Sales report for the last week. You enter the name of each sales person in cells B2 to B10. You want to enter "Monday" in each of the cells from C2 to C10. You type Monday into cell C2 and drag the fill handle down to cell C10. You find the AutoFill function increments the weekdays to Tuesday, Wednesday, Thursday.... down to cell C10.
You drag the fill handle again and this time you click the AutoFill button.
Which AutoFill option should you select to have Monday entered in cells C2 to C10?
You are working on a Sales report for the last week. You enter the name of each sales person in cells B2 to B10. You want to enter "Monday" in each of the cells from C2 to C10. You type Monday into cell C2 and drag the fill handle down to cell C10. You find the AutoFill function increments the weekdays to Tuesday, Wednesday, Thursday.... down to cell C10.
You drag the fill handle again and this time you click the AutoFill button.
Which AutoFill option should you select to have Monday entered in cells C2 to C10?
Correct Answer: E
Question 8
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.
Question 9
You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create company sales reports.
It is the end of the financial year and you are working on a final sales report for the year. A copy of the report will be handed out to Sales Account Managers and Senior Management for discussion in an annual Sales Review meeting.
There are five worksheets in the workbook, one worksheet for each quarter and a fifth worksheet with combined totals and analysis of the quarterly figures.
You have entered all the data for each quarter and configured tables for the data. On the fifth worksheet, you have included graphical representations of the data using various types of charts.
You now want apply a consistent formatting across the entire workbook. You want to give the workbook a professional look by applying graphics effects, light colors and easy to read fonts.
What is the easiest way to prepare the workbook?
It is the end of the financial year and you are working on a final sales report for the year. A copy of the report will be handed out to Sales Account Managers and Senior Management for discussion in an annual Sales Review meeting.
There are five worksheets in the workbook, one worksheet for each quarter and a fifth worksheet with combined totals and analysis of the quarterly figures.
You have entered all the data for each quarter and configured tables for the data. On the fifth worksheet, you have included graphical representations of the data using various types of charts.
You now want apply a consistent formatting across the entire workbook. You want to give the workbook a professional look by applying graphics effects, light colors and easy to read fonts.
What is the easiest way to prepare the workbook?
Correct Answer: A
