ECDL-ADVANCED Exam Questions Instant Access

Question 1

You work as an Office Assistant for Company Inc. You are creating some presentations in PowerPoint 2010. You are using a specific form format for creating each and every presentation. You want to automate the series of steps to create the form and use it for creating the presentations. Which of the following will you use to accomplish the task?

ACustom Animation

BMacro

CHyperlink

DAction

Answer : B

A macro is a tool that is used to record the steps to perform a particular task. It is not available in Microsoft Office PowerPoint 2010, instead a user can use Visual Basic for Applications (VBA) to create or edit a macro. VBA is a macro-language version of Microsoft Visual Basic, which is used to program Microsoft Windows-based applications. A user has to click the Macros option on the Developer tab to use the Macro tool, as shown in the following image:

Question 2

Which of the following are the predefined quick styles for formatting of documents?

Each correct answer represents a complete solution. Choose all that apply.

AParagraph

BHeader

CLinked

DCharacter

Answer : A, C, D

Following are the predefined quick styles for formatting of documents:

Paragraph styles: These styles can be applied to entire paragraphs, such as headings.

Character styles: These styles can be applied to words.

Linked styles: These styles can be applied to either paragraphs or words.

What are Quick Styles?

Quick Styles are galleries with a range of styles based on the current theme. These are combinations of different formatting options and are displayed in a thumbnail in the various Quick Style galleries. There are Quick Styles galleries for text, tables, charts, SmartArt, Word Art and more.

Answer option B is incorrect. It is not a valid quick style for formatting.

Chapter: ADVANCED WORD PROCESSING

Objective: Formatting

Question 3

You work as an Office Assistant for OfficeWork Inc. You are creating a presentation through PowerPoint 2010. You want to use both portrait and landscape orientations in the presentation. Which of the following actions will you take to accomplish the task?

ABreak the presentation into two presentations, apply a different orientation, and then create a hyperlink between them.

BBreak the presentation into two presentations, and then use the Layout button of the Slides group.

CSet the orientation of each slide by using the Page Setup button.

DSet the orientation of each slide by using the Slide Orientation button.

Answer : A

In a Microsoft Office PowerPoint 2010 slide, you can use only one orientation in a presentation, i.e., either landscape or portrait. To use both portrait and landscape orientations in a presentation, a user has to link two presentations to display both the portrait and landscape slides in what appears to be one presentation.

In order to create a link from the first presentation to the second and the second to the first, a user has to take the following steps:

Select the text or object that he wants to link to the other presentation. Click on the Insert tab > Links group > Action option.

On either the Mouse Click tab or the Mouse Over tab, click on the Hyperlink to drop-down list and select the Other PowerPoint Presentation option.

The Hyperlink to Other PowerPoint Presentation dialog box appears. Locate and click the second presentation, and then click the OK button.

In the Hyperlink to Slide dialog box, under Slide title, click the slide that a user wants to link to, and then click the OK button twice.

Answer options D and C are incorrect. By using the Slide Orientation and Page Setup buttons, you cannot apply the orientation and page settings for specific slides. They are used to set the orientation and page settings of the entire presentation.

Answer option B is incorrect. The Layout button is used to change the layout of the selected slides. By default, the orientation of slide layouts is in landscape.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Slides

Question 4

Which of the following types 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?

ACrosstab query

BAction query

CSelect query

DParameter query
Explanation:
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 C is incorrect. A select query is a simple type of query that is commonly used in Microsoft Office Access 2007. This query retrieves data from one or more tables and displays the results in a datasheet. A user can use a select query to group records and calculate sum, counts, averages, and other types of totals. The user can also work with the results of a select query in the Datasheet view to update records in one or more related tables at the same time.
Answer option B is incorrect. An action query is used to update multiple records in one operation. It is a form of select query that performs an action on the results of the selection process. There are four types of action queries available in Microsoft Office Access 2007, which are as follows:
Delete queries: A delete query allows to delete records from one or more tables.
Update queries: An update query allows to modify fields. This is used to update a field with an expression or data from another table.
Append queries: An append query allows to add records from one or more tables to the end of one or more other tables.
Make-table queries: A make-table query allows to create a new table from all or part of the data in one or more tables.
Answer option A is incorrect. A crosstab query is a powerful analysis tool used to see the relationship of data between two fields. It calculates and restructures data for easier analysis. A user can use a crosstab query to calculate a sum, average, count, or other type of total for data that is grouped by two types of information- one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query's calculation. This view is just like a spreadsheet with unique values of one field as rows, unique values of another field as columns, and the summary of another field as the cells in the matrix.

Answer : D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

Question 5

Which of the following is a list of the references in a legal document, such as cases, statutes, and rules, along with the page numbers on which the references appear?

ATable of Authorities

BTable of Contents

CTable of Pictures

DTable of Figures

Answer : A

Table of Authorities is a list of the references in a legal document, such as cases, statutes, and rules, along with the page numbers on which the references appear.

Answer option B is incorrect. Table of Contents is a list of chapters and their sections of a book or a document. Use the list along with the respective page numbers of the chapters and their sections for easy navigation.

Answer option D is incorrect. Table of Figures is a list of the captions for pictures, charts, graphs, slides, or other illustrations in a document. Table of Figures given along with the page numbers on which the captions appear.

Answer option C is incorrect. It is not a valid type of list.

Chapter: ADVANCED WORD PROCESSING

Objective: Collaborative Editing

Question 6

Which of the following steps will you take to enforce referential integrity for an existing relationship?

Each correct answer represents a part of the solution. Choose all that apply.

ASelect the Enforce Referential Integrity check box.

BClick the Edit Relationships button in the Tools group.

CClick the join line of the relationship which you want to change.

DClick the Edit Relationships button in the Home group.

ESelect the Cascade Update Related Fields and Cascade Delete Related Records check boxes if it is required.

Answer : A, B, C, E

Take the following steps to enforce referential integrity for an existing relationship:

1. Click the join line of the relationship which you want to change.

2. Click the Edit Relationships button in the Tools group.

3. Select the Enforce Referential Integrity check box.

4. Select the Cascade Update Related Fields and Cascade Delete Related Records check boxes if it is required.

5. Click OK.

Answer option D is incorrect. It is not a valid step to enforce referential integrity for an existing relationship. Reference: ECDL/ICDL Exam Course Manual, Contents: 'Referential integrity'

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question 7

Which of the following contains the names of the fields involved in the query and the criteria used to select records?

ANavigation Pane

BTitle bar

CQBE grid

DQuick Access Toolbar

Answer : C

The QBE grid contains the names of the fields involved in the query and the criteria used to select records. In the QBE grid, each column consists of information about a single field from a query or table that is included in the upper pane. The image of the QBE grid is given below:

Answer option D is incorrect. The Quick Access Toolbar in MS Access 2010 is a customizable toolbar which is displayed in the title bar of the Database window. It has a set of commands or functions (save, undo/redo, and print) that are independent of the tab on the ribbon currently displayed in MS Access. The Quick Access Toolbar can be moved from one of the two possible locations. A user can add any Access command as a button to the Quick Access Toolbar.

Answer option A is incorrect. The Navigation Pane is displayed on the left side in a new or existing database. The pane contains different database objects such as tables, queries, forms, reports, macros, etc. The database can be opened through the pane in different modes such as datasheet view, design view, and layout view. A user can use the navigation Pane to show or hide the database objects.

Answer option B is incorrect. The title bar is an area on the Database Window. It is used to show the name of the active database object.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Questions