Excel 2010 (77-882) Free Practice Test

Question 1

You work as the Financial Controller at an engineering company. The company is considering taking out a loan to purchase some new machinery.
You are in the process of evaluating the payment options for different loan amounts over different repayment periods. You are using Microsoft Office Excel 2010 to calculate the repayments.
Assuming a constant interest rate and constant monthly payments, which Excel function would you use to calculate the loan repayments?

A. RATE()

B. PMT()

C. LOAN()

D. PV()

Correct Answer: B

Question 2

You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
You want to print copies of the report to distribute to other employees in a meeting. The report uses several columns. You view the printable area of the worksheet and see that the columns do not fit on a single page.
To be able to print all the columns on a single page without scaling down the page, you want to change the layout of the worksheet from portrait to landscape.
How can you change the layout to landscape?

A. You should consider selecting the Breaks option in the Page Setup group on the Page Layout tab.

B. You should consider selecting the Format option in the Cells group on the Home tab.

C. You should consider selecting the Page Layout option in the Workbook Views group on the View tab.

D. You should consider selecting the Orientation option in the Page Setup group on the Page Layout tab.

Correct Answer: D

Question 3

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You
have inserted the following formula in a cell: VLOOKUP(12, A2:C10, 3, FALSE ) Which of the
following actions will be performed by the formula?

A. Wrong syntax used.

B. Search the value 3 in the last column of the range, and then returns the value that is in the
column of the range and on the same row as the lookup value.

C. Search the value 12 in the third column of the range and then returns the value that is contained
in the 12th column of the range and on the same column as the lookup value.

D. Search for the value 12 in the first column of the range, and then returns the value that is
contained in the third column of the range and on the same row as the lookup value.

Correct Answer: D

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

Question 4

Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You have a formula in a spreadsheet that reads data from an external source and performs a calculation to calculate current Sales figures. You want to include a function in the spreadsheet to display the current time whenever the spreadsheet is opened or when the spreadsheet is calculated.
Which Excel function should you make use of in your spreadsheet?

A. You should make use of the TIMEVALUE() function.

B. You should make use of the NOW() function.

C. You should make use of the TIME() function.

D. You should make use of the DATEVALUE() function.

Correct Answer: B

Question 5

You work as a Sales Manager at ABC.com. All users in the Sales department run Microsoft Office 2010 having recently been uABCraded from Microsoft Office 2003.
You are currently working on a Sales report in Microsoft Office Excel 2010.
You maximize the worksheet viewing area by selecting the Full Screen option on the View tab. When you select Full Screen, all toolbars and menus disappear.
How can you restore the worksheet view back to the Normal View so that you can see the toolbars?

A. You should consider making use of the Alt + W + M keyboard shortcut.

B. You should consider making use of the Restore Down button in the Control menu.

C. You should consider making use of the Windows + M keyboard shortcut.

D. You should consider right-clicking on the taskbar tab for the workbook.

E. You should consider making use of the Alt + W + L keyboard shortcut.

Correct Answer: B

Question 6

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a Sales Report.
The sales report contains a table that lists the sales figures for each month for each of the Sales Account Managers. A column in the table uses the SUM() function to provide a value for the total annual sales for each of the Sales Account Managers.
The cell that contains the annual total sales for one of the Sales Account Managers displays the formula as shown below whereas the totals for all the other Sales Account Managers are displayed as values.

How can you display the formula as a value?

A. You should consider deselecting the Show Formulas option on the Formulas tab.

B. You should consider removing the blank space in the cell before the formula.

C. You should consider clicking the Evaluate Formula option on the Formulas tab.

D. You should consider changing the format of the cell.

Correct Answer: B

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 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 9

You work as an Office Assistant for Peach Tree Inc. You have created a sales report worksheet in
Excel 2010. In the worksheet, you have created a chart to visually summarize the sales achieved by
Mark:

You want to transfer the chart to a new worksheet named MarkSales. Which of the following steps
will you take to accomplish the task?

Correct Answer:

Explanation:
In order to accomplish the task, you will have to take the following steps: Select the chart.

This task can also be accomplished by taking the following steps:
Select the chart.
Create a new sheet.
Rename the new sheet as MarkSales.
Press Ctrl + X to cut the chart and paste it to the MarkSales sheet by pressing Ctrl + V keys.
However, this will involve more administrative efforts.

Welcome to TestSimulate

Microsoft Excel 2010 (77-882) Free Practice Test