ECDL ECDL-ADVANCED 問題集

質問 1：
Alan works as a Sales Manager for Star Inc. He is creating a report using Microsoft XP to put it on the company's Website. The report contains several hyperlink text assigned with different document destinations. By default, the color of hyperlink text is blue but according to the company's convention it should be dark red. Therefore, he wants to change the color of all hyperlink text to dark red. Choose the option that he will use to accomplish the task.

正解：

Explanation:
The Style option on the Format menu will open the Style dialog box. This dialog is used to change the appearance of hyperlink text in a current workbook.
Perform the following steps in the Style dialog box to change the appearance of hyperlink text:
In the Style dialog box, select Hyperlink style in the Style name box, and then click the Modify button. NOTE: Select Followed Hyperlink style in the Style name box to change the appearance of hyperlink text when they have been clicked to find the linked document or location.

The Format Cells dialog box will appear. Select the formatting that has to be changed to hyperlink text, and then click the OK button to close the Format Cells dialog box.

In the Style dialog box, under the Style Includes, clear or select the check boxes in front of the formats according to the requirement, and then click the OK button.
NOTE: Click the Add button, and then the Close button to create a style without applying it.

NOTE: When changes are made to the Hyperlink or Followed Hyperlink styles, they will be applied for all hyperlinks in the current workbook.
NOTE: The Hyperlink and Followed Hyperlink styles appear in the Style name box if a hyperlink text has already been created in a workbook.
Reference:
Chapter: ADVANCED SPREADSHEETS
Objective: Data Handling

質問 2：
You work as an Office Assistant for Company Inc. You are creating a presentation in which you have applied the layout and you are using the normal view. Now you have made some changes in the layout and you want to save it with a name so that it can be used in the future. For this, you have to switch from the normal view to another view. Mark the view in the following image of the View tab to rename the layout.

正解：

Explanation:
When you add placeholders to a layout and if the content in those placeholders changes the purpose of the layout, you'll want to rename the layout. Take the following steps to rename a layout:
Click on the View tab. In the Master Views group, click Slide Master.

Right-click the layout thumbnail that you want to rename in the pane that contains the slide master and layout thumbnails.

The Rename Layout dialog box opens. In the Layout name box, enter the new name of the layout, and then click the Rename button.

On the Slide Master tab, click Close Master View in the Close group.

Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides

質問 3：
You have a table named Products created in Microsoft Access 2010. You want to calculate the total price of all products. Choose and re-order the steps that you will take to add the Total row in the table.


正解：

1 - Open the table in the Datasheet view.
2 - Click the Home tab.
3 - Click the Totals button in the Records group.
4 - In the Totalrow, choose the Sum operation.
Explanation:
Take the following steps to add the Total row in a table:
Open the table in the Datasheet view.

Click the Totals button in the Records group on the Home tab.

In the Total row, choose the operation required to perform.

Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

質問 4：
You work as an Office Assistant for Company Inc. You are preparing a presentation in PowerPoint 2010. You have inserted a chart in your presentation. After creating the presentation, you want to change the layout of the presentation as shown in the following format:


正解：

Explanation:
A user can change the wall and plot color by using the Layout button of the Chart Tools tab. Take the following steps to apply a border on a chart:
1. Select the chart.
2. The Chart Tools tab will be displayed containing the Design, Layout, and Format tabs.
3. Click on the Layout tab.
4. Click the Chart Wall drop-down list. Select the More Wall Options option.
5. The Format Walls dialog box appears.
6. Select the color to be applied.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs

質問 5：
Which of the following steps will you take to add an AutoCorrect entry?
A. Click the AutoCorrect Options on the Data tab.
B. Click the AutoCorrect Options on the Format.
C. Click the PowerPoint Options on the Insert and AutoCorrect Options button.
D. Click the PowerPoint Options on the Microsoft Office button and AutoCorrect Options button.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which of the following datatypes cannot be filtered by using common filters?
Each correct answer represents a complete solution. Choose two.
A. AutoNumber
Explanation: The following datatypes cannot be filtered by using common filters:
OLE Object: The OLE Object datatype is used to attach files and add binary data to a table. This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc.
Calculated Field: The Calculated Field datatype is used to store the results of a calculation. The calculation should refer to other fields created in the same table. In order to create the calculation, a user can use the Expression Builder that provides the use of IntelliSense and an easy way to access expression values.
Answer options A and D are incorrect. These datatypes can be filtered by using common filters. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink.
The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table. The increment can be changed through the New Values property. This property has the following two values:
Increment
Random
B. Hyperlink
C. OLE Object
D. Calculated Field
正解：C,D
解説: (Topexam メンバーにのみ表示されます)