ECDL-ADVANCED Exam Questions Instant Access

Question 1

Which of the following functions will return the current system date and time?

AFormat()

BDatePart()

CDate()

DNOW()

Answer : D

The Now() function is used to return the current system date and time.

Following is the syntax for the Now() function:

Now() Answer option A is incorrect. The Format() function is used to take an expression and return it as a formatted string.

Following is the syntax for the Format() function:

Format(expression, [format, [firstdayofweek, [firstweekofyear]]] )

Answer option B is incorrect. The DatePart() function is used to return a specified part of a given date.

Following is the syntax for the DatePart() function:

DatePart(interval, date, [firstdayofweek], [firstweekofyear])

Answer option C is incorrect. The Date() function is used to return the serial number of a date.

Following is the syntax for the Date() function:

Date(year, month, day)

Chapter: ADVANCED SPREADSHEETS

Objective: Functions

Question 2

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

ADatasheet view

BPivotTable view

CForm view

DPivotChart view

Answer : C

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 3

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?

ADesign

BArrange

CFormat

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

Answer : A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 4

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

Question 5

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 6

Which of the following views is a simplified version of Slide Show view, which appears in a window rather than full-screen?

AReading View

BSlide Sorter

CNotes Page

DSlide Show

Answer : A

Following are the views that exist in PowerPoint:

* Normal: It is a combination of various resizable panes, so that the presentation can be shown in multiple ways at once. However, the default view is Normal.

* Slide Sorter: It is a light-table-type overhead view of all the slides in the presentation, laid out in rows, suitable for big-picture rearranging.

* Notes Page: It is a view with the slide at the top of the page and a text box below it for typed notes.

* Slide Show: It is the view that can be used to show the presentation onscreen.

* Reading View: It is a simplified version of the Slide Show view, which appears in a window rather than full screen.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Managing Presentations

Question 7

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

ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Questions