ECDL ECDL-ADVANCED 問題集

質問 1：
You are working on a home computer with Microsoft Office 2010 installed on it. You have created a form named FormA in a Microsoft Office Access database. You want to enable the formatting of a control which is based on the result of an expression. Mark the tab/button that you will choose to accomplish the task.

正解：

Explanation:
In order to accomplish the task, you should choose the Conditional Formatting button.


This dialog box allows you to enable the formatting of a control which is based on the result of an expression.
Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design

質問 2：
You work as an Office Assistant for OfficeWork Inc. You are creating a presentation in PowerPoint 2010. You have inserted a SmartArt graphic with the vertical bullet list layout. During the formatting in the SmartArt graphic, you have changed the shape of a bar of the SmartArt graphic. Now, you want to restore the original shape of the bar. Which of the following actions will you take to accomplish the task?
A. Right-click the SmartArt graphic, and click the Format Shape button.
B. Under SmartArt Tools, on the Design tab, in the Reset group, click the Reset Graphic button.
C. Right-click the shape, and click the Reset Shape button.
D. Under SmartArt Tools, on the Format tab, in the Shapes group, click the Change Shape button.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which of the following queries prompts a user for information to be used in the query?
A. Parameter
B. Unmatched
A parameter query prompts a user for information to be used in the query. For example, a range of dates. This type of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times.
Answer option A is incorrect. A select query is used to retrieve data from one or more tables. It is used to display the results in a datasheet.
Answer option D is incorrect. An unmatched query is a form of select query that locates records in one table that does not have related records in another table. For example, a user can use this to locate people in the customer table who do not have an order in the order table. The Find Unmatched Query wizard guides the user through the process of specifying the tables and fields to use in the query.
Answer option C is incorrect. An action query is used to update multiple records in one operation.
C. Select
D. Action
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which of the following options can be used to retrieve data from a database without directly connected to the tables in the database by using a visual basic application?
A. Form
B. Object
C. Query
D. Report
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
John is typing a document and he wants to align the text in the center of the page. What will he do to accomplish the task?
A. Use Justify.
B. Use Right Alignment.
C. Use Center Alignment.
D. Use Left Alignment.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Mark the option/button in the following image of the References tab to list the terms and topics that are discussed in a document, along with the pages on which they appear.

正解：

Explanation:
An index is a list of words arranged alphabetically at the end of a book. Index helps a reader to find the information quickly and easily. The words in the index given along with the page numbers where they occur to help the reader to quickly go to the desired word.Take the following steps to create an index:
Click the location where you want to add the index. Click on the References tab, and click the Insert Index button in the Index group.

Click a design in the Formats box to use one of the available index designs. In the Formats box, click From template, and then click Modify to specify the formatting options. Select any other index options that you want to apply. Click the OK button.

Note: It is preferable to mark the entries for the index in a document before creating an index.
Chapter: ADVANCED WORD PROCESSING
Objective: Collaborative Editing