Excel 2010 (77-882) Free Practice Test

Question 1

You work as an Office Assistant for Blue Well Inc. You are creating a report in a worksheet in
Excel. You have prepared a table as shown below:

You want to increase the height of each row in such a manner that all rows have the same height.
Which of the following steps will you take to accomplish the task easily?

A. Select individual rows. Drag the border of rows to the required height.

B. Select all rows in the table. Drag the border of one of the selected rows to the required height.

C. Select all rows in the table. Right-click on the selected rows and click the Row Height option. In
the Row Height dialog box, provide the required value.

D. Select all rows in the table. Click the Format option in the Cells group on the Home tab. Click
Row Height. In the Row Height dialog box, provide the required value.

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
The workbook will be used to track sales of the company's product. The workbook will be updated by Sales Account Managers.
You save the workbook to a network location and enable sharing of the workbook. You select the option to allow changes by more than one user at the same time.
You want to keep any changes made by the Sales Account Managers for 60 days.
How can you configure Excel to save changes for 60 days?

A. You should consider configuring the Protect Workbook options.

B. You should consider doing nothing. This is the default when a workbook is shared.

C. You should consider configuring the Advanced options in the Share Workbook dialog box.

D. You should consider configuring the Track Changes option on the Review tab.

Correct Answer: C

Question 3

You work as an Office Assistant for Tech Perfect Inc. You are creating a report in a workbook in
Excel 2010. Before creating a final report, you are required to test some logical conditions. You
enter test data in a worksheet in the report. The fragment of the sheet is shown below:

You are testing logical conditions to use them in your report later. Which of the following
conditional formulas will return "True"?

A. =OR(E3>E4, E3<E5)

B. =NOT(E3+E4=34)

C. =AND(E3<E4, E3>E5)

D. =AND(E3>E4, E3<E5)

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

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. Configure a 3-D Cell Reference then enter the value into cell B2 on the first sheet.

C. Enter the value into cell B2 on the first sheet then use Copy and Paste to paste the value into the other sheets.

D. Use the Select All Sheets function. Click one of the sheets and enter the value into cell B2.

Correct Answer: A

Question 5

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?

A. A Full Pie chart.

B. An Area chart.

C. A Line doted chart.

D. A half Bar chart.

Correct Answer: D

Question 6

You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create and edit workbooks.
Your workbook has multiple worksheets and each worksheet has many rows of information.
You want to make several formatting changes to every cell in the workbook. You need to ensure that every cell has the same formatting.
What is the easiest way to apply several formats to the cells throughout a workbook?

A. You should consider pressing Ctrl + A and configuring the required formatting options.

B. You should consider selecting all cells and selecting the Format option on the Home tab.

C. You should consider using the Custom Views function on the View tab.

D. You should consider using the Cell Styles function on the Home tab.

Correct Answer: D

Question 7

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
The workbook will be used to track deployments of the company's product to customers. The workbook will be updated by members of the deployment team and by other users in the Sales department.
You want to be able to view the changes made to the workbook. You save the workbook to a network location and enable the Track Changes option.
Some users complain that when they open the workbook, it opens in Read Only mode.
How can you ensure that multiple users can open the workbook in Edit mode?

A. You should consider adding a History worksheet to the workbook.

B. You should consider selecting the Share Workbook option on the Review tab.

C. You should consider selecting the Protect Workbook option on the Review tab.

D. You should consider selecting the Group option on the Data tab.

Correct Answer: B

Question 8

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?

A. You should apply a Theme to the workbook.

B. You should configure a custom view to the workbook.

C. You should select all the cells in the first worksheet and apply suitable formatting. Repeat the process for the remaining worksheets.

D. You should use the Cell Styles function.

Correct Answer: A

Question 9

You have created a sales report in Microsoft Excel 2010 as shown in the image below:

You need to sort the data in such a way that sales data for the year 2010 is listed in higher to lower
order. Which of the following steps will you take to accomplish the task?

Correct Answer:

Explanation:
According to the question, you need to sort the data in such a way that sales data for the year 2010
is listed in higher to lower order. Take the following steps in order to accomplish the task:
1. Select a cell in the data range.
2. Click the Sort option in Data tab.
3. Select My Data Has Header check-box.
4. Select 2010 in the Sort By option.
5. Select Value in the Sort On column.
6. Select Largest to Smallest option in Order column.

Welcome to TestSimulate

Microsoft Excel 2010 (77-882) Free Practice Test