77-882 Exam Training Practice Tests (Microsoft Excel 2010)]

Question 1

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?

A. You should select the Fill Without Formatting option. B. You should select the Fill Formatting Only option. C. You should select the Fill Series option. D. You should select the Copy Cells option. E. You should select the Fill Days option.

Correct Answer: D

Question 2

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through 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:
Windows 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?

A. Ctrl + F B. Ctrl + H C. Ctrl + R D. Ctrl + B

Correct Answer: B

Question 4

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.

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:

Question 5

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.

A. Select the worksheet that contains the table. B. Select Print Selection in the Print Settings section. C. Select Print Active Sheet in the Print Settings section. D. Click the File tab button > Print. E. Click the File tab > Print > Print Preview. F. Select Print Selected Table in the Print Settings section. G. Select the table.

Correct Answer: D,F,G

Question 6

You work as the Financial Controller at ABC.com. You are using Microsoft Office Excel 2010 to edit multiple workbooks. You have workbooks open from different shared folders on the network.
You want to arrange the workbook windows so that you can view the titles of all the workbooks that you have open.
How should you configure the view?

A. You should select the Split option on the View tab. B. You should click the Arrange All button on the View tab and select the Vertical option. C. You should select the Switch Windows option on the View tab. D. You should click the Arrange All button on the View tab and select the Cascade option.

Correct Answer: D

Question 7

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a report on the sales figures for the first quarter.
The report contains the table shown below.

You want to add a column to the table to graphically illustrate the sales trends for each sales person as shown below.

How can you easily create the graphics used in the Trend column?

A. You should consider inserting Shapes. B. You should consider inserting an image. C. You should consider inserting Sparklines. D. You should consider inserting Line Charts.

Correct Answer: C

Question 8

You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook.
The workbook has twelve worksheets. The worksheets are named January through December and have rows labeled according to each day of the month.
You want to enter a value in the cell B2 on each worksheet.
What is the easiest way to insert the same value into the same cell on all worksheets in a workbook?

A. Use the Select All Sheets function and enter the value into cell B2 on the active sheet. B. Enter the value into cell B2 on the first sheet then use Copy and Paste to paste the value into the other sheets. C. Configure a 3-D Cell Reference then enter the value into cell B2 on the first sheet. D. Use the Select All Sheets function. Click one of the sheets and enter the value into cell B2.

Correct Answer: A

Question 9

You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in
Excel 2010. You want to insert flow-chart in the sheet. Mark the option that you will choose to
insert flow- chart symbols in the report.

Correct Answer:

Explanation:
In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple
objects provided by Microsoft Office to add them to a document. A single shape or combined
multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines,
basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and callouts.
Users can add text, bullets, numbering, and Quick Styles to these shapes after inserting them in the
document. Take the following steps to add a shape in a document:
1.Click on the Shapes option in the Illustrations group on the Insert tab. This will open the list of
shapes available in Microsoft Office.

2.Choose the required shape from the list.

Microsoft Excel 2010 - 77-882 Exam Practice Test