At ValidExamDumps, we consistently monitor updates to the ECDL-ADVANCED exam questions by ECDL. Whenever our team identifies changes in the exam questions,exam objectives, exam focus areas or in exam 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 actual 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, guaranteeing their presence in your actual exam. Our main priority is your success in the ECDL-ADVANCED exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.
Which of the following contextual tabs consists of controls to select the initial layout of a form and the default positions of controls on the form?
The Arrange contextual tab is highly context sensitive. It consists of controls to select the initial layout of a form and the default positions of controls on the form.
Answer option A is incorrect. The Arrange tab has various layout options.
Answer option C is incorrect. This contextual tab is not available on the form.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design
Which of the following is used to count the number of cells and arguments that consist of numbers?
The Count function is used to count the number of cells and arguments that consist of numbers.
Answer option C is incorrect. The CountIf function is used to count the number of cells in a range, that meets a given criteria.
Answer option B is incorrect. The CountA function is used to count the number of cells and arguments that consist of values.
Answer option A is incorrect. The CountBlank function is used to count the number of empty cells in a range.
Chapter: ADVANCED SPREADSHEETS
Objective: Functions
Which of the following properties binds the object to a source from which data is to be retrieved?
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 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 C 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.
Answer option B is incorrect. The TextFormat property of a control helps to change a text to rich text format. This helps to apply multiple formatting options for the text in a control. A user can change the format of the text to bold, italics, etc., The user can also change the font of the selected text and can apply other types of formatting.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design
Which of the following join types results in the multiplication of the number of rows from the left table with the number of rows from the right table when it is used in an Access query?
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design
Which of the following queries prompts a user for information to be used in the query?
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design
