QUESTION 1
You work as a Sales Assistant at ABC.com. All users in the Sales department run Microsoft Office 2010.
You currently have Excel 2010 open and are working on a new workbook. You want to open an
existing workbook that is saved in your Documents folder.
Which two of the following methods could you use to open an existing workbook? Choose two.

A. Click the File tab and select Open.
B. Click the Office Button and select Open.
C. Use the Ctrl + E keyboard shortcut.
D. Use the Ctrl + O keyboard shortcut.
E. Use the Ctrl + N keyboard shortcut.

Answer: A,D

Explanation:

---

QUESTION 2
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 the table.
C. Click the File tab button > Print.
D. Click the File tab > Print > Print Preview.
E. Select Print Active Sheet in the Print Settings section.
F. Select Print Selected Table in the Print Settings section.
G. Select Print Selection in the Print Settings section.

Answer: B,C,F

Explanation:

---

QUESTION 3
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.

A. Use the File tab > Open function to open two more copies of the workbook.
B. Navigate to the View tab and use the New Window function to open two more copies of the
workbook.
C. Open two more copies of Excel 2010 and open two more copies of the workbook.
D. Use the Save As function to save two more copies of the workbook with different names.
E. Resize the Excel windows to display all three copies of the workbook side-by-side.
F. Use the Arrange All > Arrange Vertical function to display all three copies of the workbook sideby-
side.

Answer: B,F

Explanation:

---

QUESTION 4
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 save the workbook and share it.
One month later, you modify the workbook by adding a formula to a cell in one of the worksheets.
The formula pulls data from other worksheets in the workbook. The formula does not work as
expected. You suspect that the some of the data in the workbook is invalid.
You select some cells and want to validate the data. You navigate to the Data tab but the Data
Validation option is unavailable.
What do you need to do before you can configure data validation rules?

A. You need to inspect the workbook.
B. You need to disable the sharing.
C. You need to disable protection on the workbook.
D. You need to disable encryption on the workbook.

Answer: B

Explanation:

---

QUESTION 5
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to edit a
Sales report.
The workbook contains twelve worksheets named January through December. Each worksheet
contains a sales table listing the names of the Sales staff and the values of their sales for that
month. The format and layout of the table is identical on each worksheet.
You add another worksheet named Totals and Analysis to the Sales report workbook. You want to
create formulas in the Totals and Analysis worksheet that use references to sales values from the
tables on the other worksheets.
What type of cell reference is used to refer to the same cells on multiple worksheets within a
workbook?

A. A Tiered Cell Reference.
B. A 3-D Cell Reference.
C. A Multi-Cell Reference.
D. A Relative Cell Reference.

Answer: B

Explanation:

Click here to view complete Q&A of 70-882 exam

Best Microsoft MCTS Certification, Microsoft 70-882 Training at certkingdom.com