ECDL-ADVANCED Exam Practice Test Instant Access

Question 1

Which of the following datatypes generates a consecutive number that can be used as the primary key of a table?

AOLE Object

BAutoNumber

CCurrency

DHyperlink

Answer : B

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

The AutoNumber datatype generates a consecutive number that can be used as the primary key of a table. Answer option C is incorrect. The Currency datatype is used to store monetary values. The format of the currency can be changed by using the Format property. The various formats of the Currency datatype are as follows:

* General Number

* Currency

* Euro

* Fixed

* Standard

* Percent

* Scientific

Answer option D is incorrect. 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.

Answer option A is incorrect. 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.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question 2

You are assigned with the task of typing a book which is of about 500 pages. You want the page number to appear at the bottom of each page. What will you do to accomplish the task?

ACreate a header.

BCreate a template.

CCreate a footer.

DType the page number on each page.

Answer : C

Footer is an area in a document where a user can put vital information such as page number, date of creation of document, time of creation of document, filename, and other information. It always appears on the bottom of each page.

Chapter: ADVANCED WORD PROCESSING

Objective: Prepare Outputs

Question 3

You work as an Office Assistant for Company Inc. You are creating a presentation in Microsoft PowerPoint 2010. You have inserted a chart in the presentation. You want to insert a chart title on the chart in which preset color is RainbowII. Which of the following options will you take to move the fill color to linear diagonal?

ASolid Fill

BLabel Options

CPicture or Texture Fill

DGradient Fill

Answer : D

The Gradient Fill option contains an option Direction to change the direction of fill color. In order to accomplish the task, you have to right-click the chart title, select the Gradient Fill radio button, and then select a direction to be applied.

Answer option C is incorrect. The Picture or Texture Fill option is used to apply the texture or picture on the chart title.

Answer option D is incorrect. Label Options contains checkboxes for specifying the values of the label text.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Charts/Graphs

Question 4

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?

ANavigation Pane

BOutline View

CReading Pane

DDraft View

Answer : A

The Navigation pane is one of the new pieces of functionality in Word 2010. This pane comprises a set of features related to navigation, search, and manipulation of the structure and organization of headings. This navigation pane replaces and improvises the old 'Document Map' and 'Thumbnails' panes.

When a document becomes lengthy, finding text and working with the document becomes tedious. This pane helps to jump to desired sections through the Headings tab. This pane displays a tree view of the different sections of a document based on the levels of the heading.

In addition to dragging outline levels in the document, a user can use the Navigation pane to view and arrange a document outline. The Navigation pane displays document headings by the outline level. To display this pane, click the View tab and check the Navigation pane in the Show group. To view an outline of document headings, click the 'Browse the headings in your document' icon.

The Navigation pane can be helpful for navigating through a long document. As the user moves the insertion point in the document, corresponding headings on each page are highlighted in the Navigation pane. The user can also click the headings in the Navigation pane to go directly to them in the document.

To rearrange headings in the Navigation pane, drag a heading to where the user wants it in the pane. A black line indicates where the heading and the text below it will appear.

Note: If a user wants to use the Navigation pane to browse headings, the document must contain heading styles or styles with outline levels defined.

Answer option C is incorrect. There is no such pane as Reading pane in Word 2010.

Answer option B is incorrect. The Outline view is used to view the overall structure of a document. It shows all the headings and sub-headings of a document in levels.

Chapter: ADVANCED WORD PROCESSING

Objective: Formatting

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

Which of the following are the types of the TextBox control?

Each correct answer represents a complete solution. Choose all that apply.

AEditable

BCalculated

CBound

DUnbound

Answer : B, C, D

A TextBox control is an editable control in which a user can edit and modify data. It is of the following types:

Unbound: An unbound textbox control is an empty control. It is not bound to any column of any table. It can be bound to a column by using the ControlSource property.

Bound: A bound textbox control is bound to a column of a table. It displays a single record of the column.

Calculated: It can be used for calculations based on the expression provided in the textbox.

Answer option A is incorrect. It is not a valid type of the TextBox control.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 7

Which of the following steps will you take to add an AutoCorrect entry?

AClick the AutoCorrect Options on the Data tab.

BClick the PowerPoint Options on the Insert and AutoCorrect Options button.

CClick the AutoCorrect Options on the Format.

DClick the PowerPoint Options on the Microsoft Office button and AutoCorrect Options button.

Answer : D

Take the following steps to add an AutoCorrect entry:

Click the Microsoft Office button. Click the PowerPoint Options button.

The PowerPoint Options dialog box appears. Click on the Proofing page tab, and then click the AutoCorrect Options button.

The AutoCorrect dialog box appears. In the Replace text box, type a word that is commonly misspelled. In the With text box, type the correct spelling of the word. Click the Add button, and then click the OK button.

Answer options A, B, and C are incorrect. These are not correct ways to add an AutoCorrect entry.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Managing Presentations

ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Practice Test