Page: 1
/ 14
Total 232 questions
ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Questions
Question 1
Which of the following tools can be used to eliminate spelling and grammar errors?
Each correct answer represents a complete solution. Choose all that apply.
Answer : A, B, C
Following are the three tools that can be used to eliminate spelling and grammar errors:
1. AutoCorrect: The AutoCorrect option is used to correct misspelled words, such as explane to explain. It has a long list of commonly used words with correct spellings. However, if a user misspells a word that AutoCorrect does not change, then the user can add it to the list in the AutoCorrect dialog box.
2. Error indicators: Microsoft Word provides a feature to underline the wrongly spelled word with a red wavy line. If there is any grammatical issue, Word indicates it with a green wavy line. A user can right-click an underlined word or phrase for displaying suggestions in a shortcut menu.
3. Spelling and Grammar: The user can check spelling or grammar of the entire document by pressing F7 or by clicking the Spelling & Grammar button.
Answer option D is incorrect. It is not a valid tool to eliminate spelling and grammar errors.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting
Question 2
Jasmine creates a presentation. The presentation comprises various pictures and clips. She wants to add an alternative text on the slides for pictures and clips. Which of the following will you use to accomplish the task?
Answer : C
The Size and Position option comprises the Alternate Text tab to add an alternative text to the objects. Answer option B is incorrect. The Format Shape option is used to format the shape of the textbox such as fill, shadow, line color, etc.
Answer option A is incorrect. The Selection Pane option is used to change the order and visibility of slide objects.
Answer option D is incorrect. The Set as Default Textbox option is used to set the text box as default text box.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Relating Information
Question 3
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?
Answer : C
The Type mismatch in expression error indicates that the query includes joining fields that have different data types. In order to resolve this issue, you should check the query design and make sure that the joined fields have the same data type.
Answer option B is incorrect. The Compact and Repair Database is a command used in Microsoft Office Access 2010. It rearranges data, fills up the spaces left behind by the deleted objects, and repairs the problems. It compresses the database if any problem is encountered in the Access database.
Answer option A is incorrect. You can change a field alias if the alias assigned to a field is the same as the component of the expression.
Answer option D is incorrect. You can press SHIFT+F9 to refresh the query if the record is deleted intentionally and you get the #error message.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design
Question 4
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?
Answer : A
In order to accomplish the task, you should take the following steps:
* Right-click on Form Header.
* Choose the Ruler and Grid options.
Answer option D is incorrect. The Tools option is not used for displaying ruler and grid on the form.
Answer option B is incorrect. Conditional Formatting does not include any option for ruler and grid.
Answer option C is incorrect. When you right-click the form, it does not show the Format option.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design
Question 5
Which of the following properties binds the object to a source from which data is to be retrieved?
Answer : A
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
Question 6
Which of the following are the predefined quick styles for formatting of documents?
Each correct answer represents a complete solution. Choose all that apply.
Answer : A, C, D
Following are the predefined quick styles for formatting of documents:
Paragraph styles: These styles can be applied to entire paragraphs, such as headings.
Character styles: These styles can be applied to words.
Linked styles: These styles can be applied to either paragraphs or words.
What are Quick Styles?
Quick Styles are galleries with a range of styles based on the current theme. These are combinations of different formatting options and are displayed in a thumbnail in the various Quick Style galleries. There are Quick Styles galleries for text, tables, charts, SmartArt, Word Art and more.
Answer option B is incorrect. It is not a valid quick style for formatting.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting
Question 7
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?
Answer : A
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design
All Official Question Types