Page: 1
/ 14
Total 232 questions
ECDL-ADVANCED ECDL ADVANCED WORD PROCESSING Exam Practice Test
Question 1
Which of the following is a view in Microsoft Word 2010 that provides an easy way to move through a document and the drag and drop functionality to move sections in a document?
Answer : A
The Navigation pane is one of the new pieces of functionality in Word 2010. This pane comprises a set of features related to navigation, search, and manipulation of the structure and organization of headings. This navigation pane replaces and improvises the old 'Document Map' and 'Thumbnails' panes.
When a document becomes lengthy, finding text and working with the document becomes tedious. This pane helps to jump to desired sections through the Headings tab. This pane displays a tree view of the different sections of a document based on the levels of the heading.
In addition to dragging outline levels in the document, a user can use the Navigation pane to view and arrange a document outline. The Navigation pane displays document headings by the outline level. To display this pane, click the View tab and check the Navigation pane in the Show group. To view an outline of document headings, click the 'Browse the headings in your document' icon.
The Navigation pane can be helpful for navigating through a long document. As the user moves the insertion point in the document, corresponding headings on each page are highlighted in the Navigation pane. The user can also click the headings in the Navigation pane to go directly to them in the document.
To rearrange headings in the Navigation pane, drag a heading to where the user wants it in the pane. A black line indicates where the heading and the text below it will appear.
Note: If a user wants to use the Navigation pane to browse headings, the document must contain heading styles or styles with outline levels defined.
Answer option C is incorrect. There is no such pane as Reading pane in Word 2010.
Answer option B is incorrect. The Outline view is used to view the overall structure of a document. It shows all the headings and sub-headings of a document in levels.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting
Question 2
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 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
Which of the following statements will you use to delete a table from a database?
Answer : A
You will use the DROP TABLE statement to delete a table from a database. The syntax is as follows:
DROP TABLE <table_name>
Here, the DROP TABLE statement is used to drop the table and the <table_name> specifies the name of the table to be deleted.
The DROP TABLE statement removes the table from the database. It can only be recovered if the backup of the database is present.
Answer options D, C, and B are incorrect. There are no such types of statements available.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design
Question 5
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. The presentation comprises various objects. You insert a hyperlink in the presentation. Now, you want to add a screen tip that is used to see the path of the hyperlinked file while delivering the presentation. Which of the following will you use to accomplish the task?
Answer : D
Take the following steps to add a screen tip to a hyperlinked element:
1. Select a graphic or text to apply a hyperlink.
2. Click on the Insert tab. Click the Hyperlink button in the Links group.
3. The Insert Hyperlink dialog box appears. Click the Screen Tip button.
4. The Set Hyperlink ScreenTip dialog box appears. Specify the text that will appear when a user points to the hyperlinked object. In the ScreenTip text text box, type the screen tip. Click the OK button.
Answer option B is incorrect. The Mark as Final option is used to make a document read-only, so that all the proofing, typing, and editing commands become disabled. It is used to prevent the document from being changed.
Answer option A is incorrect. A comment is a tag that is used to provide additional information. A comment appears as a small rectangle containing information of the person who created the comment and a comment number. It is used to offer changes or suggestions to a slide.
Answer option C is incorrect. The IRM is used to grant access permissions to the users. It is used to protect the content from other users by providing only specific rights to them.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Multimedia
Question 6
You want to perform the following tasks to manipulate data before importing it into Access:
* Add fields.
* Combine fields.
* Use complex mathematical functions.
Which of the following is the best place to perform the above listed tasks?
Answer : D
A Microsoft Office Excel worksheet is the best place to perform the following tasks to manipulate data before importing it into Access:
* Add or remove fields.
* Combine or split fields.
* Use complex mathematical functions.
You can easily import a worksheet or a named range from a worksheet into a new table or an existing table. You can also import some particular fields from a worksheet or a named range into Access.
Answer options C, B, and A are incorrect. You can use these three places for importing data into Access, but all these have a complicated process of importing information.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Import, Export and Link data
Question 7
You type a document and you want to insert header from the third page. Which of the following techniques will you use to accomplish the task?
Answer : B
Section break divides a document in various sections so that different types of formatting can applied to different pages, e.g., if the document typed in portrait orientation and the image is to inserted in landscape orientation then the section break is used.
Answer option A is incorrect. Page break is a feature in which the text automatically moves to the next page when it encounters the end of the page. It is also known as soft page break. Page break can also be inserted manually. This is known as hard page break.
Answer option D is incorrect. This is not correct because it will insert header on all the pages. Answer option C is incorrect. Quick Style is a set of stored formats that are applied all at once anywhere in the document. Rather than choosing different types of formats every time and applying them, a user can create a Quick Style and apply it at other places in the same document or in other documents.
Chapter: ADVANCED WORD PROCESSING
Objective: Prepare Outputs
All Official Question Types