ECDL-ADVANCED Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

with the appropriate term.

See Below Explanation:

Mail Merge is use to quickly create multiple letters, e-mail messages, mailing labels, envelopes, and a directory. It uses two files for creating a document. It is use to create a set of documents, such as letters, in which the information contained in the letter is the same but the address of each person is different.

Chapter: ADVANCED WORD PROCESSING

Objective: Enhancing Productivity

Correct : A

Chapter: ADVANCED WORD PROCESSING

Objective: Enhancing Productivity

Mark Question:

Start a Discussions

Submit Your Answer:

AMail Merge

0 / 1500

Question 3

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

ASmartArt

BWordArt

CSet Up Slide Show

DCustom 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.

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.

Correct : A

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Managing Presentations

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASmartArt

BWordArt

CSet Up Slide Show

The Set Up Show dialog box appears.

0 / 1500

Question 4

You work as System Analyst for Company Inc. You are creating a presentation in PowerPoint 2010. The presentation comprises various controls. You want to create a text box that comprises two columns. Which of the following actions will you take to accomplish the task?

ARight-click the text box > select the Format Shape option.

BClick the Format tab > Align button.

CClick the Home tab > Layout button.

DClick the Format tab > Edit Shape button.
Explanation:
A user can add columns in a text box by using the Format Shape option. Take the following steps to create columns in a text box:
Select the text box. Right-click the text box and select the Format Shape option.

The Format Shape dialog box appears. Click the Text Box pane.

Click the Columns button.

The Columns dialog box appears. Specify the number of columns in the Columns list.

Answer option B is incorrect. The Align button is used to align the edge of the selected object.
Answer option C is incorrect. The Layout button is used to change the layout of the selected slide.
Answer option D is incorrect. The Edit Shape button is used to change the shape or edit the wrap points of the shape.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ARight-click the text box > select the Format Shape option.

BClick the Format tab > Align button.

CClick the Home tab > Layout button.

The Format Shape dialog box appears. Click the Text Box pane.

Click the Columns button.

The Columns dialog box appears. Specify the number of columns in the Columns list.

0 / 1500

Question 5

Which of the following statements will you use to eliminate duplicate contents in a table?

ASELECT...DISTINCT

BSELECT...WHERE

CSELECT...TOP

DSELECT...ALL
Explanation:
You will use the following statement to eliminate duplicate contents in a table:
SELECT...DISTINCT
Answer option D is incorrect. The SELECT...ALL statement is used to display all rows from a table, including duplicate rows.
Answer option C is incorrect. The SELECT...TOP statement is used to display the first set of rows specified in the TOP clause.
Answer option B is incorrect. The SELECT...WHERE statement is used to filter the data in a table.
Reference: ECDL/ICDL Exam Course Manual, Contents: 'SELECT... DISTINCT'
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASELECT...DISTINCT

BSELECT...WHERE

CSELECT...TOP

0 / 1500

Master ECDL-ADVANCED Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: