ECDL-ADVANCED Exam Preparation Material | ECDL/ICDL Advanced

Prepare for the ECDL-ADVANCED with reliable study materials, practice questions, and key exam insights.

Prepare for the ECDL-ADVANCED ECDL/ICDL Advanced exam with CertQueen's independently developed study resources. Review important concepts, practice scenario-based questions, and use clear explanations to identify areas that require further study.

Question#1

Which of the following is a visual graphic used to represent information effectively and efficiently?

A. SmartArt
B. WordArt
C. Set Up Slide Show
D. Custom Slide Show

Explanation:
SmartArt is a visual graphic used to represent information effectively and efficiently. It is used to create designer-quality illustrations. A user can increase the emphasis of information by adding SmartArt. Though SmartArt graphics audience of a presentation can understand and recall information better than a text, it is necessary to visualize what type and layout are best for displaying data and what a user wants to convey with a SmartArt graphic.
Answer option B is incorrect. WordArt is an artistic formatting tool that is used to produce special effects. WordArt objects are drawing objects that cannot be taken as a text. It allows a user to use various stylized effects, texture, and format, such as curved, three-dimensional, rotate, and bend. Answer option C is incorrect. Take the following steps to use Set Up Slide Show: Select the slide.
Click on the Slide Show tab, and select Set Up Slide Show.



The Set Up Show dialog box appears.



Note: In the Set Up Show dialog box, you can choose the show options, show type and other performance settings.
Answer option D is incorrect. Custom Slide Show is a creative way to display a presentation. It is used to display only specific slides in the presentation. Custom Slide Show enables a user to play different shows within the same presentation.
Reference: ECDL/ICDL Exam Course Manual, Contents: "SmartArt"
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Managing Presentations

Question#2

Which of the following properties binds the object to a source from which data is to be retrieved?

A. RecordSource
B. TextFormat
C. RowSource
D. ControlSource

Explanation:
The RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be retrieved. This source can be a table or a query. When a form or a report is bound to a table or a query, the controls can be bound to a column of the table through the ControlSource property.
Answer option D is incorrect. The ControlSource property bounds a control to a field of a table. If a
control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control.
Answer option C is incorrect. The RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box.
Answer option B is incorrect. The TextFormat property of a control helps to change a text to rich text format. This helps to apply multiple formatting options for the text in a control. A user can change the format of the text to bold, italics, etc., The user can also change the font of the selected text and can apply other types of formatting.
Reference: ECDL/ICDL Exam Course Manual, Contents: "RecordSource property"
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design

Question#3

You work as a System Analyst for Company Inc. You are using Microsoft PowerPoint 2010. You have inserted a chart in the presentation. You want to insert an equation in the chart .
Which of the following will you use to accomplish the task?

A. Axis Options
B. Table Options
C. Legend Options
D. Trendlines Options
E. Error Bars Options

Explanation:
Trendlines Options comprises the Display Equation on Chart checkbox to display an equation in a chart.
Answer option E is incorrect. Error Bars Options is used to add error bars on the series of a chart.
Answer option A is incorrect. Axis Options is used to format the axis of a chart.
Answer option B is incorrect. Table Options is used to organize the table border and legend keys.
Answer option C is incorrect. Legend Options is used to set the position of a legend.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs

Question#4

Which of the following are elements of Slide Master? Each correct answer represents a complete solution. Choose all that apply.

A. Master layout
B. Edit master
C. Master background
D. Edit theme

Explanation:
Slide Master comprises a set of formatting groups.
Following are the elements of Slide Master:

Question#5

Which of the following view types allows a user to manipulate data on the form created in Access 2010?

A. Datasheet view
B. PivotTable view
C. Form view
D. PivotChart view

Explanation:
The Form view is a default view type for an Access form. It allows a user to manipulate data on the form.



Answer option A is incorrect. The Datasheet view displays the data in the table format. Answer option D is incorrect. The PivotChart view allows a user to display the data of a form as pivot charts.
Answer option B is incorrect. The PivotTable view allows a user to display the data of a form as a
pivot table.
Reference: http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design

Exam Code: ECDL-ADVANCED
Q & A: 234 Q&As         Updated:  Oct 17,2026

 

 Access Complete ECDL-ADVANCED Preparation Material

What This ECDL-ADVANCED Study Resource Helps You Do

Review Key Concepts

Review the technologies, products, processes, and practical skills covered by the current ECDL-ADVANCED exam objectives.

Practice Scenario-Based Questions

Work through independently developed questions designed to strengthen your understanding of technical scenarios and decision-making.

Identify Knowledge Gaps

Use your results and the provided explanations to find weaker areas and focus your study more effectively.

How to Use This ECDL-ADVANCED Preparation Material

Review the Exam Scope

Start by reviewing the topics covered by the ECDL-ADVANCED exam. Compare them with the official exam objectives to understand the required technologies, operational tasks, and practical skills, then identify the areas that deserve the most attention.

Practice Independently

Complete a focused set of practice questions for each topic. On your first attempt, avoid referring to notes, answers, or other study resources so that you can evaluate your current understanding more accurately.

Study the Explanations

Review the answers and explanations after completing each practice session. Understand why the correct option is appropriate for the given scenario and why the other options may be incorrect or less suitable.

Close Knowledge Gaps

Keep track of incorrect answers, unfamiliar concepts, and weaker knowledge areas. Review these topics using official documentation and practical experience, then answer the related questions again to reinforce your understanding and monitor your progress.

Independent ECDL-ADVANCED Preparation Resource

CertQueen independently develops its certification study materials for educational purposes. The practice questions are not copied from, recalled from, or presented as live or official exam questions.

CertQueen is not affiliated with, endorsed by, sponsored by, or authorized by any certification provider. Certification names, exam codes, product names, and related trademarks are the property of their respective owners and are referenced only for identification and educational purposes.

Exam Code: ECDL-ADVANCED
Q & A: 234 Q&As
Updated:  Oct 17,2026

 

 Access Complete ECDL-ADVANCED Preparation Material