Advance Your Career by Using Online ECDL-ADVANCED Dumps

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

2. You work as an Office Assistant for Company Inc. You are preparing a document that contains multiple text boxes. Now you want to change the color of the textboxes to red. Mark the option/button in the following image of the Format tab that you will use to apply the color to all textboxes.

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

4. 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.

5. Which of the following functions will return the current system date and time?

6. Mark the option/button in the following image of the References tab to list the terms and topics that

are discussed in a document, along with the pages on which they appear.

7. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You add a picture from a file in the presentation.

Now, you want to change the contrast of the picture to 40 percent, as shown in the following image:





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

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

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

11. You are working with a query created in Microsoft Access 2010. Mark the button that you will click to perform the operations specified by the query.

12. 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.

13. John is typing a document and he wants to align the text in the center of the page .

What will he do to accomplish the task?

14. Mark the option/button in the following image of the design tab to apply a set of coloring attributes to a chart with one shortcut command.

15. You are working on a report created in Microsoft Access 2010. You want to set the orientation of the page to landscape. Mark the tab that you will click to accomplish the task.

16. Which type of formatting is responsible for the internal look of a document, such as shading, borders, numbering, and bullets?

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

18. Jasmine creates a presentation. The presentation comprises various controls. She wants to create a text box that comprises two columns .

Which of the following options will she use to accomplish the task?

19. You are working on your home computer with Microsoft Office 2010 installed on it. You have a table named Accessories created in Microsoft Office Access 2010. Now, you want to create a form from the table to get an organized and formatted view of all fields.

Choose and re-order the steps that you will take to accomplish the task.

20. You work as a Database Designer for Company Inc. The company uses Microsoft Access 2010 for creating and managing databases. You have created a database named Detail.

The database consists of a table named Employees with the following fields:

Employee Name

Employee ID

Department

Salary

You want to view a list of fields in the table.

In which of the following views will you open the table?

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

22. Which of the following steps will you take to move a slide from one open presentation to another? Each correct answer represents a complete solution. Choose all that apply.

23. Choose and reorder the required steps that you will take to move a slide from one presentation to another.

24. Which of the following properties allows a control to adjust its dimensions according to the contents present in the control?

25. Which of the following steps will you take to replace fonts?

26. Alan is a student of DFH Public School. He is creating a project report using Microsoft Excel XP. In the process of creating a project, he needs to frequently open a file that he has already created. Therefore, he wants to assign this file as a hyperlink to the 'Research' button on the Standard toolbar .

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

27. 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.

28. You work as an Office Assistant for Company Inc. You are using Microsoft PowerPoint 2010 for creating your presentation. You have inserted a table in the presentation. Now you want to change the color of the border. For this, you click on the Design tab under Drawing Tools. Mark the option/button in the following image of the Design tab on which you will click to change the color of the border.

29. You have created a PowerPoint presentation but due to some reason, you want to save that presentation in PDF .

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

30. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted a chart in the presentation. Now you want to display a box that identifies the patterns or colors that are assigned to the data series or categories in a chart. Mark the button in the following image to accomplish the task.

31. You work as an Office Assistant for OfficeWork Inc. You are creating a presentation in PowerPoint 2010. You have inserted a SmartArt graphic with the vertical bullet list layout. During the formatting in the SmartArt graphic, you have changed the shape of a bar of the SmartArt graphic. Now, you want to restore the original shape of the bar .

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

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

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

34. You work as an Office Assistant for Company Inc. You are creating a presentation named Inventory Data. Now you want to include both the portrait and landscape orientations in the presentation. Mark the option/button in the following image of the Insert tab that you will use to include both orientations in one presentation.





Answer:





Explanation:

To use both portrait and landscape orientations in a presentation, a user has to link two presentations to display both the portrait and landscape slides in what appears to be one presentation.

In order to create a link from the first presentation to the second and the second to the first, a user has to take the following steps:

Select the text or object that he wants to link to the other presentation. Click on the Insert tab > Links group > Action option.





On either the Mouse Click tab or the Mouse Over tab, click on the Hyperlink to drop-down list and select the Other PowerPoint Presentation option.





The Hyperlink to Other PowerPoint Presentation dialog box appears. Locate and click the second presentation, and then click the OK button.





In the Hyperlink to Slide dialog box, under Slide title, click the slide that a user wants to link to, and then click the OK button twice.





Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Slides



7 1. You are typing a document and you want the date of the creation of the document to appear on top of each page .

What will you do to accomplish the task?

35. You work as an Office Assistant for Company Inc. You are creating a presentation in which you want to identify a location or a selection of text which you can name and identify for future reference .

Which option/button in the following image of the Insert tab is used for future referencing?





Answer:





Explanation:

A bookmark in Word identifies a location or a selection of text. A bookmark is used for future reference.

Chapter: ADVANCED WORD PROCESSING

Objective: Referencing



8 1. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted some bullet points in the presentation. Now, you want to collapse the bullet points under the slide titles .

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

36. Mark the option/button in the following image of the Format tab to apply quick styles to Series 1 of the chart as shown below:









Answer:





Explanation:

A user can change the style of a chart element by using the Format tab of the Chart Tools tab.

Take the following steps to apply quick styles to a chart element:

Select the chart element.

The Chart Tools tab will be displayed containing the Design, Layout, and Format tabs.

Click on the Format tab.

Click the desired shape style from the Shape Styles drop-down list.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Charts/Graphs



19 1. Which option of Paste Special is used to link cells in different worksheets?

37. John prepares a document and inserts a table in the document to represent sales data. After creating the document, he decides to convert the table into text so that he can change its format to a bulleted list. Mark the option/button in the following Layout tab of Table Tools that he will use to convert the table into text.

38. Which of the following properties binds the forms and reports to a source from which data is to be

retrieved?

39. Which of the following steps will you take to add an AutoCorrect entry?

40. 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 graphics, tables, and equations in the document.

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

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

43. You work as an Office Assistant for TechWorld Inc. You use Microsoft Word 2010 for creating documents. You have recently created a document. You want to turn on the navigation pane so that you can navigate, search, and manipulate the structure and organization of headings. You have opened the open view menu to turn on the navigation pane. Mark the option/button on which you will click to turn on the navigation pane.

44. Which of the following are the ways to create a new blank presentation? Each correct answer represents a complete solution. Choose all that apply.

45. You work as an Office Assistant for Company Inc. You create a presentation. The presentation comprises various objects. You add an image from a file in the presentation.

Now, you want to remove the unwanted portions of the image to highlight the subject of the image or to remove the distracting detail, as shown in the following image:





You have clicked the Format tab of the Picture Tools. Mark the option/button in the following image to accomplish the task.

46. Which of the following are the types of action queries? Each correct answer represents a complete solution. Choose all that apply.

47. Which of the following is used to check a document for comments and annotations, document properties and personal information, custom XML data, invisible on-slide content, off slide content, and presentation notes?

48. You have opened an Access form in the Design view. The form has header and footer. You want to save the entire form as the report .

What will you do?

49. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted a photo album in it. Now, you want to change the color mode of the photos in the album to black and white. Choose and reorder the appropriate steps to change the pictures to black and white.

50. Which of the following properties binds the object to a source from which data is to be retrieved?

51. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted some pictures in the presentation. You want PowerPoint 2010 to use the picture file names as a placeholder for the caption text. Mark the appropriate option/button that you will use to use the file names as the caption text.

52. You work as an Office Assistant for Company Inc. You want to configure PowerPoint 2010 in such a way that it will notify you each time authors make changes. Instead of having changes merged with your presentations without notification, you want to review changes that other authors make to all PowerPoint 2010 presentations that you work on. For this, you have to click on File > Options. Click the button in the following image of the PowerPoint Options dialog box to accomplish the task.

53. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. The presentation comprises various pictures and clips. You want to add an alternative text on the slides for pictures and clips. You have selected the object and right-clicked on it. A shortcut menu appears. Mark the option in the following menu that you will use to add an alternative text.

54. Which of the following steps will you take to protect your worksheet from unauthorized access?

55. You work as an Office Assistant for Company Inc. You are assigned the task of preparing a document. You have inserted some bullet points in the document. Now you want to use the ampersand character as a symbol of bullet in the document .

Which steps will you take to accomplish the task?

56. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have inserted a photo album in it. Now, you want to change the color mode of the first photo in the album to black and white .

Which of the following actions will you take to change the color mode?

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

58. You have created a database named Addresses by using Microsoft Access 2010. You want to maintain the uniqueness of rows in the table .

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

59. Mark the option/button in the following image of the Format tab on which you will click to apply the denim texture to the wall of a chart.

60. Which of the following steps will you take to insert a caption to an image?

61. John is in the process of preparing a document. He wants to add a numbered list in it. Mark the icon that he should click to create the numbered list.

62. You work as an Office Assistant for Company Inc. You have created a presentation named Profit & Loss Report through PowerPoint 2010. Before presenting the presentation to your viewers, you want to set the size of the slide to 35mm and the screen orientation to portrait. Mark the correct button on the Design tab to accomplish the task.