77-882 試験問題を無料オンラインアクセス

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 using the Cell Styles function on the Home tab.
• B.You should consider using the Custom Views function on the View tab.
• C.You should consider pressing Ctrl + A and configuring the required formatting options.
• D.You should consider selecting all cells and selecting the Format option on the Home tab.

You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
You have data on three worksheets in the financial report. A formula in a cell on the third worksheet pulls data from cells in the first and second worksheets in the workbook.
You want to view the value of the cell containing the formula while you make changes to the values of cells in the first worksheet.
How can you view the value of the cell containing the formula on Sheet3 while working on Sheet1?

• A.You should consider making use of the Watch Window function on the Formulas tab.
• B.You should consider making use of the Lookup and Reference function on the Formulas tab.
• C.You should consider making use of the New Window function on the View tab.
• D.You should consider making use of the Show Formulas function on the Formulas tab.

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 need to restrict the type of information that users can enter into the workbook. You want to ensure that customer's names are spelt correctly by using a list for users to select from and you want to limit the cells that users can enter numbers into. You also want users to be presented with a message when they enter invalid data.
Which function of Excel should you use?

• A.You should use the Protect Workbook function on the Review tab.
• B.You should use the Data Consolidation function on the Data tab.
• C.You should use the Data Validation function on the Data tab.
• D.You should use the Format function on the Home tab.

You have upgraded your Excel 2007 to Excel 2010. You want to personalize your Excel
environment through the Excel Options window given below:

You are unable to find the Office button. Choose the steps you will take to accomplish the task.

正解：

Explanation:
In order to accomplish the task, you will have to take the following steps:
Click on the File menu.
Click Option to open the Excel Option window.
A major change in Office 2010 from Office 2007 is elimination of the Office button. Instead, it
incorporates a Backstage View for personalizing the office environment. Backstage View can be
evoked by clicking the File menu button.

Reference:
Changes in Excel 2010

You work as an Office Assistant for Media Perfect Inc. You are creating a report in a workbook in
Microsoft Excel 2010. You have to insert a Venn-diagram in a worksheet. Mark the option you
will choose to accomplish the task.

正解：

Explanation:
In order to accomplish the task, you will have to choose the SmartArt option. Through the
SmartArt option in Office 2010, you can insert complex graphics, such as a Venn-diagram in a
document. SmartArt is a group of easily editable and formatted diagrams provided in Microsoft
Excel. There are 115 preset SmartArt graphics layout templates, such as List, Process, Cycle,
Hierarchy, etc. SmartArt graphics can automatically change their colors, fonts, and effects to
match the document's theme. The SmartArt option appears under the Insert tab.

Each SmartArt graphic maps the text outline onto the graphic and automatically resizes the graphic
for best fit. A number of quick styles can be used for each graphic shapes. Users can also manually
change SmartArt graphics colors, fonts, and effects to match the document's theme. Reference:
Microsoft Excel Help, Contents: "Learn more about SmartArt graphics"