Dumpsinfo ECDL-ADVANCED Exam Dumps

Text Material Preview

ECDL-ADVANCED ECDL/ICDL Advanced exam dumps questions are the best
material for you to test all the related ECDL exam topics. By using the ECDL-
ADVANCED exam dumps questions and practicing your skills, you can increase
your confidence and chances of passing the ECDL-ADVANCED exam.
Features of Dumpsinfo’s products
Instant Download
Free Update in 3 Months
Money back guarantee
PDF and Software
24/7 Customer Support
Besides, Dumpsinfo also provides unlimited access. You can get all
Dumpsinfo files at lowest price.
ECDL/ICDL Advanced ECDL-ADVANCED exam free dumps questions are
available below for you to study. 
Full version: ECDL-ADVANCED Exam Dumps Questions
1. Choose and reorder the steps required to insert a chart in a presentation.
 1 / 58
https://www.dumpsinfo.com/unlimited-access/
https://www.dumpsinfo.com/exam/ecdl-advanced
Answer:
• 1
Click on the Insert tab.
• 2
In the Illustrations group, click Chart.
• 3
The Insert Chart dialog box appears.
• 4
Click the arrows to scroll through the chart types.
• 5
Select the type of chart that you want to insert, and then click the OK button.
• 6
Edit the data in Excel 2010.
Explanation:
The Chart button under the Insert tab is used to insert a chart in a presentation. Take the following
steps to insert a chart in a presentation:
Click on the Insert tab. In the Illustrations group, click Chart.
The Insert Chart dialog box appears.
Click the arrows to scroll through the chart types. Select the type of chart that you want to insert, and
then click the OK button.
Edit the data in Excel 2010.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs
2. Select the Enforce Referential Integrity check box.
3. Under Picture Tools, click the Format tab. In the Adjust group, click the Background Removal
option.
4. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint
2010. You added a photo album in it. Now, you want to add captions to all the photographs. To
achieve the desired result, you have to check the Captions below All Pictures check box of the Edit
Photo Album dialog box. However, the check box is disabled .
Which of the following is the cause of the issue?
A. You have increased the brightness of the picture.
 2 / 58
https://www.dumpsinfo.com/
B. You have selected the Fit to Slide layout option in the Picture Layout list.
C. You have selected the 2Pictures layout option in the Picture Layout list.
D. You have selected a Rounded Rectangle frame shape.
Answer: B
Explanation:
If the Fit to slide layout option is selected in the Picture Layout drop-down list of the Album Layout
section, the Captions below All pictures check box is unavailable and greyed out.
Answer option A is incorrect. The Captions below All Pictures check box will not be affected by the
brightness of the picture.
Answer option D is incorrect. The Captions below All Pictures check box will not be affected by the
frame of the picture.
Answer option C is incorrect. If a user selects the 2Pictures layout option, the Captions below All
Pictures check box will be enabled.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Pictures, Images, Drawn Objects
5. 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.
 3 / 58
https://www.dumpsinfo.com/
Answer:
Explanation:
A PowerPoint photo album is a collection of photographic presentation slides. It is a presentation that
a user can create to display his personal or business photographs. In order to change the frame
shape of the photo album, you have to edit the photo album. Take the following steps to edit a photo
album:
Click on the Insert tab. In the Images group, click the arrow under Photo Album, and then click the
Edit Photo Album option.
The Edit Photo Album dialog box appears.
 4 / 58
https://www.dumpsinfo.com/
Specify the settings that you want to apply, such as frame shape. Click the Update button.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Pictures, Images, Drawn Objects
6. Align Text: It is used to change the alignment such as top, middle, bottom, etc. of the text. It
specifies how the text is aligned in a text box.
7. You work in an office and you are assigned the task of preparing a document. You insert a table in
the document and your document has a number of objects. You want to use gridlines for proper
alignment between objects. For this, you have to display gridlines of the table. However, clicking the
 5 / 58
https://www.dumpsinfo.com/
Borders button on the Design tab will not help in displaying the gridlines .
Which of the following is the cause of the issue?
A. You are viewing the document in Print Layout view.
B. You are viewing the document in a Web browser.
C. You are viewing the document in Draft view.
D. You are viewing the document marked as final.
Answer: B
Explanation:
Gridlines are used to show cell boundaries of a table on the screen. These gridlines will display where
the table does not have borders. They appear only on the screen where they are not printed. The
user cannot see the changes wherever the gridlines are behind the borders if you hide the gridlines in
a table that has these borders by default. All tables have black 1/2 point, single-line, solid-line borders
that are printed. In order to view the gridlines, remove the borders. If the user is viewing a document
in the Web browser, gridlines will never be visible.
Answer options C and A are incorrect. You can view gridlines of a table in the Draft and Print Layout
views. The Draft view is used to view the document as a draft to allow a user to quickly edit the text.
Headers and footers are not visible in this view. The Print Layout view is used to view a document as
it would appear on a printed page.
Answer option D is incorrect. The gridlines of a table are not affected by the use of the mark as final
feature.
Answer options C and A are incorrect. You can view gridlines of a table in the Draft and Print Layout
views. The Draft view is used to view the document as a draft to allow a user to quickly edit the text.
Headers and footers are not visible in this view. The Print Layout view is used to view a document as
it would appear on a printed page.
Answer option D is incorrect. The gridlines of a table are not affected by the use of the mark as final
feature.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting
8. In order to change the chart type of a data series, click the data series.
9. Which of the following steps will you take to arrange slides? Each correct answer represents a part
of the solution. Choose all that apply.
A. Select a slide and drag it to the desired location.
B. The selected slide will be moved to the new location.
C. On the Home tab, click the Normal view.
D. On the View tab, click the Slide Sorter view.
Answer: D, A, and B
Explanation:
Take the following steps to arrange slides:
On the View tab, click the Slide Sorter view.
 6 / 58
https://www.dumpsinfo.com/
Select a slide and drag it to the desired location.
The selected slide will be moved to the new location.
 7 / 58
https://www.dumpsinfo.com/
Answer option C is incorrect. It is not a correct step to arrange a slide.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Arrange slides" Chapter: PRESENTATION,
ADVANCED - LEVEL Objective: Managing Presentations
10. In the Navigation pane, click the Browse the headings in your document button. To go to a
heading in your document, click heading.
Chapter: ADVANCED WORD PROCESSING
Objective: Formatting
11. You have created a database named Sales. The database consists of a table named Employees.
You
want to ensurethat all names of the employees should be displayed while filling a form .
Which of the following controls will you use to accomplish the task?
A. Label
B. Textbox
C. Combobox
D. Listbox
Answer: C and D
Explanation:
You will use the listbox and combobox controls. When these controls are bound to a column of a
table, all data of that column is displayed in these controls. You cannot edit or delete the data from
these controls. You can only view the data.
Answer option B is incorrect. The textbox control is bound to a column but it displays only one record
 8 / 58
https://www.dumpsinfo.com/
at a time. According to the scenario, you want to ensure that all names of the employees should be
displayed and the textbox control will not accomplish this task.
Answer option A is incorrect. The label control does not have the ControlSource property so it cannot
be bound to any column of any table. A label is used to provide a name to a bound control.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Form" Chapter: DATABASE, ADVANCED-
LEVEL
Objective: Form Design
18 1. Jasmine is creating a presentation. When she selects a textbox and starts typing, the existing
text is not replaced with what she has typed .
Which of the following is the most likely cause of the issue?
A. She selects the border of the text box and starts typing.
B. She selects the text box and delete it.
C. She selects the slide and starts typing.
D. She selects the text of the text box and starts typing.
Answer: A
Explanation:
Whenever she selects the border of a text box, she will not be able to write a text in it. Answer option
D is incorrect. When she selects the text of the text box, she will be able to overwrite the existing text.
Answer option C is incorrect. When she selects the slide, she will be able to apply various formats
and animations.
Answer option B is incorrect. When she deletes the text box, the selected text will be automatically
deleted.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Design Considerations
12. 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?
A. Entity
B. Domain
C. Data
D. Referential
Answer: A
Explanation:
Entity integrity enforces the uniqueness of rows in a table. The uniqueness of rows can be enforced
by the identifier column(s) through indexes, UNIQUE constraints, PRIMARY KEY constraints, or
IDENTITY properties.
Answer option D is incorrect. Referential integrity means that the foreign key in any referencing table
must always refer to a valid row in the referenced table. Referential integrity ensures that the
relationship between two tables remains synchronized during updates and deletes. For a foreign key
to be valid, it must contain either the value NULL, or an existing key value from the primary or unique
key columns referenced by the foreign key. To enforce referential integrity, a foreign key column link
to the primary key column should be created in the related table.
Answer option C is incorrect. Data integrity is a mechanism that ensures that the data is not modified
during transmission from source to destination. This means that the data received at the destination
should be identical as that sent from the source. In order to maintain data integrity, the data values
must be within a defined range and in the correct format. For example, the value of an employee's
age must be within the range of 20-60 years, which means that the age cannot be below 20 years
and more than 60 years.
Answer option B is incorrect. Domain integrity enforces data validity by restricting the data type, valid
 9 / 58
https://www.dumpsinfo.com/
values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY
constraints) for columns in a table.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Entity integrity"
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design
13. 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?
A. Clip Art
B. SmartArt
C. WordArt
D. Custom Animation
Answer: C
Explanation:
WordArt is an artistic formatting tool that is used to produce special effects. The WordArt objects are
drawing objects that cannot be taken as text. It is a gallery of text styles that can be used to create
decorative effects, such as shadowed or mirrored (reflected) text. It allows a user to use various
stylized effects, texture, and format, such as curved, three-dimensional, rotate, and bend. While using
it in Word and PowerPoint, a user can also convert existing text into WordArt. The WordArt objects
can be moved or positioned in the document to add decoration or emphasis. A user can modify or
add to the text in an existing WordArt object whenever he wants.
Answer option B is incorrect. SmartArt is a visual graphic. It is used to represent the information
effectively and efficiently. These graphics use a specific set of algorithms that provide different layout
options, including a linear flow algorithm, a cycle algorithm, and two algorithms that work together to
create a hierarchy diagram. It is used to create designer-quality illustrations. A user can increase the
emphasis of information by adding SmartArt. Though SmartArt graphics audience of a presentation
can understand and recall information better than a text, it is necessary to visualize what type and
layout are best for displaying data, and what does a user want to convey with a SmartArt graphic. A
user can quickly convert slide text to a SmartArt graphic. In addition, a user can add animation to a
SmartArt graphic in Office PowerPoint 2010 presentations. Answer option A is incorrect. Clip Art is
used to make the presentations attractive.
Answer option D is incorrect. Custom animation is a powerful and dynamic tool of Microsoft
PowerPoint. It allows a user to determine how the objects of a slide appear during a slide show. It
comprises a list of effects such as blinds, diamonds, etc. These effects are used to be applied on the
objects.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Multimedia
 10 / 58
https://www.dumpsinfo.com/
14. 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.
Answer:
 11 / 58
https://www.dumpsinfo.com/
Explanation:
The new Navigation pane helps you find text, tables, graphics, comments, footnotes or endnotes, and
equations in a document. Users can view thumbnail images of document pages. They can also
browse through their document by its headings.
Take the following steps to use Browse By buttons of the navigation pane:
15. Which of the following datatypes cannot be filtered by using common filters? Each correct answer
represents a complete solution. Choose two.
A. Hyperlink
B. OLE Object
C. Calculated Field
D. AutoNumber
Answer: B and C
Explanation:
The following datatypes cannot be filtered by using common filters:
OLE Object: The OLE Object datatype is used to attach files and add binary data to a table. This
datatype stores each data in a bitmap format. This results in an increase in the size of a database file.
Only a single file can be added to each row of a table. The files attached can be Microsoft Office files,
graphics files, sound files, pdf files, etc.
Calculated Field: The Calculated Field datatype is used to store the results of a calculation. The
calculation should refer to other fields created in the same table. In order to create the calculation, a
user can use the Expression Builder that provides the use of IntelliSenseand an easy way to access
expression values.
Answer options A and D are incorrect. These datatypes can be filtered by using common filters. The
Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network
 12 / 58
https://www.dumpsinfo.com/
file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table
contains only one hyperlink.
The AutoNumber datatype is used for inserting a number automatically and incrementing it by one
when a new record is inserted in a table. The increment can be changed through the New Values
property. This property has the following two values: Increment Random
Reference: http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design
16. The Chart Tools tab will be displayed containing the Design, Layout, and Format tabs.
17. Mark the option/button in the following image of the Format tab on which you will click to apply the
effect to a textbox.
Answer:
Explanation:
A text box is a control that is rectangular in shape. A text box has a border that separates it from the
rest of the interface. A user can type the text inside a text box and resize it also according to his need.
Take the following steps to add shape effects to a text box: Select the text box.
Click the Format tab under Drawing Tools.
Click the Shape Effect button in the Shape Styles group.
 13 / 58
https://www.dumpsinfo.com/
The Shape Effects drop-down list opens. Select an effect to be applied.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides
18. Mark the option that you will choose to move all sides of selected controls in or out to meet the
nearest point on the grid.
 14 / 58
https://www.dumpsinfo.com/
Answer:
 15 / 58
https://www.dumpsinfo.com/
Explanation:
The various commands available in the Size and Ordering group that are helpful in arranging the
controls are as follows:
To Fit: It is used to adjust control height and width for the font of the text.
To Tallest: It is used to make selected controls the height of the tallest selected control.
To Shortest: It is used to make selected controls the height of the shortest selected control.
To Grid: It is used to move all sides of selected controls in or out to meet the nearest point on the grid.
To Widest: It is used to make selected controls the width of the widest selected control.
To Narrowest: It is used to make selected controls the height of the narrowest selected control.
Reference: http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design
19. Which of the following options will you use to recognize the changes made by another person to
 16 / 58
https://www.dumpsinfo.com/
your document?
A. Add comment
B. Insert caption
C. Make changes in another new document
D. Enable Track Changes
Answer: D
Explanation:
Take the following steps to enable Track Changes in a document:
Open the document in which the Track Changes option is to be enabled.
Go to the Review tab.
Click on the Track Changes drop down icon from the Tracking group.
Select the Track Changes option from the list.
Answer option A is incorrect. Take the following steps to add a comment to a document:
Select the text to which comment is to be added.
Go to the Review tab.
Click on New Comment from the Comments group.
 17 / 58
https://www.dumpsinfo.com/
Type the comment text in the comment balloon or reviewing pane that appears.
Answer option B is incorrect. Take the following steps to insert a caption to an image:
Insert an image from the Picture option in the Insert tab.
Go to the References tab and click the Insert Caption option to open the Caption dialog box.
 18 / 58
https://www.dumpsinfo.com/
In the Caption text box, fill the caption, and click the OK button.
 19 / 58
https://www.dumpsinfo.com/
Answer option C is incorrect. It is not a correct option to recognize the changes made by another
person to your document.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Track Changes"
Chapter: ADVANCED WORD PROCESSING
Objective: Collaborative Editing
20. Which of the following properties binds the object to a source from which data is to be retrieved?
A. RecordSource
B. TextFormat
C. RowSource
D. ControlSource
Answer: A
Explanation:
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
 20 / 58
https://www.dumpsinfo.com/
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.
Reference: ECDL/ICDL Exam Course Manual, Contents: "RecordSource property"
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design
21. 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.
Answer:
• Click on the Insert tab.
• Click Photo Album.
• Select Edit Photo Album.
• Select the All Pictures black and white check box.
• Click the Update button.
Explanation:
A PowerPoint photo album is a collection of photographic presentation slides. It is a presentation that
a user can create to display his personal or business photographs. A user can either download
PowerPoint photo album templates from Microsoft Office.com or create his own. A user can change
the pictures of a photo album to black and white by editing the photo album. Take the following steps
to insert images in black and white:
Click on the Insert tab. Click Photo Album > Edit Photo Album.
 21 / 58
https://www.dumpsinfo.com/
The Edit Photo Album dialog box appears. Select the All Picture black and white check box. Click the
Update button.
The Color button is used to change the color tone of a picture. Chapter: PRESENTATION,
ADVANCED - LEVEL Objective: Slides
22. Click the Format tab, and then click the Crop button.
23. One-to-one
24. You work as an Office Assistant for Company Inc. You are creating a presentation named
OrganizationWorkflow.pptx through PowerPoint 2010. The presentation contains different slides for
 22 / 58
https://www.dumpsinfo.com/
each department of the organization. You want to use an outline from a Microsoft Word 97-2003
document (.doc) for creating a presentation based on an existing report or other outlined document.
Mark the option/button in the following image of the Home tab to accomplish the task.
Answer:
Explanation:
A user can insert an outline text from another program into a PowerPoint presentationby using the
outline text. The outline feature is helpful for creating a presentation based on an existing report or
other outlined document. A user can use the outline structure of a document by inserting the
document into PowerPoint 2010. The text in the presentation will be formatted based on heading
styles set in the original outlined document or file when a user inserts and uses an outline from a
Microsoft Word 97-2003 document (.doc), a Word 2010 or 2007 document (.docx), a text file (.txt), or
a rich text format file in a PowerPoint 2010 presentation. Take the following steps to insert an outline
text from another program into your PowerPoint presentation:
Click on the Home tab. Click the small down arrow next to New Slide in the Slides group.
Click the Slides from Outline option.
 23 / 58
https://www.dumpsinfo.com/
The Insert Outline dialog box opens. Specify the file that contains the outline for the presentation.
The file opens in PowerPoint.
 24 / 58
https://www.dumpsinfo.com/
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides
25. In the Navigation pane, click the Browse the pages in your document button. To go to a page in
the document, click the thumbnail image.
26. Click on the Format tab. In the Current Selection group, click the Format Selection option.
27. Many-to-many
The relationship fields in the bean class are represented using the abstract get and set methods.
Reference: http://office.microsoft.com/en-us/access/ha101205341033.aspx#1
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design
28. Press the ESC key.
29. 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.
 25 / 58
https://www.dumpsinfo.com/
Answer:
Explanation:
An index is a list of words arranged alphabetically at the end of a book. Index helps a reader to find
the information quickly and easily. The words in the index given along with the page numbers where
they occur to help the reader to quickly go to the desired word.
Take the following steps to create an index:
Click the location where you want to add the index. Click on the References tab, and click the Insert
Index button in the Index group.
Click a design in the Formats box to use one of the available index designs. In the Formats box, click
From template, and then click Modify to specify the formatting options. Select any other index options
that you want to apply. Click the OK button.
 26 / 58
https://www.dumpsinfo.com/
Note: It is preferable to mark the entries for the index in a document before creating an index.
Chapter: ADVANCED WORD PROCESSING
Objective: Collaborative Editing
30. Which of the following functions is used to return the current system date?
A. Month
B. Now
C. Today
D. Year
Answer: C
Explanation:
The Today function is used to return the current system date.
Answer option B is incorrect. The Now function is used to return the current system date and time.
Answer option A is incorrect. The Month function is used to return the month (a number from 1 to 12)
given a date value.
Answer option D is incorrect. The Year function is used to return a four-digit year (a number from
1900 to 9999) given a date value.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Excel functions"
Chapter: ADVANCED SPREADSHEETS
 27 / 58
https://www.dumpsinfo.com/
Objective: Functions
14 1. 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. The computer has a database named
Institutes created in Microsoft Office Access 2010. You want to import a word document named
Students to an Access file named Library .
What will you do to accomplish the task?
A. Choose the Word Merge option from the Import & Link group.
B. Save the document as a text file and then import it.
C. Link the word document to the Access file.
D. Copy and paste the word document to the destination file.
Answer: B
Explanation:
In order to accomplish the task, you should save the word document as a text file and then import this
file from the Import & Link group. You cannot directly import a word document to an Access file.
Answer option A is incorrect. There is no option for importing a word document in the Import & Link
group. The Word Merge option is displayed in the Export group.
Answer option D is incorrect. You cannot import a word document by this way.
Answer option C is incorrect. Access does not allow linking a word document.
Reference: http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Import, Export and Link data
31. 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:
 28 / 58
https://www.dumpsinfo.com/
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?
A. Format Link
B. Paste Link
C. Paste Format
D. Link Cell
Answer: B
Explanation:
The Paste Link button is used to link cells in different worksheets.
Take the following steps to link cells in different worksheets:
Select and copy the cells that you want to link to the other worksheet.
 29 / 58
https://www.dumpsinfo.com/
Select the desired destination in another worksheet.
 30 / 58
https://www.dumpsinfo.com/
Click the Paste drop down icon, select the Paste Special option, and click the Paste Link button.
 31 / 58
https://www.dumpsinfo.com/
 32 / 58
https://www.dumpsinfo.com/
If you take a look at the resulting formula, it will include the filename, sheet name, and cell reference
to the original data.
 33 / 58
https://www.dumpsinfo.com/
Answer options A, D, and C are incorrect. These are not valid options of Paste Special.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Paste Link" Chapter: ADVANCED
SPREADSHEETS
Objective: Data Handling
32. You work as an Office Assistant for InfoTech Inc. You are creating a presentation named
ChemicalReaction.pptx in PowerPoint 2010. You have used the vertical equation SmartArt graphic for
describing the chemical reactions, and now you want to change the shape of the SmartArt graphic in
the slide in the following way:
Which of the following steps will you take to accomplish the task?
A. Use the Format tab > Change Shape button.
 34 / 58
https://www.dumpsinfo.com/
B. Use the Format tab > Shape Styles group.
C. Use the Design tab > SmartArt Styles group.
D. Use the Design tab > Layouts > More button.
Answer: D
Explanation:
In order to change the overall shape of a SmartArt graphic, you have to select the SmartArt graphic,
click the More button in the Layouts group of the Design tab, and then select the desired SmartArt
layout as shown in the following image:
Answer option A is incorrect. The Change Shape button of the Shapes group on the Format tab is
used to change the shape of a specific object in a SmartArt graphic while preserving all the
formatting.
Answer option C is incorrect. The SmartArt Styles group is used to apply the built-in SmartArt styles
to a SmartArt graphic.
Answer option B is incorrect. The Shape Styles group on the Format tab is used to apply the shape
fill,
outline, and shape effects to a SmartArt graphic.Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Multimedia
3 1. You work as an Office Assistant for InfoTech Inc. You are creating a presentation through
PowerPoint 2010. You want to customize the alignment of the text in a textbox, so that it appears in
the middle. Mark the option that you will choose to accomplish the task.
Answer:
 35 / 58
https://www.dumpsinfo.com/
Explanation:
The Align Text button of the Paragraph group is used to change the alignment (top, middle, bottom,
etc.) of the text. It specifies how the text is aligned in a text box. The Paragraph group belongs to the
Home tab. This group is used to specify indent, spacing, and text formatting for a specific slide.
The following are the buttons of the Paragraph group:
33. Which of the following view types allows a user to manipulate data on the form created in Access
2010?
A. Datasheet view
B. PivotTable view
C. Form view
D. PivotChart view
Answer: C
Explanation:
The Form view is a default view type for an Access form. It allows a user to manipulate data on the
form.
 36 / 58
https://www.dumpsinfo.com/
Answer option A is incorrect. The Datasheet view displays the data in the table format. Answer option
D is incorrect. The PivotChart view allows a user to display the data of a form as pivot charts.
Answer option B is incorrect. The PivotTable view allows a user to display the data of a form as a
pivot table.
Reference: http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design
34. Edit theme
35. Which of the following is the reason for occurrence of the Type mismatch in expression error?
A. The record in the first column is deleted in the primary key table.
B. Incorrect table is used.
C. When the datatypes of a primary key column and the foreign key column joining the two tables are
assigned to different datatypes.
D. Incorrect database is used.
Answer: C
Explanation:
The Type mismatch in expression error occurs when the datatypes of a primary key column and the
foreign key column joining the two tables are assigned to different datatypes. To troubleshoot this
 37 / 58
https://www.dumpsinfo.com/
error, both the fields must have same datatype.
Answer options B, A, and D are incorrect. These are not valid reasons for occurrence of this error.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Type mismatch in expression" Chapter:
DATABASE, ADVANCED-LEVEL
Objective: Query Design
36. The Crop drop-down list opens. Click the Crop to Shape option and select the shape. Chapter:
PRESENTATION, ADVANCED - LEVEL
Objective: Pictures, Images, Drawn Objects
37. Click the Format tab under Picture Tools. Click the Artistic Effects button under the Adjust group.
38. Which of the following steps will you take to create a blank presentation? Each correct answer
represents a complete solution. Choose all that apply.
A. Click the Home tab, select the New option, and then click the Blank Presentation option.
B. Double-click on the selected theme and it will appeare for the slide.
C. Click the Design tab and select a theme from the theme gallery.
D. Click the Presentations tab, select the New option, and then click the Blank Presentation option.
Answer: C and B
Explanation:
Take the following steps to create a blank presentation:
Click the Design tab and select a theme from the theme gallery.
Double-click on the selected theme and it will appear for the slide. The blank presentation is created.
 38 / 58
https://www.dumpsinfo.com/
Answer options A and D are incorrect. These are not correct steps to create a blank presentation.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Blank presentation" Chapter:
PRESENTATION, ADVANCED - LEVEL
Objective: Managing Presentations
39. You work as a Support Analyst for Soft Well Inc. You create a presentation for a business
meeting. The business meeting is going to be held between you and some Chinese associates. You
write some information on the slides of the presentation in English language. After writing the
concepts, you want to use the Chinese language instead of English language, so that it can be better
understandable by the meeting attendees. Mark the appropriate sign to accomplish the task.
Answer:
Explanation:
By using the Translate option under the proofing group, a user can translate the text to the Chinese
language. In order to change the language, you have to just click the Translate option.
The Research Task Pane will open, then specify the language and click the Go button as shown in
the following image:
 39 / 58
https://www.dumpsinfo.com/
The Spelling, Thesaurus, Language, and Research option cannot be used in the given scenario.
The Spelling option is used to check the spelling of the selected text. The Thesaurus option is used to
suggest the synonym of a selected text. The Language option is used to check the spelling and
grammar of the selected text. The Research option is used to open the Research Task Pane to
search a selected text through reference materials, encyclopedias, etc. Chapter: PRESENTATION,
ADVANCED - LEVEL
Objective: Design Considerations
40. Choose and reorder the required steps that you will take to move a slide from one presentation to
another.
 40 / 58
https://www.dumpsinfo.com/
Answer:
Correct Steps:
Click on the Slide Sorter view.
Drag the slide from one presentation to another.
Click the Arrange All button.
Explanation:
Take the following steps to move a slide from one open presentation to another:
Open the presentations in the Slide Sorter view.
On the View tab. Click the Arrange All button in the Window group.
 41 / 58
https://www.dumpsinfo.com/
Drag the slides from one presentation to another.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Design Considerations
41. 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 flip the position of a photograph to
horizontal. Mark the option in the following Format tab image that you will use to flip the photograph.
 42 / 58
https://www.dumpsinfo.com/
Answer:
Explanation:
A PowerPoint photo album is a collection of photographic presentation slides. It is a presentation that
a user can create to display his personal or business photographs. A user can either download
PowerPoint photo album templates from Microsoft Office.com or create his own.
A user can also add effects to provide transition effect while creating a photo album in PowerPoint. A
user can add captions, adjust the order and layout, add frames around the pictures, and even apply a
theme to modify the look of the album after adding pictures to the album.
A user can rotate a photograph by one of the following two ways:
By using the Edit Photo Album dialog box:
Click the Insert tab. Click the drop-down list of the Photo Album button. Select the Edit Photo Album
option.
The Edit Photo Album dialog box opens. Select the photo, click the Rotate button, and then click the
Update button.
 43 / 58
https://www.dumpsinfo.com/
By using the Rotate button:
Select the photo. Click on the Format tab. Click the Rotate button and specify the rotation options.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Pictures, Images, Drawn Objects
16 1. Which of the following functions is used to add all numbers in a range of cells, based on a given
criteria?
A. SumSq()
B. SumProduct()
C. SumIf()
D. Sum()
Answer: C
 44 / 58
https://www.dumpsinfo.com/
Explanation:
The SumIf function is used to add all numbers in a range of cells, based on a given criteria. Answer
option B is incorrect. The SumProduct function is used to multiply the corresponding items in the
arrays and return the sum of the results.
Answer option A is incorrect.The SumSq function is used to return the sum of the squares of a series
of values.
Answer option D is incorrect. The Sum function is used to add all numbers in a range of cells and
return the result.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Spreadsheet functions"
Chapter: ADVANCED SPREADSHEETS
Objective: Functions
42. Page setup
43. 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?
A. Reuse Slides
B. Hyperlink
C. Action
D. Set Up Slide Show
Answer: C
Explanation:
The Action icon feature is used to apply an action to the selected object in a slide to indicate what
should happen when a user clicks on the object or hovers his mouse over it.
Take the following steps to run a program in a presentation:
44. 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?
 45 / 58
https://www.dumpsinfo.com/
Answer:
Explanation:
The Color button comprises a Recolor group to recolor the image to give it a stylized effect. Take the
following steps to change the color of an image:
45. 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.
Answer:
 46 / 58
https://www.dumpsinfo.com/
Explanation:
The Style option on the Format menu will open the Style dialog box. This dialog is used to change the
appearance of hyperlink text in a current workbook.
Perform the following steps in the Style dialog box to change the appearance of hyperlink text:
In the Style dialog box, select Hyperlink style in the Style name box, and then click the Modify button.
NOTE: Select Followed Hyperlink style in the Style name box to change the appearance of hyperlink
text when they have been clicked to find the linked document or location.
The Format Cells dialog box will appear. Select the formatting that has to be changed to hyperlink
text, and then click the OK button to close the Format Cells dialog box.
 47 / 58
https://www.dumpsinfo.com/
In the Style dialog box, under the Style Includes, clear or select the check boxes in front of the
formats according to the requirement, and then click the OK button.
NOTE: Click the Add button, and then the Close button to create a style without applying it.
 48 / 58
https://www.dumpsinfo.com/
NOTE: When changes are made to the Hyperlink or Followed Hyperlink styles, they will be applied for
all hyperlinks in the current workbook.
NOTE: The Hyperlink and Followed Hyperlink styles appear in the Style name box if a hyperlink text
has already been created in a workbook.
Reference: Microsoft Excel, content: "Change a hyperlink"
Chapter: ADVANCED SPREADSHEETS
Objective: Data Handling
46. Click on the Insert tab and select the Action option.
47. 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?
Answer:
 49 / 58
https://www.dumpsinfo.com/
Explanation:
A template is used to create a standard layout across multiple pages. In the case of creating
certificates, templates provide an easy way of creating layouts and applying it to all designs. A user
can assign a password to a document. If a password has been added, only reviewers who know the
password can remove the protection. Take the following steps to assign a password to a template:
Open the template on which you want to assign a password. Click on the Review tab, in the Protect
group, click Restrict Editing.
The Restrict Formatting and Editing pane appears. Under Start enforcement, click Yes, Start
Enforcing Protection.
The Start Enforcing Protection dialog box opens. Type a password in the Enter new password
 50 / 58
https://www.dumpsinfo.com/
(optional) box, and then confirm the password. Click the OK button.
Reference: http://office.microsoft.com/en-us/word-help/save-a-word-document-as-a-template-
HA101868862.aspx?CTT=5&origin=HA101976901
Chapter: ADVANCED WORD PROCESSING
Objective: Enhancing Productivity
48. Which of the following steps will you take to delete a caption label?
A. References > Insert Caption > Delete Label
B. Insert > Caption > Delete Label
C. View > Caption > Delete Label
D. Review > Insert Caption > Delete Label
Answer: A
Explanation:
Take the following steps to delete a caption label:
Insert an image from the Picture option in the Insert tab.
 51 / 58
https://www.dumpsinfo.com/
Go to the References tab and click the Insert Caption option to open the Caption dialog box.
In the Caption dialog box, select the label in the Label drop down menu, click the Delete Label button,
and click the OK button.
Answer options B, C, and D are incorrect. These are not valid steps to delete a caption label.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Delete a caption label" Chapter:
ADVANCED WORD PROCESSING
Objective: Referencing
 52 / 58
https://www.dumpsinfo.com/
49. You want to group by Sales Region to see all records for each sales region together, with a total
of sales for each region. Mark the button that you will click to accomplish the task.
Answer:
Explanation:
In order to accomplish the task, you should click the Group & Sort button in the Grouping & Totals
group.
When you click this button, Access displays all records for each sales region together, with a total of
sales for each region.
Reference: http://office.microsoft.com/en-us/access
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design
50. Which of the following steps will you take to insert control fields to a form?
Each correct answer represents a part of the solution. Choose all that apply.
A. Click the Save button to save the form.
B. Click a control field to insert it.
C. Select the Ribbon's Developer tab and then select the Design Mode option in the Controls group.
D. Select the Insert tab and then select the Design option in the Controls group.
Answer: C, B, and A
Explanation:
Take the following steps to insert control fields to a form:
Select the Ribbon's Developer tab and then select the Design Mode option in the Controls group.
 53 / 58
https://www.dumpsinfo.com/
As per requirement, control fields can be added by clicking on them.
Insert all form fields to complete the form.
 54 / 58
https://www.dumpsinfo.com/
Click the Save button to save the form.
Answer option D is incorrect. It is not a valid step to insert control fields to a form.
Reference: ECDL/ICDL Exam Course Manual, Contents: "Insert control fields" Chapter: ADVANCED
WORD PROCESSING Objective: Enhancing Productivity
51. You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint
2010. You want to add a Unicode (hex) symbol as a bullet for main points. You have clicked the
Bulletsdrop-down list and selected the Bullets and Numbering option .
Which of the following steps will you take next to accomplish the task?
A. Click on the Bulleted tab and click the Picture button.
B. Click on the Bulleted tab and click the Customize button.
C. Click on the Numbered tab and click the Start at spin button.
D. Click on the Numbered tab and click the Picture button.
Answer: B
 55 / 58
https://www.dumpsinfo.com/
Explanation:
The Customize button is used to add bullets of a Unicode (hex) symbol.
Take the following steps to use a symbol as a bulleted list icon:
Select a text.
Click the Bullets icon under the Paragraph group.
The Bullets and Numbering gallery appears. Select the Bullets and Numbering option.
The Bullets and Numbering dialog box appears. Click the Customize button.
 56 / 58
https://www.dumpsinfo.com/
The Symbol dialog box appears. Select a symbol, and click the OK button.
Answer option A is incorrect. The Picture button is used to add a picture bullet.
Answer option D is incorrect. The Numbered tab does not contain any Picture button.
Answer option C is incorrect. The Start at spin button is used to specify the starting number of a
bullet.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides
 57 / 58
https://www.dumpsinfo.com/
Powered by TCPDF (www.tcpdf.org)
 58 / 58
https://www.dumpsinfo.com/
http://www.tcpdf.org