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

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 3

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 4

You are working on an Access form named Form-A. You have opened Property Sheet to view the form's properties and make the required changes. Property Sheet consists of five tabs with a different set of properties. Which of the following tabs specifies how a value is displayed and the data source is bound to control source, input mask, validation rule, default value, and other data type?

AData

BEvent

CFormat

DOther
Explanation:

The Data tab of Property Sheet specifies how a value is displayed and the data source is bound to control source, input mask, validation rule, default value, and other data type.

What are the various tabs of the Property Sheet?
The various tabs of the Property Sheet are as follows:
Format: It specifies how a label or value is displayed. It includes font, size, border, special effect, and scroll bar.
Data: It specifies how a value is displayed and the data source is bound to control source, input mask, validation rule, default value, and other data types.
Event: It displays all events in the form of a call to a macro or a VBA procedure.
Other: It displays additional characteristics of control, such as control name and description.
All: It displays all properties of control.

Answer : A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 5

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 6

Which of the following steps will you take to hide a sheet in a worksheet?

APage Layout > Format > Hide & Unhide > Hide Sheet

BHome > Format > Hide & Unhide > Hide Sheet

CInsert > Format > Hide & Unhide > Hide Sheet

DView > Format > Hide & Unhide > Hide Sheet
Explanation:
Take the following steps to hide a sheet in a worksheet:
Go to the Format drop down icon in the Home tab.

After clicking the Hide Sheet option, it will automatically hide the sheet.

Answer options C, D, and A are incorrect. These are not valid steps to hide a sheet.

Answer : B

Chapter: ADVANCED SPREADSHEETS

Objective: Editing

Question 7

You work as an Office Assistant for Company Inc. You are creating a presentation named OrganizationWorkflow.pptx through PowerPoint 2010. The presentation contains different slides for each department of the organization. In the past, you have created a presentation for the marketing department named Sales.pptx. Now, you want to apply the same slide formatting of the marketing slide to a slide of your presentation. Which of the following steps will you take to accomplish the task?

AClick the Home tab. In the Slides group, click the New Slides button > Duplicate Selected Slides option.

BClick the Home tab. In the Slides group, click the New Slides button > Reuse Slides option.

CCopy and paste the marketing slide to the presentation.

DClick the Insert tab. In the Illustrations group, click the Slides button.

Answer : B, C

Take the following steps to apply the same slide formatting of a slide to a slide of another presentation:

Copy and paste the desired slide to the presentation.

Click the Home tab.

In the Slides group, click the New Slides button > Reuse Slides option.

The Reuse Slides dialog box opens. Click the Browse button and select the required slide.

Answer option A is incorrect. The Duplicate Selected Slides option is used to create a duplicate slide of the selected slide in the same presentation.

Answer option D is incorrect. There is no such button as the Slides button on the Insert tab.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Slides

ECDL-ADVANCED ECDL ADVANCED WORD PROCESSING Exam Practice Test