ECDL-ADVANCED Exam Practice Test Instant Access

Question 1

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named Sales. He has to link a text file to the Access database. He clicks the office button and opens the text file. The file is displayed in the Link Text Wizard. What will happen when James clicks the Finish button in the wizard?

AData of the text file is appended to an existing table and gets affected if there is a change of data in the text file.

BThe data is copied into a new table and is not affected if there is a change of data in the text file.

CA new database will be created and a linked table will be created in the database.

DA linked table will be created in an existing database.

Answer : C

When James opens a text file in Microsoft Access, a new database is created and a linked table is created in the new database after the Finish button is clicked in the wizard. The database is created with the same name as that of the text file. The wizard provides an option of renaming the table. The default name of the table is same as that of the text file.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data

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

Answer : B

Chapter: ADVANCED WORD PROCESSING

Objective: Formatting

Question 3

Which of the following datatypes cannot be filtered by using common filters?

Each correct answer represents a complete solution. Choose two.

AHyperlink

BOLE Object

CCalculated Field

DAutoNumber
Explanation:
The following datatypes cannot be filtered by using common filters:
OLE Object: The OLE Object datatype is used to attach files and add binary data to a table. This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc.
Calculated Field: The Calculated Field datatype is used to store the results of a calculation. The calculation should refer to other fields created in the same table. In order to create the calculation, a user can use the Expression Builder that provides the use of IntelliSense and an easy way to access expression values.
Answer options A and D are incorrect. These datatypes can be filtered by using common filters.
The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink.
The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table. The increment can be changed through the New Values property. This property has the following two values:
Increment
Random

Answer : B, C

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Report Design

Question 4

You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You added a photo album in it. Now, you want to add captions to all the photographs. To achieve the desired result, you have to check the Captions below All Pictures check box of the Edit Photo Album dialog box. However, the check box is disabled. Which of the following is the cause of the issue?

AYou have increased the brightness of the picture.

BYou have selected the Fit to Slide layout option in the Picture Layout list.

CYou have selected the 2Pictures layout option in the Picture Layout list.

DYou have selected a Rounded Rectangle frame shape.
Explanation:
If the Fit to slide layout option is selected in the Picture Layout drop-down list of the Album Layout section, the Captions below All pictures check box is unavailable and greyed out.

Answer option D is incorrect. The Captions below All Pictures check box will not be affected by the frame of the picture.
Answer option C is incorrect. If a user selects the 2Pictures layout option, the Captions below All Pictures check box will be enabled.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Pictures, Images, Drawn Objects

Answer : B

Question 5

Which option of Paste Special is used to link cells in different worksheets?

AFormat Link

BPaste Link

CPaste Format

DLink Cell
Explanation:
The Paste Link button is used to link cells in different worksheets.
Take the following steps to link cells in different worksheets:
Select and copy the cells that you want to link to the other worksheet.

Select the desired destination in another worksheet.

Click the Paste drop down icon, select the Paste Special option, and click the Paste Link button.

If you take a look at the resulting formula, it will include the filename, sheet name, and cell reference to the original data.

Answer options A, D, and C are incorrect. These are not valid options of Paste Special.
Reference: ECDL/ICDL Exam Course Manual, Contents: 'Paste Link'
Chapter: ADVANCED SPREADSHEETS
Objective: Data Handling

Answer : B

Question 6

You have created a database named Sales. The database consists of a table named Employees. You want to ensure that all names of the employees should be displayed while filling a form. Which of the following controls will you use to accomplish the task?

ALabel

BTextbox

CCombobox

DListbox

Answer : C, D

You will use the listbox and combobox controls. When these controls are bound to a column of a table, all data of that column is displayed in these controls. You cannot edit or delete the data from these controls. You can only view the data.

Answer option B is incorrect. The textbox control is bound to a column but it displays only one record at a time. According to the scenario, you want to ensure that all names of the employees should be displayed and the textbox control will not accomplish this task.

Answer option A is incorrect. The label control does not have the ControlSource property so it cannot be bound to any column of any table. A label is used to provide a name to a bound control. Reference: ECDL/ICDL Exam Course Manual, Contents: 'Form'

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

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?

AYou are viewing the document in Print Layout view.

BYou are viewing the document in a Web browser.

CYou are viewing the document in Draft view.

DYou 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

Answer : B

ECDL ADVANCED WORD PROCESSING Exam Practice Test