ECDL-ADVANCED Exam Questions Instant Access

Question 1

You work as a newspaper editor and you have to write an article on some topic. Which of the following will you choose to accomplish the task?

AJustify the text.

BWrite the text in columns.

CCenter align the text.

DLeft align the text.
Explanation:
In newspapers, articles are written in columns.
Answer option D is incorrect. The text in a newspaper is not left-aligned.
Answer option A is incorrect. The text in a newspaper is not justified.
Answer option C is incorrect. The text in a newspaper is not center aligned.
What is a column?
A column is one or more vertical blocks of content positioned on a page, separated by margins and/or rules. Columns are most commonly used to break up large bodies of text that cannot fit in a single block of text on a page. Additionally, columns are used to improve page composition and readability. Newspapers very frequently use complex multi-column layouts to break up different stories and longer bodies of texts within a story.

Answer : B

Chapter: ADVANCED WORD PROCESSING

Objective: Prepare Outputs

Question 2

You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have added bullets in the presentation. Now, you want to demote the size of the bullets to 25% of a slide text. Which of the following actions will you take to accomplish the task?

AClick the Promote option on the Home tab.

BClick the Demote option on the Home tab.

CClick the Numbered tab under the Bullets and Numbering option.

DClick the Page Setup option on the Design tab.

Answer : C

The Numbered tab comprises the Size button to reduce the size of the bullets. Take the following steps to format a bulleted and numbered list:

Select a text.

Click the bullets icon under the Paragraph group.

The Bullets and Numbering gallery appears. Select the Bullets and Numbering option.

The Bullets and Numbering dialog box appears. Click the Picture button.

The Picture Bullet dialog box appears. Select a bullet, and click the OK button.

Click the Customize button in the Bullets and Numbering dialog box. A Symbol dialog box appears. Select a symbol, and click the OK button.

Answer option D is incorrect. The Page Setup option is used to organize the slide orientation and layout.

Answer option A is incorrect. The Promote option is used to increase the font size of a text.

Answer option B is incorrect. The Demote option is used to decrease the font size of a text.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Slides

Question 3

Which of the following paragraph-level formatting controls is used to prevent a single paragraph line from being stranded on a page all by itself?

APage Break Before

BKeep Lines Together

CKeep with Next

DWidow/Orphan Control

Answer : D

Following are paragraph-level formatting controls:

* Widow/Orphan Control: It is used to prevent a single paragraph line from being stranded on a page all by itself.

* Keep with Next: It is used to force a paragraph to appear with the paragraph that follows.

* Keep Lines Together: It is used to prevent a paragraph from breaking across two pages.

* Page Break Before: It is used to force an automatic page break before the paragraph.

* Do not Hyphenate: It is used to instruct Microsoft Word not to perform hyphenation in a given paragraph.

Chapter: ADVANCED WORD PROCESSING

Objective: Formatting

Question 4

You work as a Database Designer for Company Inc. The company uses Microsoft Access 2010 for creating and managing databases. You have created a database named Detail. The database consists of 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?

ADatasheet

BDesign

CPivot Table

DLayout

Answer : B

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.

Answer option C 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.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

Question 5

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 6

Which of the following Excel functions finds a value in the leftmost column of a named range and returns the value from the specified cell with the found value?

AIFERROR

BIF

CVLOOKUP

DSUBTOTAL

Answer : C

VLOOKUP (Vertical Lookup) is an Excel function that finds a value in the leftmost column of a named range and returns the value from the specified cell with the found value.

Syntax:

VLOOKUP(lookup_value, table_array, col_number, range_lookup)

In the given syntax, lookup_value is the value to be found in the leftmost column of the range.

table_array is the range or data table to be searched.

col_number is the number of the column in the range from which the value is to be returned.

range_lookup is a logical argument to find an approximate match in case the specified value is TRUE or an exact match in case the specified value is FALSE.

Answer option B is incorrect. IF is a logical function, which is used to create a conditional formula. The return value of the IF function depends on the evaluation of the specified condition, whether it is TRUE or FALSE. The IF function conducts conditional tests on values and formulas.

Syntax IF(logical_condition,value_when_true,value_when_false)

Here, Logical_condition is any value or expression that can be evaluated to TRUE or FALSE.

Value_when_true is the value that is returned if logical_condition is TRUE.

Value_when_false is the value that is returned if logical_condition is FALSE.

Note: Value_when_true and Value_when_false can be another formula. Nested conditional formulas can be constructed by using up to sixty-four IF functions to construct more elaborate tests.

Answer option A is incorrect. The IFERROR function is used to enable users to display one value if a formula results in an error and another if it does not. It is used to trap and handle errors in a formula. It helps a user to create a custom error message instead of relying on default error messages. Answer option D is incorrect. SUBTOTAL is a function that is used to return the subtotal in a column of a list.

Syntax: SUBTOTAL(function_num, ref1, ref2, ref3)

In the syntax, function_num is the number 1 to 11 (includes hidden values) or 101 to 111 (ignores hidden values) that specifies which function to use in calculating subtotals within a list.

Chapter: ADVANCED SPREADSHEETS

Objective: Functions

Question 7

You are typing a document and you want the date of the creation of the document to appear on top of each page. What will you do to accomplish the task?

AType the date on top of each page.

BCreate a footer.

CCreate a header.

DCreate a template.

Answer : C

Header 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 top of each page.

Chapter: ADVANCED WORD PROCESSING

Objective: Prepare Outputs

ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Questions