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

QUESTION NO: 1
Which of the following functions is used to add all numbers in a range of cells, based on a given criteria?

A. SumSq()

B. SumProduct()

C. Sum()
Explanation: The SumIf function is used to add all numbers in a range of cells, based on a given criteria. Answer option B is incorrect. The SumProduct function is used to multiply the corresponding items in the arrays and return the sum of the results.
Answer option A is incorrect. The SumSq function is used to return the sum of the squares of a series of values.
Answer option D is incorrect. The Sum function is used to add all numbers in a range of cells and return the result.

D. SumIf()

Discussion 0

Correct Answer: D Vote an answer

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

QUESTION NO: 2
You have created a query to retrieve records from two tables created in Microsoft Access 2010. When you run this query, you get the following error:
Type mismatch in expression
What will you do to resolve the issue?

A. Use Compact and Repair Database.

B. Check the joined fields in the query.

C. Change a field alias.

D. Press SHIFT+F9 to refresh the query.

Discussion 0

Correct Answer: B Vote an answer

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

QUESTION NO: 3
Jasmine creates a presentation. She wants to start another presentation after completing the current presentation during the slide show. Which of the following will she use to accomplish the task?

A. Reuse Slides

B. Hyperlink

C. Action Buttons

D. SmartArt

Discussion 0

Correct Answer: B Vote an answer

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

QUESTION NO: 4
Mark the option/button in the following image of the Home tab on which you will click to convert the text of a text box to a SmartArt graphic.

Discussion 0

Correct Answer:

Explanation:
SmartArt is a visual graphic used to represent the information effectively and efficiently. It is used to create designer-quality illustrations. A user can increase the emphasis of information by adding SmartArt. Though SmartArt graphics audience of a presentation can understand and recall information better than a text, it is necessary to visualize what type and layout are best for displaying data, and what does a user want to convey with a SmartArt graphic. A user can quickly convert slide text to a SmartArt graphic.

Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides

QUESTION NO: 5
Which of the following statements will you use to copy data from one table named Department to another table named DepartmentID?

A. INSERT FROM Department INTO DepartmentID

B. INSERT INTO DepartmentID SELECT * FROM Department

C. INSERT * INTO DepartmentID FROM Department

D. INSERT INTO DepartmentID FROM Department

Discussion 0

Correct Answer: B Vote an answer

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

QUESTION NO: 6
You have a datasheet named Datasheet1 created in Microsoft Office Access 2010. You need to calculate the sum, average, and count for data. This data is grouped by two types of information, one down the left side of the datasheet and another across the top of the datasheet. You want to display the results of the query's calculation in the cell at the junction of each row and column. Which of the following types of Query wizard will you use to accomplish the task?

A. Find Unmatched
The various types of the Query wizard are as follows:
1. Simple: It is used to set up a query in order to retrieve data from one or more tables and display the results in a datasheet.
2. Find Duplicates: It is used to set up a query in order to locate records. These records contain the same data in one or more specified fields.
3. Find Unmatched: It is used to set up a query in order to locate records in a single table. These records do not contain any related record in another table.
4. Crosstab: It is used to set up a query in order to calculate and re-organize information for making the analysis easy.

B. Find Duplicates

C. Crosstab

D. Simple

Discussion 0

Correct Answer: C Vote an answer

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

QUESTION NO: 7
You work as a newspaper editor and you have to write an article on some topic. Which of the following will you choose to accomplish the task?

A. Justify the text.

B. Write the text in columns.

C. Center align the text.

D. Left align the text.
Explanation: In newspapers, articles are written in columns.
Answer option D is incorrect. The text in a newspaper is not left-aligned.
Answer option A is incorrect. The text in a newspaper is not justified.
Answer option C is incorrect. The text in a newspaper is not center aligned.
What is a column?
A column is one or more vertical blocks of content positioned on a page, separated by margins and/or rules. Columns are most commonly used to break up large bodies of text that cannot fit in a single block of text on a page. Additionally, columns are used to improve page composition and readability. Newspapers very frequently use complex multi-column layouts to break up different stories and longer bodies of texts within a story.

Discussion 0

Correct Answer: B Vote an answer

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

QUESTION NO: 8
Which of the following steps will you take to protect your worksheet from unauthorized access?

A. Home > Format > Protect Sheet

B. Format > Protect Sheet > Lock Sheet

C. Insert > Format > Protect Sheet

D. Format > Worksheet > Lock Sheet

Discussion 0

Correct Answer: A Vote an answer

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

QUESTION NO: 9
with the appropriate term.

Discussion 0

Correct Answer:

Mail Merge
Explanation:
Mail Merge is use to quickly create multiple letters, e-mail messages, mailing labels, envelopes, and a directory. It uses two files for creating a document. It is use to create a set of documents, such as letters, in which the information contained in the letter is the same but the address of each person is different.
Reference:
Chapter: ADVANCED WORD PROCESSING
Objective: Enhancing Productivity

QUESTION NO: 10
You have a form named Assets created in Microsoft Office Access 2010. You have to make some changes in the formatting of the form. For this reason, you have opened the form in the Design view. Now, you want to display ruler and grid for making the formatting easy. Which of the following steps will you take to accomplish the task?

A. Click on the Format contextual tab and choose the Conditional Formatting option.

B. Click on the Design contextual tab and choose the Tools option.

C. Right-click on the form name and choose the Format option.

D. Right-click on Form Header, and choose the Ruler and Grid options.

Discussion 0

Correct Answer: D Vote an answer

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

QUESTION NO: 11
You want to group by Sales Region to see all records for each sales region together, with a total of sales for each region. Mark the button that you will click to accomplish the task.

Discussion 0

Correct Answer:

Explanation:
In order to accomplish the task, you should click the Group & Sort button in the Grouping & Totals group.

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

QUESTION NO: 12
Which of the following datatypes cannot be filtered by using common filters?
Each correct answer represents a complete solution. Choose two.

A. Hyperlink

B. AutoNumber
Explanation: The following datatypes cannot be filtered by using common filters:
OLE Object: The OLE Object datatype is used to attach files and add binary data to a table. This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc.
Calculated Field: The Calculated Field datatype is used to store the results of a calculation. The calculation should refer to other fields created in the same table. In order to create the calculation, a user can use the Expression Builder that provides the use of IntelliSense and an easy way to access expression values.
Answer options A and D are incorrect. These datatypes can be filtered by using common filters. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink.
The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table. The increment can be changed through the New Values property. This property has the following two values:
Increment
Random

C. Calculated Field

D. OLE Object

Discussion 0

Correct Answer: C,D Vote an answer

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

QUALITY AND VALUE

Tested and Approved

Easy to Pass

Try Before Buy

RECENT DISCUSSIONS

Useful Links

Contact Us