ECDL-ADVANCED by ECDL Valid Free Exam Practice Test

Question 1

You are working with an Access query created in Microsoft Access 2010. Mark the button or tab that enables you to display the underlying SQL statement behind that query.

Correct Answer:

Explanation:

Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

Question 2

Which of the following steps will you take to apply the shadow effect to a text?

A. Insert > Font group > Shadow icon B. Animations > Font group > Shadow icon C. Design > Font group > Shadow icon D. Home > Font group > Shadow icon

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

You work as an Office Assistant for Company Inc. You create a presentation on daily work report. Twenty minutes before you are supposed to present the report to the team, your manager asks you to add four new sections to the report. You spend thirteen minutes adding the information, and the next seven wishing that you had not chosen such complicated formatting for your headings. Since, now you have to apply the similar format to all the new ones. Which of the following will you choose to apply the similar format to the new information that saves time and duplication effort?

A. SmartArt Styles B. Duplicate Slides C. Format Painter D. Reuse Slides

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

You work as an Office Assistant for Company Inc. You are creating a presentation in which you want to identify a location or a selection of text which you can name and identify for future reference. Which option/button in the following image of the Insert tab is used for future referencing?

Correct Answer:

Explanation:
A bookmark in Word identifies a location or a selection of text. A bookmark is used for future reference.
Chapter: ADVANCED WORD PROCESSING
Objective: Referencing

Question 5

Which of the following are the ways to protect a sheet from unauthorized access?
Each correct answer represents a complete solution. Choose all that apply.

A. Right-click on the sheet and click the Protect Sheet option. B. Home > Format > Protect Sheet C. Insert > Format > Protect Sheet D. Right-click on the Sheet tab and click the Protect Sheet option.

Correct Answer: B,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

Which of the following is a list of the references in a legal document, such as cases, statutes, and rules, along with the page numbers on which the references appear?

A. Table of Pictures B. Table of Contents C. Table of Figures D. Table of Authorities

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

Which option of Paste Special is used to link cells in different worksheets?

A. Paste Link B. Paste Format C. Link 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 D. Format Link

Correct Answer: A

Question 8

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?

A. Solid Fill B. Gradient Fill C. Picture or Texture Fill D. Label Options

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

Mark the option/button in the following image of the Format tab to apply quick styles to Series 1 of the chart as shown below:

Correct Answer:

Explanation:
A user can change the style of a chart element by using the Format tab of the Chart Tools tab. Take the following steps to apply quick styles to a chart element:
Select the chart element.
The Chart Tools tab will be displayed containing the Design, Layout, and Format tabs.
Click on the Format tab.
Click the desired shape style from the Shape Styles drop-down list.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs

Question 10

Which of the following properties binds the forms and reports to a source from which data is to be retrieved?

A. Can Grow
Explanation: The RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be retrieved. This source can be a table or a query. When a form or a report is bound to a table or a query, the controls can be bound to a column of the table through the ControlSource property.
Answer option D is incorrect. The Can Grow property allows a control to adjust its dimensions according to the contents present in the control. A control grows vertically to adjust its contents so that all the contents can be displayed. The default value of the Can Grow property is false. Answer option A is incorrect. The ControlSource property bounds a control to a field of a table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control. Answer option B is incorrect. The RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box. B. RowSource C. ControlSource D. RecordSource

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 11

with the appropriate term.
A user can use a _________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.

Correct Answer:

crosstab
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.
Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

Question 12

Which of the following properties allows a control to adjust its dimensions according to the contents present in the control?

A. TextFormat B. Name C. ControlSource D. Can Grow

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 13

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?

A. Navigation B. Split Form C. Multiple Items D. Form
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

Correct Answer: B

Question 14

Which of the following options are available in PowerPoint to arrange multiple windows?
Each correct answer represents a complete solution. Choose all that apply.

A. Cascade B. Arrange All C. Normal D. Slide Sorter

Correct Answer: A,B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

ECDL/ICDL Advanced - ECDL-ADVANCED Exam Practice Test