ECDL ecdl-advanced online test

Question 1

Which of the following statements will you use to delete a table from a database?

• A. DROP TABLE <table_name>
• B. DELETE TABLE <table_name> FROM DATABASE
• C. REMOVE TABLE <table_name>
• D. DELETE TABLE <table_name>

Answer:

A

Explanation:
You will use the DROP TABLE statement to delete a table from a database. The syntax is as follows:
DROP TABLE <table_name>
Here, the DROP TABLE statement is used to drop the table and the <table_name> specifies the name
of the table to be deleted.
The DROP TABLE statement removes the table from the database. It can only be recovered if the
backup of the database is present.
Answer options D, C, and B are incorrect. There are no such types of statements available.
Reference: ECDL/ICDL Exam Course Manual, Contents: "DROP TABLE statement"
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

Question 2

Which of the following queries is used to see the relationship of data between two fields?

• A. Parameter
• B. Select
• C. Action
• D. Crosstab

Answer:

D

Explanation:
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. How to create a crosstab query?
Take the following steps to create a crosstab query:

On the Open Recent Database page, click the required database.

On the database window, click the Create tab.

On the Create tab, click the Query Wizard.

On the New Query dialog box, select the Crosstab Query Wizard, and click the OK button.

On the Crosstab Query Wizard, select a table, and click the Next button.

On the Crosstab Query Wizard, the columns of the selected table are displayed in the Available Fields
list box.

On the Crosstab Query Wizard, move the columns from the Available Fields list to the Selected Fields
list by clicking on the > button. The >> button is not available in this wizard.
Click on the < button to move a field from the Selected Fields list to the Available Fields list. Click on
the << button to move all the columns from the Selected Fields list to the Available Fields list. Select
the Next button.

On the Crosstab Query Wizard, select a column that will be displayed as the heading. Select the Next
button.

On the Crosstab Query Wizard, select the function that is to be invoked on a column. Click the Next
button.

On the Crosstab Query Wizard, select the View the query radio button, and click the Finish button.

The result of the query will be saved and displayed in the database window.
10/274

Answer option A is incorrect. A parameter query prompts a user for information to be used in the
query.
Answer option B is incorrect. A select query is used to retrieve data from one or more tables. It is
used to display the results in a datasheet.
Answer option C is incorrect. An action query is used to update multiple records in one operation.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Crosstab query"
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design

Question 3

Order List
You have created an arithmetic expression in an Access query to compute the results that determine
fees based on a contract amount. When you run this query, Access performs the calculations and
displays the results. Choose and re-order the steps that you will take to create the calculated field
11/274

Answer:

Explanation:
Take the following steps to create a calculated field:
Put the insertion point in the Field row of a blank column in the Design grid.

Click the Builder button.
12/274

Double-click the field to be used in the calculation.
Build an expression using the operator buttons and elements area.
Type other values required to be included in the expression.
Click the OK button.

Click the Run button.

Reference:
http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

Question 4

You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010.
13/274
You have created a button in the presentation. You want a program to run when you click on the
button or hover your mouse over it during the slide show. Which of the following will you use to
accomplish the task?

• A. Table of Authorities
• A. Reuse Slides
• B. Table of Contents
• B. Hyperlink
• C. Table of Pictures
• C. Action
• D. Table of Figures
• D. Set Up Slide Show

Answer:

C

Explanation:
The Action icon feature is used to apply an action to the selected object in a slide to indicate what
should happen when a user clicks on the object or hovers his mouse over it. Take the following steps
to run a program in a presentation:
1. Select an object.
2. Click on the Insert tab and select the Action option.
3. The Action Settings dialog box appears. Select the Run program radio button. Click the Browse
button.
4. The Select a Program to Run dialog box appears. Select a program, and then click the OK button.
Note: Whenever a user clicks the object during a slide show, the selected program will automatically
run.
Answer option B is incorrect. A hyperlink is used to link a destination. However, it is not able to
execute any program efficiently.
Answer option A is incorrect. The Reuse Slides feature is used to reuse a slide from one presentation
to another presentation.
Answer option D is incorrect. The Set Up Slide Show option is used to set up the show type, show
options, pen color, and slide show resolution, for example, a slide show without animation. By using
it, a user can apply advanced options such as presented by a speaker.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Multimedia

Question 5

You work as an Office Assistant for BlueSoft Inc. You use Microsoft Word 2010 for creating
documents. You need to change the orientation of the page from portrait to landscape. Mark the tab
that you will use to accomplish the task.

Answer:

Explanation:
You will click the Page Layout tab to change the orientation of the page from portrait to landscape.
Click the Orientation button, and select Landscape from the list.
16/274

Chapter: ADVANCED WORD PROCESSING
Objective: Prepare Outputs

Question 6

Which of the following steps will you take to remove background of slides?

• A. Insert > Background Styles > Reset Slide Background
• B. Format > Background Styles > Reset Slide Background
• C. Design > Background Styles > Reset Slide Background
• D. Design > Background Styles > Format Background

Answer:

C

Explanation:
Take the following steps to remove background of slides:
Click the Design tab.

Select the Background Styles drop down menu in the Design tab. Click the Reset Slide Background
option to remove background of slides.

Answer options B, A, and D are incorrect. These are not valid steps to remove background of slides.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Background of slides"
17/274
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Pictures, Images, Drawn Objects

Question 7

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

• A. Datasheet view
• B. PivotTable view
• C. Form view
• D. PivotChart view

Answer:

C

Explanation:
The Form view is a default view type for an Access form. It allows a user to manipulate data on the
form.

Answer option A is incorrect. The Datasheet view displays the data in the table format.
Answer option D is incorrect. The PivotChart view allows a user to display the data of a form as pivot
charts.
Answer option B is incorrect. The PivotTable view allows a user to display the data of a form as a
18/274
pivot table.
Reference:
http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design

Question 8

You work as an Office Assistant for Company Inc. You are using Word 2010 to create a document.
Mark the option/button in the following image that you would click to browse a document by its
heading.

Answer:

19/274

Explanation:
The new Navigation pane helps you find text, tables, graphics, comments, footnotes or endnotes,
and equations in a document. Users can view thumbnail images of document pages. They can also
browse through their document by its headings. Take the following steps to use Browse By buttons of
the navigation pane:
1. On the View tab, select the Navigation Pane check box in the Show group.
2. In the Navigation pane, click the Browse the pages in your document button. To go to a page in the
document, click the thumbnail image.
3. In the Navigation pane, click the Browse the headings in your document button. To go to a heading
in your document, click heading.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting

Question 9

You work as an Office Assistant for Company Inc. You are creating a presentation in Microsoft
PowerPoint 2010. You have inserted a chart in your presentation. After creating the presentation, you
want to change the chart type, so that the chart will work well with the format of the presentation.
Choose and reorder the steps that you will take to change the chart type.
20/274

Answer:

Explanation:
A user can change the chart by using the Change Chart Type button under the Design tab. Take the
following steps to change the chart type in a presentation:
1. In order to change the chart type of the whole chart, click the chart area or plot area of the chart
to display the chart tools.
2. In order to change the chart type of a data series, click the data series.
3. This displays the Chart Tools containing the Design, Layout, and Format tabs.
4. Click on the Design tab. In the Type group, click the Change Chart Type button.
5. The Change Chart Type dialog box opens. Click a chart type that you want to use.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs

Question 10

Which of the following key sequences cannot be used by the database users when you have cleared
the Use Access Special Keys check box?
A. Alt + Shift
B. F4
C. Ctrl + G
D. Ctrl + Break
E. Alt + F11
F. F11

Answer:

F, E, D, and C
21/274

Explanation:
If the Use Access Special Keys check box is clear, the database users cannot use the following key
sequences:
F11: It is used to display the Navigation Pane on the left side of the Access window.
Alt + F11: It is used to open the Visual Basic Editor (VBE).
Ctrl + Break: It is used to show the current point of execution of the VBA software.
Ctrl + G: It is used to view the Immediate window.
Answer options B and A are incorrect. These key sequences are not affected by the status of the Use
Access Special Keys check box.
Reference: http://msdn.microsoft.com/en-us/library/bb421308.aspx
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design