ECDL/ICDL Advanced - ECDL-ADVANCED Exam Practice Test

Question 1

You are creating a presentation and added a picture from a file in it. Now, you want to change the border color of the picture to light blue, as shown in the following image:

Correct Answer:

Explanation:
The Picture Styles group comprises the Picture Border button to change the color of the picture border. Take the following steps to add border to an image:
Select an image.
Click the Format tab, and then click the Picture Border button.
The Picture Border drop-down list appears. Specify the color settings to be applied. Chapter: PRESENTATION, ADVANCED - LEVEL Objective: Pictures, Images, Drawn Objects

Question 2

Which of the following are the types of action queries?
Each correct answer represents a complete solution. Choose all that apply.

A. Delete

B. Update

C. Insert

D. Append
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.

Correct Answer: A,B,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

Which of the following steps will you take to apply the shadow effect to a text?

A. Design > Font group > Shadow icon

B. Home > Font group > Shadow icon

C. Animations > Font group > Shadow icon

D. Insert > Font group > Shadow icon

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

Mark the option/button in the following image of the Layout tab to display a set of related data points that are plotted in a chart.

Correct Answer:

Explanation:
A data series is a set of related data points that are plotted in a chart. It has a unique color or pattern in the chart and is represented in the chart legend. A user can plot one or more data series in a chart. Pie charts have only one data series. A user can specify where a specific data series appears within a chart.Take the following steps to display the data series of a chart:
1. Select the chart.
2. The green Chart Tools contextual tab appears at the top of the PowerPoint window.
3. Click on the Layout tab under Chart Tools. In the Labels group, click the Axis button.
4. The Axis drop-down list opens. Select the desired option to be applied.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs

Question 5

Jasmine is creating a presentation. When she selects a textbox and starts typing, the existing text is not replaced with what she has typed. Which of the following is the most likely cause of the issue?

A. She selects the slide and starts typing.

B. She selects the border of the text box and starts typing.

C. She selects the text box and delete it.

D. She selects the text of the text box and starts typing.
Explanation: Whenever she selects the border of a text box, she will not be able to write a text in it. Answer option D is incorrect. When she selects the text of the text box, she will be able to overwrite the existing text.
Answer option C is incorrect. When she selects the slide, she will be able to apply various formats and animations.
Answer option B is incorrect. When she deletes the text box, the selected text will be automatically deleted.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Design Considerations

Correct Answer: B

Question 6

You have created a form named Details in Microsoft Office Access 2010.You want to add new elements, change the header/footer, and apply a new theme to the form. Which of the following tabs will you choose to accomplish the task?

A. Element
Explanation: In order to accomplish the task, you should choose the Design tab lying in Form Layout Tools. You can add new elements, change the header/footer, and apply themes to the form by using the Design tab.

Answer option B is incorrect. The Arrange tab has various layout options.
Answer option C is incorrect. The Format tab is used to change the color and font of text and the style of gridlines around the fields. It also includes a logo and various formatting options. Answer option D is incorrect. This tab is not displayed in Form Layout Tools.

B. Format

C. Design

D. Arrange

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

You work in an office and you are assigned the task of preparing a document. You insert a table in the document and your document has a number of objects. You want to use gridlines for proper alignment between objects. For this, you have to display gridlines of the table. However, clicking the Borders button on the Design tab will not help in displaying the gridlines. Which of the following is the cause of the issue?

A. You are viewing the document in Print Layout view.

B. You are viewing the document in a Web browser.

C. You are viewing the document marked as final.
Explanation: Gridlines are used to show cell boundaries of a table on the screen. These gridlines will display where the table does not have borders. They appear only on the screen where they are not printed. The user cannot see the changes wherever the gridlines are behind the borders if you hide the gridlines in a table that has these borders by default. All tables have black 1/2 point, single-line, solid-line borders that are printed. In order to view the gridlines, remove the borders. If the user is viewing a document in the Web browser, gridlines will never be visible.
Answer options C and A are incorrect. You can view gridlines of a table in the Draft and Print Layout views. The Draft view is used to view the document as a draft to allow a user to quickly edit the text. Headers and footers are not visible in this view. The Print Layout view is used to view a document as it would appear on a printed page.
Answer option D is incorrect. The gridlines of a table are not affected by the use of the mark as final feature. Answer options C and A are incorrect. You can view gridlines of a table in the Draft and Print Layout views. The Draft view is used to view the document as a draft to allow a user to quickly edit the text. Headers and footers are not visible in this view. The Print Layout view is used to view a document as it would appear on a printed page.
Answer option D is incorrect. The gridlines of a table are not affected by the use of the mark as final feature.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting

D. You are viewing the document in Draft view.

Correct Answer: B

Question 8

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

A. PivotChart view

B. Datasheet view

C. Form view

D. PivotTable view

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 9

Which of the following is a view in Microsoft Word 2010 that provides an easy way to move through a document and the drag and drop functionality to move sections in a document?

A. Navigation Pane

B. Reading Pane

C. Outline View

D. Draft View

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 10

Which of the following options are available in PowerPoint to arrange multiple windows?
Each correct answer represents a complete solution. Choose all that apply.

A. Slide Sorter

B. Cascade

C. Normal

D. Arrange All

Correct Answer: B,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 11

Which of the following steps will you take to ensure that field controls can be neither edited nor deleted?

A. Go to Protect Document in the Tools tab.

B. Go to the Properties option in the Developer tab and check both options of Locking.

C. Select the Protect option in the View tab and check the Protection check box.

D. Select the Protect option in the Insert tab and check the Protection check box.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

ECDL/ICDL Advanced - ECDL-ADVANCED Exam Practice Test

Latest Update

Useful Links

Contact Us