ECDL/ICDL Advanced (ECDL-ADVANCED) Free Practice Test

Question 1

Alan is a student of DFH Public School. He is creating a project report using Microsoft Excel XP. In the process of creating a project, he needs to frequently open a file that he has already created. Therefore, he wants to assign this file as a hyperlink to the 'Research' button on the Standard toolbar. Which of the following steps will he take to accomplish the task?

A. Choose Tools > Options from the menu bar.
Click the AutoFormat As You Type tab.
Clear the Internet and network paths with hyperlink check box.

B. Choose Tools > Customize
Right-click on the toolbar button, and then choose Assign Hyperlink > Open from the shortcut menu.
Select the file to be linked to.

C. Choose Format > Style
Select Hyperlink from the Style name box.
Click the Modify button.
Select the required formatting.

D. Right-click on the toolbar button, and then choose Hyperlink from the shortcut menu. Select the file to be linked to.

Correct Answer: B

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

Question 2

You work as an Office Assistant for Company Inc. You are creating a presentation named Sales. Now you want to include some slides from a presentation named Photo Album.pptx. Mark the option/button in the following image of the Home tab to insert the slides from another presentation.

Correct Answer:

Explanation:
Take the following steps to reuse slides from another presentation file:
Open the presentation from which a user wants to add a slide to.

Click the arrow below New Slide on the Home tab in the Slides group. Select Reuse Slides.

Click the Browse button drop-down list in the Reuse Slide pane, and select the Browse File option.

The Browse dialog box opens. Locate and click the presentation file that contains the slide that a user wants, and then click the Open button.

PowerPoint displays thumbnails of the slides from the presentation that a user has selected in the Reuse Slides pane. In order to see a larger version of the slide's contents, rest the pointer on a thumbnail.

In order to add a single slide, click the slide. In order to add all of the slides, right-click any slide, and then select Insert All Slides.

Reference:
http://office.microsoft.com/en-us/powerpoint-help/use-slide-libraries-to-share-and-reuse-powerpoint-slides-HA010338394.aspx Chapter: PRESENTATION, ADVANCED - LEVEL Objective: Slides

Question 3

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

B. She selects the text box and delete it.

C. She selects the slide and starts typing.

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

Correct Answer: D

Question 4

Jasmine is creating a presentation on employee form of Luxury.Inc. She wants the text of the textbox to rotate to one eighty degree. Which of the following steps will she take to accomplish the task?

A. Right-click on the textbox, select the Format Shape option, and then select the 3D format option.
The Textbox option comprises the Text Direction option to rotate the textbox to one eighty degree.
Answer option D is incorrect. The 3D Format option is used to rotate a textbox on a slide.
Answer option C is incorrect. The 3D Rotation option is used to organize the 3D format of a textbox.
Answer option A is incorrect. The Shadow option is used to organize a textbox for its transparency, size, angle, distance, etc.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Relating Information

B. Right-click on the textbox, select the Format Shape option, and then select the Textbox option.

C. Right-click on the textbox, select the Format Shape option, and then select the Shadow option.

D. Right-click on the textbox, select the Format Shape option, and then select the 3D Rotation option.

Correct Answer: B

Question 5

Which of the following options will you use to recognize the changes made by another person to your document?

A. Add comment

B. Make changes in another new document

C. Insert caption

D. Enable Track Changes

Correct Answer: D

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

Question 6

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?

A. Table of Contents

B. Table of Pictures

C. Table of Figures

D. Table of Authorities

Correct Answer: D

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

Question 7

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

B. Arrange All

C. Slide Sorter

D. Cascade

Correct Answer: B,D

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

Question 8

Which of the following are the tabs used for aligning a document?
Each correct answer represents a complete solution. Choose all that apply.

A. Judgment

B. Left-aligned

C. Bar

D. Center-aligned

Correct Answer: B,C,D

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

Question 9

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Information in Microsoft Office Access 2007. The database contains a table named Employees with the following fields:
Employee Name
Employee ID
Department
Salary
You want to view a list of fields in the table. In which of the following views will you open the table?

A. Design

B. Layout

C. Pivot Table

D. Datasheet
Explanation: In order to view a list of fields in the table, you must open the table in the Design view.The Design view of a table displays its fields and datatypes. New fields can be added to the table and assigned to a datatype. A user cannot insert data in this view. The datatype of a field can be formatted and other table properties such as field size, validation rule, etc., can be set for the field.

The datatype of the new field is defined by the data inserted in it by a user. The default datatype is text. The datatype can be explicitly assigned to a field through the Datatype list in the Data type and Formatting group on the DataSheet tab.

Answer option C is incorrect. You can use Layout view to make changes in the design while you view data in a form or report Answer option B is incorrect. The PivotTable view of a table can be used to display the data of a table in the desired format. This view cannot be used to create or delete a field or modify its properties. The data can be filtered according to fields. When the PivotTable view is opened, a blank work area is displayed and the columns of the table are displayed in the Pivot Table Field List window. A user has to drag and drop the fields to view the desired result.

Correct Answer: A

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

Question 10

Which option of Freeze Panes will you use to freeze a row in a worksheet?

A. Unfreeze Panes

B. Freeze Selected Row

C. Freeze Top Row
Explanation: Take the following steps to freeze a row in a worksheet:
Go to the Freeze Panes drop down menu in the View tab.

Select the Freeze Top Row option in the Freeze Panes drop down menu.

After completing the above steps, you will see that the row is not moving while scrolling the worksheet.

Answer options A, B, and C are incorrect. These options cannot be used for this purpose. Reference: ECDL/ICDL Exam Course Manual, Contents: "Freeze Panes" Chapter: ADVANCED SPREADSHEETS Objective: Editing

D. Freeze Column

Correct Answer: C

Question 11

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.

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

B. Click the Edit Relationships button in the Home group.

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

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

E. Select the Enforce Referential Integrity check box.

Correct Answer: A,C,D,E

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

Question 12

You work as a Support Analyst for Soft Well Inc. You create a presentation for a business meeting. The business meeting is going to be held between you and some Chinese associates. You write some information on the slides of the presentation in English language. After writing the concepts, you want to use the Chinese language instead of English language, so that it can be better understandable by the meeting attendees. Mark the appropriate sign to accomplish the task.

Correct Answer:

Explanation:
By using the Translate option under the proofing group, a user can translate the text to the Chinese language. In order to change the language, you have to just click the Translate option. The Research Task Pane will open, then specify the language and click the Go button as shown in the following image:

The Spelling option is used to check the spelling of the selected text. The Thesaurus option is used to suggest the synonym of a selected text. The Language option is used to check the spelling and grammar of the selected text. The Research option is used to open the Research Task Pane to search a selected text through reference materials, encyclopedias, etc.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Design Considerations

Welcome to TestSimulate

ECDL/ICDL Advanced (ECDL-ADVANCED) Free Practice Test