Name: ECDL ADVANCED WORD PROCESSING
Brand: ValidExamDumps
SKU: ECDL-ADVANCED
Price: 20 USD
Availability: InStock
Rating: 4.8 (148 reviews)

Free ECDL ECDL-ADVANCED Exam Actual Questions

The questions for ECDL-ADVANCED were last updated On Apr 21, 2025

At ValidExamDumps, we consistently monitor updates to the ECDL-ADVANCED exam questions by ECDL. Whenever our team identifies changes in the exam questions,exam objectives, exam focus areas or in exam requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these actual questions, our customers can successfully pass the ECDL ADVANCED WORD PROCESSING exam on their first attempt without needing additional materials or study guides.

Other certification materials providers often include outdated or removed questions by ECDL in their ECDL-ADVANCED exam. These outdated questions lead to customers failing their ECDL ADVANCED WORD PROCESSING exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions, guaranteeing their presence in your actual exam. Our main priority is your success in the ECDL-ADVANCED exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.

Question No. 1

Which of the following sections are included in the default layout of the Report Design view?

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

APage Header

BGroup Header/Footer

CPage Footer

DDetail
Explanation:
The following sections are included in the default layout of the Report Design view:
Page Header: It is displayed at the top of each page. Page Header includes a logo, column heading, page number, etc.
Detail: It displays the data and their associated labels that are included for the table or query fields added to the report.
Page Footer: It is displayed at the bottom of each page. Page Footer includes a report name, date and time, coding, page number, etc.
Answer option B is incorrect. It is not a valid section included in the default layout of the Report Design view.

Show Answer

Correct Answer: A, C, D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Report Design

Question No. 2

Which type of formatting is responsible for the internal look of a document, such as shading, borders, numbering, and bullets?

AStructural

BDecorative

CIndentation

DAlignment
Explanation:
Following are the two formatting types:
Structural Formatting: It is responsible for the overall structure of the document, such as alignment, indentation, and tabs.
Decorative Formatting: It is responsible for the internal look of the document, such as shading, borders, numbering, and bullets.
Answer options C and D are incorrect. These are not responsible for the internal appearance of the document because an indentation is used for indenting the first line of paragraphs and the alignment is used to set the alignment of the document.

Show Answer

Correct Answer: B

Chapter: ADVANCED WORD PROCESSING

Objective: Formatting

Question No. 3

Which of the following views is a simplified version of Slide Show view, which appears in a window rather than full-screen?

AReading View

BSlide Sorter

CNotes Page

DSlide Show

Show Answer

Correct Answer: A

Following are the views that exist in PowerPoint:

* Normal: It is a combination of various resizable panes, so that the presentation can be shown in multiple ways at once. However, the default view is Normal.

* Slide Sorter: It is a light-table-type overhead view of all the slides in the presentation, laid out in rows, suitable for big-picture rearranging.

* Notes Page: It is a view with the slide at the top of the page and a text box below it for typed notes.

* Slide Show: It is the view that can be used to show the presentation onscreen.

* Reading View: It is a simplified version of the Slide Show view, which appears in a window rather than full screen.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Managing Presentations

Question No. 4

Which of the following are the types of action queries?

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

AUpdate

BDelete

CInsert

DAppend
Explanation:
An action query is used to update multiple records in one operation.
Following are the four types of action queries:
Delete queries: A delete query is used to delete records from one or more tables.
Update queries: An update query is used to modify fields. It is used to update a field with an expression or data from another table.
Append queries: An append query is used to add records from one or more tables to the end of one or more other tables.
Make-table queries: A make-table query is used to create a new table from all or part of the data in one or more tables.
Answer option C is incorrect. It is not a valid type of action query.

Show Answer

Correct Answer: A, B, D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question No. 5

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.

Show Answer

Correct Answer: D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design