Page: 1
/ 14
Total 232 questions
ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Questions
Question 1
James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named Sales. James imports Contacts table into the current database, which already contains a table by the same name. Which of the following actions will take place in this scenario?
Answer : D
If a table having the same name is imported from the other database into the current database, a new table is created with the same name followed by a number. For example, if Contacts table is imported from the other database into the current database, which already has a table with the same name, Contacts1 table will be created.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Import, Export and Link data
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 work as an Office Assistant for Company Inc. You are creating a presentation by using the Slide Master view. Now, you want to apply a hyperlink to the selected place holder text. However, you are unable to hyperlink the text. Which of the following actions will you take to resolve the issue?
Answer : A
The default place holders of the Slide Master view cannot apply a hyperlink. You have to create a text box, and then type the text to apply the hyperlink.
Answer option B is incorrect. Mark as Final is used to make a document read only, so that all the proofing, typing, and editing commands get disabled. It is used to prevent the document from being changed.
Answer option C is incorrect. 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.
Answer option D is incorrect. Encrypt Document is used to secure a presentation by using a password. It uses encryption to apply security settings.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Multimedia
Question 4
Which of the following paragraph-level formatting controls is used to prevent a single paragraph line from being stranded on a page all by itself?
Answer : D
Following are paragraph-level formatting controls:
* Widow/Orphan Control: It is used to prevent a single paragraph line from being stranded on a page all by itself.
* Keep with Next: It is used to force a paragraph to appear with the paragraph that follows.
* Keep Lines Together: It is used to prevent a paragraph from breaking across two pages.
* Page Break Before: It is used to force an automatic page break before the paragraph.
* Do not Hyphenate: It is used to instruct Microsoft Word not to perform hyphenation in a given paragraph.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting
Question 5
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 6
Which of the following queries is used to see the relationship of data between two fields?
Answer : D
A crosstab query is a powerful analysis tool used to see the relationship of data between two fields. It calculates and restructures data for easier analysis. A user can use a crosstab query to calculate a sum, average, count, or other type of total for data that is grouped by two types of information- one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query's calculation. This view is just like a spreadsheet with unique values of one field as rows, unique values of another field as columns, and the summary of another field as the cells in the matrix. How to create a crosstab query?
Take the following steps to create a crosstab query:
On the Open Recent Database page, click the required database.
On the database window, click the Create tab.
On the Create tab, click the Query Wizard.
On the New Query dialog box, select the Crosstab Query Wizard, and click the OK button.
On the Crosstab Query Wizard, select a table, and click the Next button.
On the Crosstab Query Wizard, the columns of the selected table are displayed in the Available Fields list box.
On the Crosstab Query Wizard, move the columns from the Available Fields list to the Selected Fields list by clicking on the > button. The >> button is not available in this wizard.
Click on the < button to move a field from the Selected Fields list to the Available Fields list. Click on the << button to move all the columns from the Selected Fields list to the Available Fields list. Select the Next button.
On the Crosstab Query Wizard, select the View the query radio button, and click the Finish button.
The result of the query will be saved and displayed in the database window.
Answer option A is incorrect. A parameter query prompts a user for information to be used in the query.
Answer option B is incorrect. A select query is used to retrieve data from one or more tables. It is used to display the results in a datasheet.
Answer option C is incorrect. An action query is used to update multiple records in one operation.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design
Question 7
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
All Official Question Types