ECDL-ADVANCED Exam Practice Test Instant Access

Question 1

You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have accidentally deleted one of the placeholders. However, you want to use that placeholder. Which of the following steps will you take to resolve the issue?

ASelect the Slide Master view > Master Layout, and then select the check box for the deleted placeholder.

BRight-click the placeholder and click the Format Shape option.

CSelect the Notes Master view > Master Layout, and then select the check box for the deleted placeholder.

DSelect the Handout Master view > Master Layout, and then select the check box for the deleted placeholder.

Answer : A

Slide Master is able to restore the deleted placeholders. To restore the deleted placeholders, select the Slide Master view > Master layout, and then select the check box for the deleted placeholder. Slide Master comprises a set of formatting groups. Following are the elements of Slide Master:

Edit master

Master layout

Edit theme

Background

Page setup

Answer option D is incorrect. In Handout view, the Handout placeholder is not able to move, resize, and delete.

Answer option B is incorrect. In the Format Shape option, the Format placeholder is used for formatting only, and not for restoring the deleted placeholders.

Answer option C is incorrect. The Notes master view is not able to restore the placeholders.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Slides

Question 2

Which of the following sections are included in the default layout of the Report Design view?

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

APage Header

BGroup Header/Footer

CPage Footer

DDetail
Explanation:
The following sections are included in the default layout of the Report Design view:
Page Header: It is displayed at the top of each page. Page Header includes a logo, column heading, page number, etc.
Detail: It displays the data and their associated labels that are included for the table or query fields added to the report.
Page Footer: It is displayed at the bottom of each page. Page Footer includes a report name, date and time, coding, page number, etc.
Answer option B is incorrect. It is not a valid section included in the default layout of the Report Design view.

Answer : A, C, D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Report Design

Question 3

You are creating a form in Microsoft Office Access 2010. You want the created form to display a Form view and a Datasheet view of the same data at the same time. Which of the following tools will you use to accomplish the task?

AMultiple Items

BSplit Form

CNavigation

DForm
Explanation:
In order to accomplish the task, you should use the Split Form tool. It is used to create a form that displays a Form view and a Datasheet view of the same data at the same time.

What is a split form?
A split form provides two views (Form view and Datasheet view) of the same data at the same time. When a user selects a field in one part of the form, the same field of the other part is also selected. The split form offers the benefit of viewing two kinds of form in a single form. The Split Form tool is used to create a split form, which is included in the More Forms menu of the Forms group.
Answer option D is incorrect. The Form tool is used to create a simple form based on a table.
Answer option C is incorrect. The Navigation tool is used to create a form to browse different forms and reports.
Answer option A is incorrect. The Multiple Items tool is used to create a tabular form.
Reference: http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design

Answer : B

Question 4

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a table named Table1 in Microsoft Office Access 2010. Table1 contains a sub-datasheet named Datasheet1. You want to work with contents of this table in Excel 2010. In order to perform this task, you need to export the table. Which of the following actions will MS Access perform while exporting the table from Access to Excel?

AIt exports only the main datasheet.

BIt converts the table into an HTML table.

CIt creates an RTF document.

DIt creates a copy of the table and stores the copy as a SharePoint list.
Explanation:
When you export a table from Microsoft Office Access 2010 to Excel and the table contains a sub-datasheet, it exports only the main datasheet. To export the sub-datasheet, you should perform another export operation. In order to combine multiple Access objects into a single Excel workbook, you should export individual objects to different workbooks, and then merge all worksheets from within Excel.
Answer option C is incorrect. Microsoft Office Access 2010 creates an RTF (Rich Text Format) document if you export information from Access to Word. This RTF document can be opened by Word and various other applications.
Answer option B is incorrect. Microsoft Office Access 2010 converts a table into an HTML table if you export the table from Access to an HTML file.
Answer option D is incorrect. Microsoft Office Access 2010 creates a copy of the table and stores the copy as a list if you export the table from Access to the SharePoint list.

Answer : A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data

Question 5

Which of the following attributes can be used to change the look and format of a document?

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

ASize

BStyle

CEffect

DLine spacing
Explanation:
The following attributes can be used to change the look and format of a document:
Size: The font size can be measured in points and each font comes in a range of sizes.
Style: Each font has a number of styles, i.e., regular, italic, bold, and bold italic.
Effect: Fonts can be enhanced by applying effects, such as underlining, small capital letters, or shadows.
Color: For specifying custom colors, a palette of coordinated colors is available.
Character spacing: A user can change the spacing between characters by pushing them apart or squeezing them together.
Answer option D is incorrect. It is not an attribute that can be used to change the look and format of a document.

Answer : A, B, C

Chapter: ADVANCED WORD PROCESSING

Objective: Formatting

Question 6

Which of the following types of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times?

ACrosstab query

BAction query

CSelect query

DParameter query
Explanation:
A parameter query prompts a user for information to be used in the query. For example, a range of dates. This type of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times.
Answer option C is incorrect. A select query is a simple type of query that is commonly used in Microsoft Office Access 2007. This query retrieves data from one or more tables and displays the results in a datasheet. A user can use a select query to group records and calculate sum, counts, averages, and other types of totals. The user can also work with the results of a select query in the Datasheet view to update records in one or more related tables at the same time.
Answer option B is incorrect. An action query is used to update multiple records in one operation. It is a form of select query that performs an action on the results of the selection process. There are four types of action queries available in Microsoft Office Access 2007, which are as follows:
Delete queries: A delete query allows to delete records from one or more tables.
Update queries: An update query allows to modify fields. This is used to update a field with an expression or data from another table.
Append queries: An append query allows to add records from one or more tables to the end of one or more other tables.
Make-table queries: A make-table query allows to create a new table from all or part of the data in one or more tables.
Answer option A is incorrect. A crosstab query is a powerful analysis tool used to see the relationship of data between two fields. It calculates and restructures data for easier analysis. A user can use a crosstab query to calculate a sum, average, count, or other type of total for data that is grouped by two types of information- one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query's calculation. This view is just like a spreadsheet with unique values of one field as rows, unique values of another field as columns, and the summary of another field as the cells in the matrix.

Answer : D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

Question 7

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

ECDL-ADVANCED ECDL ADVANCED WORD PROCESSING Exam Practice Test