ECDL/ICDL Advanced - ECDL-ADVANCED Exam Questions [2026]

QUESTION NO: 1
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named SalaryData created in Microsoft Office Access 2010. This database has a report named SalaryReport. You have to determine bonuses based on a percentage of sales and display it in the report. For this, you want to insert an arithmetic expression in the report. Mark the tab/button that you will use to accomplish the task.

Correct Answer:

Explanation:
You should click on the Property Sheet button displayed on the Design contextual tab. It is used to insert an expression for the calculation. You can also use the Property Sheet button to define formats for dates, currency, and other numeric data.

Type an expression in Expression Builder and click the OK button.
Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design

QUESTION NO: 2
John works as an Office Assistant for HappyTech Inc. He is assigned the task of creating invitation cards for his colleagues. There are about 200 employees in the company. Choose and arrange the steps that he would take to ease the creation of cards.

Correct Answer:

1 - Click the File tab
2 - Click New.
3 - Click Blank document.
4 - Make changes in the document.
5 - Click the File tab.
6 - Click Save As.
7 - Give the new template a file name.
8 - Select Word Template in the Save as type list.
9 - Click Save.
10 - Choose the template
Explanation:
A template is a tool that is used to create a standard layout and look and feel across multiple pages. A user creates a template when he wants to apply the same layout to multiple pages in a document. When he makes a change in the template, all pages associated with it are affected and the corresponding change is reflected on all pages.
Take the following steps to create a template:
Click the File tab and then click New.

Click the Blank document and then click Create.

Make changes in the document. Click the File tab and then click Save As.

In the Save As dialog box, do one of the following:
Scroll to the top of the folder list, click Templates on a computer that is running Windows 7.
Under Favorite Links, click Templates on a computer that is running Windows Vista.
Under Save in, click Trusted Templates on a computer that is running Windows XP.
Give the new template a file name, select Word Template in the Save as type list, and then click Save.

Close the template.
Reference:
http://office.microsoft.com/en-us/word-help/save-a-word-document-as-a-template-HA101868862.aspx Chapter: ADVANCED WORD PROCESSING Objective: Enhancing Productivity

QUESTION NO: 3
Which of the following steps will you take to remove background of slides?

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

Correct Answer: B

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

QUESTION NO: 4
Choose and reorder the steps required to insert a chart in a presentation.

Correct Answer:

1 - Click on the Insert tab.
2 - In the Illustrations group, click Chart.
3 - The Insert Chart dialog box appears.
4 - Click the arrows to scroll through the chart types.
5 - Select the type of chart that you want to insert, and then click the OK button.
6 - Edit the data in Excel 2010
Explanation:
The Chart button under the Insert tab is used to insert a chart in a presentation. Take the following steps to insert a chart in a presentation:
Click on the Insert tab. In the Illustrations group, click Chart.
The Insert Chart dialog box appears.
Click the arrows to scroll through the chart types. Select the type of chart that you want to insert, and then click the OK button.
Edit the data in Excel 2010.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs

QUESTION NO: 5
You want to write a formula to add the values in B3 and C3 cells, and display the added value in D3 cell. From which of the following symbols will you begin to write the formula?

A. & B. % C. * D. =

Correct Answer: D

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

QUESTION NO: 6
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. ControlSource C. RowSource D. RecordSource

Correct Answer: D

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

QUESTION NO: 7
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.

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

Chapter: ADVANCED WORD PROCESSING
Objective: Prepare Outputs

QUESTION NO: 8
You are creating a presentation and added a picture from a file in it. Now, you want to change the border color of the picture to light blue, as shown in the following image:

Correct Answer:

Explanation:
The Picture Styles group comprises the Picture Border button to change the color of the picture border. Take the following steps to add border to an image:
Select an image.
Click the Format tab, and then click the Picture Border button.
The Picture Border drop-down list appears. Specify the color settings to be applied. Chapter: PRESENTATION, ADVANCED - LEVEL Objective: Pictures, Images, Drawn Objects

QUESTION NO: 9
You work in an office and you are assigned the task of preparing a document. You insert a table in the document and your document has a number of objects. You want to use gridlines for proper alignment between objects. For this, you have to display gridlines of the table. However, clicking the Borders button on the Design tab will not help in displaying the gridlines. Which of the following is the cause of the issue?

A. You are viewing the document in a Web browser. B. You are viewing the document marked as final.
Explanation: Gridlines are used to show cell boundaries of a table on the screen. These gridlines will display where the table does not have borders. They appear only on the screen where they are not printed. The user cannot see the changes wherever the gridlines are behind the borders if you hide the gridlines in a table that has these borders by default. All tables have black 1/2 point, single-line, solid-line borders that are printed. In order to view the gridlines, remove the borders. If the user is viewing a document in the Web browser, gridlines will never be visible.
Answer options C and A are incorrect. You can view gridlines of a table in the Draft and Print Layout views. The Draft view is used to view the document as a draft to allow a user to quickly edit the text. Headers and footers are not visible in this view. The Print Layout view is used to view a document as it would appear on a printed page.
Answer option D is incorrect. The gridlines of a table are not affected by the use of the mark as final feature. Answer options C and A are incorrect. You can view gridlines of a table in the Draft and Print Layout views. The Draft view is used to view the document as a draft to allow a user to quickly edit the text. Headers and footers are not visible in this view. The Print Layout view is used to view a document as it would appear on a printed page.
Answer option D is incorrect. The gridlines of a table are not affected by the use of the mark as final feature.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting C. You are viewing the document in Draft view. D. You are viewing the document in Print Layout view.

Correct Answer: A

QUESTION NO: 10
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You add a picture from a file in the presentation. Now, you want to change the contrast of the picture to 40 percent, as shown in the following image:

A. Corrections B. Picture Layout C. Picture Effects D. Reset Picture

Correct Answer: A

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

QUESTION NO: 11
Which option of Paste Special is used to link cells in different worksheets?

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

Correct Answer: D

QUESTION NO: 12
You have created a database named Sales. The database consists of a table named Employees. You want to ensure that all names of the employees should be displayed while filling a form. Which of the following controls will you use to accomplish the task?

A. Combobox B. Label C. Textbox D. Listbox

Correct Answer: A,D

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

QUESTION NO: 13
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer contains a database named Staffs created in Microsoft Access 2010. The database contains a report named StaffsInfo. You have to set page layout, margins, page size, and zooming options for your report. Mark the appropriate view that you will choose to open your report.

Correct Answer:

Explanation:
You should open the report in Print Preview. To open the report in Print Preview, click on the View button and then choose Print Preview.

Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design

QUESTION NO: 14
You are working on your home computer with Microsoft Office 2010 installed on it. You have a table named Accessories created in Microsoft Office Access 2010. Now, you want to create a form from the table to get an organized and formatted view of all fields. Choose and re-order the steps that you will take to accomplish the task.

Correct Answer:

1 - In the Navigation pane, click the Accessories table.
2 - Click the Create table
3 - Click the Form button in the Forms group.
Explanation:
Take the following steps to create a form using the Form tool in Microsoft Office Access 2010:

Click the Create tab.

Click the Form button in the Forms group.

Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design

QUESTION NO: 15
You work as a Database Developer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to create a form that allows users to browse to different forms and reports created in Microsoft Office Access 2010. Mark the button that you will choose to accomplish the task.

Correct Answer:

Explanation:
In order to accomplish the task, you should choose the Navigation button in the Forms group. It allows a user to browse to different forms and reports created in Microsoft Office Access 2010. The Navigation button has various options as shown in the image given below:
Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design