77-882試験無料問題集「Microsoft Excel 2010 認定」

ページ: 1 / 10
トータル 90 問
完全版を入手する
You work as an office assistant for Brain Brigade Inc. You are creating an excel sheet. You use the
fill handle quite often to fill or copy series of values to cells. Every time you use the fill handle, the
Auto Fill button appears.

You do not want to display the Auto Fill button. You open the Excel Options window. Mark the
check box that you will clear to accomplish the task.
正解：

Explanation:
In order to accomplish the task, you will clear the Show Paste Options buttons check box in the
cut, copy, and paste section of the Advanced Excel Options window.
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"?

解説: (GoShiken メンバーにのみ表示されます)
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 quarter. You insert a table into a worksheet and populate the table with the names of the Sales people and their total sales over the last three months.
Which of the following Excel functions can you NOT do if your workbook contains a table?

You work as an Office Administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook. When completed, the workbook will be sent to other users in the Sales department, company managers and board members.
You have completed the workbook. You want to ensure that all hidden rows and columns, comments and personal information are removed from the workbook before you distribute it.
What should you do before sending the workbook?

You work as a Help Desk Technician for Tech Perfect Inc. Rick, a Sales Manager, uses Microsoft
Excel 2010 to prepare sales reports. He is creating a sales report in which he wants to compare the
relative magnitude of the targets achieved by his sales team members as shown in the image given
below:

He wants your help in formatting the table in the required way. Choose the required steps to
accomplish the task.
正解：

Explanation:
In order to accomplish the task, Rick should take the following steps:
Select the range for which the display of relative magnitude is required.
Select the Data Bars option through Home tab > Styles Group > Conditional Formatting.
The Conditional Formatting feature of Excel provides a facility to compare the relative magnitude
of values in a cell range by applying colors. According to the image shown in the question, relative
magnitude of values in a cell range is displayed by extending a band of color across the cell.
Hence, you should ask Rick to use the Data Bars option of the Conditional Formatting feature. The
Color Scales option of the Conditional Formatting feature compares the relative magnitude of
values in a cell range by applying colors from a two-or three-color set to the cells. Using this
option the same table will appear as follows:

The Format as Table option is used to configure the whole table in a certain style. It does not
provide the facility to compare values in a range of cells.
Reference:
Microsoft Excel Help, Contents: "Add, change, or clear conditional formats"
You work as the Finance Manager at ABC.com. It is the end of the financial year and you are auditing the accounts for the last year. You have imported the records from last year's company bank statements into a Microsoft Office Excel 2010 workbook.
You want to list all payments to a partner company named Weyland Industries with the category name of Services.
How can you configure the workbook to display only the records that contain Weyland Industries and Services?

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?
正解：

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.

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?

You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook. The workbook was created by the Sales Manager who has asked you to fill in the sales figures in the table.
When you click in one of the cells, you see a message as shown below.

What function did the Sales Manager use to configure the alert message?

ページ: 1 / 10
トータル 90 問