Free ECDL ECDL-ADVANCED Exam Practice Questions & Explanations

Last updated on: Nov 12, 2026
Prepared & Reviewed by the ValidExamDumps Editorial Team

At ValidExamDumps, we consistently monitor updates to the ECDL-ADVANCED exam questions by ECDL. Whenever our team identifies changes in the exam questions, objectives, focus areas or requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these up to date and 100% exam domain coverage questions, our customers can successfully pass the ECDL ADVANCED WORD PROCESSING exam on their first attempt without needing additional materials or study guides.

Other certification materials providers often include outdated or removed questions by ECDL in their ECDL-ADVANCED exam. These outdated questions lead to customers failing their ECDL ADVANCED WORD PROCESSING exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions. Our main priority is your success in the ECDL-ADVANCED exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.

 

Question 1

You have opened an Access form in the Design view. The form has header and footer. You want to save the entire form as the report. What will you do?

Answer Options
Correct Answer: A
Explanation

In order to save the entire form as the report, you should open the form in the Design view and then click the Save As button.

The form header and footer are used as the report header and footer after saving the form as the report.

Answer option D is incorrect. If you click Report Wizard, a new report is created based on the form.

Answer option B is incorrect. You are not required to delete the form header and footer to save the form as the report.

Answer option C is incorrect. Access allows you to save the form as the report.


Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 2

Which option of the Format Shape dialog box is used when a user wants the selected font size of the text to be reduced automatically?

Answer Options
Correct Answer: A
Explanation

The Shrink text on overflow option is used when a user wants the selected font size of the text to be reduced automatically.

Answer option C is incorrect. The Do not AutoFit option is selected when a user does not want the text to fit in the text box automatically.

Answer option B is incorrect. The Resize shape to fit text option is used when a user wants to adjust the margins between the text and the text box.


Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Managing Presentations

Question 3

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.

Answer Options
Correct Answer: C, D
Explanation

There are two ways to protect a sheet from unauthorized access.

The first way is:

Take the following steps to protect a worksheet:

Go to the Format drop down icon in the Home tab.

Select the Protect Sheet option.

Fill the password in the Protect Sheet dialog box and re-enter the password in the Confirm Password dialog box.

After completing the above process, an error message will occur while editing the sheet.

The second way is:

Right-click on the Sheet tab and click the Protect Sheet option.

Answer options A and B are incorrect. These are not correct ways to protect a sheet from unauthorized access.


Chapter: ADVANCED SPREADSHEETS

Objective: Editing

Question 4

Which of the following steps will you take to hide a row in a worksheet?

Answer Options
Correct Answer: A
Explanation

Take the following steps to hide a row in a worksheet:

Go to the Format drop down icon in the Home tab.

Select the Hide & Unhide option in the Format drop down icon and click the Hide Rows option.

After clicking the Hide & Unhide option, it will automatically hide the selected rows.

Answer options B, C, and D are incorrect. These are not valid steps to hide a row in a worksheet.


Chapter: ADVANCED SPREADSHEETS

Objective: Editing

Question 5

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. You want to automate the import and export operations available on the External Data tab while working on Microsoft Office Access 2010. Which of the following actions will you perform to accomplish the task?

Answer Options
Correct Answer: A, C
Explanation

In order to accomplish the task, you should perform one of the following tasks:

Write a macro.

Define a VBA (Visual Basic for Applications) code.

These tasks automate the import and export operations available on the External Data tab while working on Microsoft Office Access 2010.

Answer option D is incorrect. You can use commands on the External Data tab to manually import and export data.

Answer option B is incorrect. You cannot save the database as a spreadsheet file.


Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data