Choose ECDL-ADVANCED New Dumps to Prepare for the ECDL/ICDL Advanced Certification Exam

1. Which of the following statements will you use to delete a table from a database?

2. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010.

You have created a button in the presentation. You want a program to run when you click on the button or hover your mouse over it during the slide show .

Which of the following will you use to accomplish the task?

3. Mark the option/button in the following image of the Format tab on which you will click to apply the effect to a textbox.

4. Which of the following is a list of the references in a legal document, such as cases, statutes, and rules, along with the page numbers on which the references appear?

5. You work as an Office Assistant for BlueSoft Inc. You use Microsoft Word 2010 for creating documents. You need to change the orientation of the page from portrait to landscape. Mark the tab that you will use to accomplish the task.

6. Which of the following steps will you take to remove background of slides?

7. Which of the following view types allows a user to manipulate data on the form created in Access 2010?

8. You work as an Office Assistant for Company Inc. You are using Word 2010 to create a document.

Mark the option/button in the following image that you would click to browse a document by its heading.

9. You work as an Office Assistant for Company Inc. You are creating a presentation in Microsoft PowerPoint 2010. You have inserted a chart in your presentation. After creating the presentation, you want to change the chart type, so that the chart will work well with the format of the presentation. Choose and reorder the steps that you will take to change the chart type.

10. John works as an Office Assistant for InfoTech Inc. He is assigned the task of creating electronic business cards for his colleagues. There are about 200 employees in the company. Now he wants to assign passwords to these cards so that only reviewers who know the password can remove the protection .

Which of the following tabs is used by John to assign a password to the template?

11. Which of the following form contextual ribbons includes groups that can manage control groups, set text margins and padding for controls, toggle the Snap to the Grid layout feature, set tab order, align controls, and display Property Sheet?

12. You want to customize the presentation of data extracted from queries or tables that are created in Microsoft Office Access 2010 .

Which of the following database objects will you use to accomplish the task?

13. Which of the following is used to show a timeline when an animation effect is being played?

14. You work as an Office Assistant for Company Inc. You are creating a presentation named Sales. Now, you want to add a slide that contains the content of an existing slide in a presentation. Choose and reorder the steps that you will take to insert the slides from the existing presentation.

15. Alan works as a Sales Manager for Star Inc. He is creating a report using Microsoft XP to put it on the company's Website. The report contains several hyperlink text assigned with different document destinations. By default, the color of hyperlink text is blue but according to the company's convention it should be dark red. Therefore, he wants to change the color of all hyperlink text to dark red. Choose the option that he will use to accomplish the task.

16. Which of the following is used to count the number of cells and arguments that consist of numbers?

17. You work as an Office Assistant for Company Inc. You create a presentation and insert an image from a file in it.

Now, you want to change the shape of the image, as shown in the following image:

You have clicked the Format tab under Picture Tools. Mark the option/button that will you use to accomplish the task.

18. Which slide orientation type is used when a user wants a slide in vertical format?

19. You work as an Office Assistant for BlueSoft Inc. You use Microsoft Word 2010 for official work. You

have created a document and have applied Word 2003 style spacing to your document so that it looks familiar with your Word document data. Now you want to set the current font and paragraph attribute as the default attribute for all new documents. You click on the Home tab.

Mark the button on which you will click to accomplish the task.

20. You create a presentation and insert an image from a file in it.

Now, you want to apply Aqua Accent Color 5 Dark variation to the image, as shown in the following image:

You have selected the image and clicked the Format tab under Picture Tools.

Mark the option/button in the following image that you will use to recolor the image?

21. Mark the option/button in the following image of the Layout tab on the Chart Tools tab to resize the shape of the chart area of a chart.

22. 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?

23. Which of the following functions is used to round a number to a specified number of digits?

24. 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?

25. Which of the following is used for extraction from one or more tables in a database that can be used as the basis of a report or as a standalone information source?

26. 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?

27. Which of the following functions is used to verify whether or not an argument has been passed to a procedure?

28. You work as an Office Assistant for Company Inc. You create a presentation on daily work report. Twenty minutes before you are supposed to present the report to the team, your manager asks you to add four new sections to the report. You spend thirteen minutes adding the information, and the next seven wishing that you had not chosen such complicated formatting for your headings. Since, now you have to apply the similar format to all the new ones .

Which of the following will you choose to apply the similar format to the new information that saves time and duplication effort?

29. You are working on an Access report named Staffs. You need to apply a layout to the report. The layout should be similar to a spreadsheet, with labels across the top and data in columns below the labels.

Mark the tab/button that you will click to accomplish the task.

30. Which of the following steps will you take to ensure that field controls can be neither edited nor deleted?

31. Which of the following steps will you take to arrange slides? Each correct answer represents a part of the solution. Choose all that apply.

32. You work as an Office Assistant for Company Inc. You are creating a presentation in Microsoft PowerPoint 2010. You have inserted a chart in the presentation. You want to insert a chart title on the chart in which preset color is RainbowII .

Which of the following options will you take to move the fill color to linear diagonal?

33. You work as an Office Assistant for Company Inc. You use Microsoft Word 2010 for official work. You have created a document and you want to insert a predefined table calendar with large month names and thick week separators. Choose and reorder the required steps to insert the quick table.

34.

35. The Insert Hyperlink dialog box opens. Specify the file or item to be linked, and then click the OK button.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Charts/Graphs

4 1. Mark the option/button in the following image of the Layout tab to display a set of related data points that are plotted in a chart.

36. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have added a title in the presentation.

Now, you want to change the effect of the title to Accent 1, as shown in the following image:

Which of the following will you use to accomplish the task?

37. 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?

38. You work as an Office Assistant for Company Inc. You are creating a presentation and you have inserted a photo album in it. Now, you want to change the frame shape of the photo album to Soft Edge Rectangle. Mark the option/button on the Insert tab that you will use to change the frame shape.

39. Which of the following steps will you take to put a fill effect background on a presentation? Each correct answer represents a complete solution. Choose all that apply.

40. 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?

41. You work as an Office Assistant for Creative World Inc. You are creating a presentation for a new product through PowerPoint 2010. You have created a MyVideo.mpeg file, which contains all the photos related to the new product. Now, you want to add the .mpeg file to the presentation. Mark the correct option on the Insert tab to insert the .mpeg file.

42. You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to automate the import and export operations available on the External Data tab while working on Microsoft Office Access 2010 .

Which of the following actions will you perform to accomplish the task?

43. You work as an Office Assistant for InfoTech Inc. You are creating a presentation on an employee form of Luxury Inc. You want the text of the text box to rotate 180 degree .

Which of the following steps will you take to accomplish the task?

44. Which of the following steps will you take to enforce referential integrity for an existing relationship?

Each correct answer represents a part of the solution. Choose all that apply.