ECDL-ADVANCED Exam Questions Instant Access

Question 1

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?

ARight-click on Form Header, and choose the Ruler and Grid options.

BClick on the Format contextual tab and choose the Conditional Formatting option.

CRight-click on the form name and choose the Format option.

DClick on the Design contextual tab and choose the Tools option.

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 2

Which option of Freeze Panes will you use to freeze a row in a worksheet?

AUnfreeze Panes

BFreeze Column

CFreeze Selected Row

DFreeze Top Row
Explanation:
Take the following steps to freeze a row in a worksheet:
Go to the Freeze Panes drop down menu in the View tab.

Select the Freeze Top Row option in the Freeze Panes drop down menu.

After completing the above steps, you will see that the row is not moving while scrolling the worksheet.

Answer options A, B, and C are incorrect. These options cannot be used for this purpose.
Reference: ECDL/ICDL Exam Course Manual, Contents: 'Freeze Panes'
Chapter: ADVANCED SPREADSHEETS
Objective: Editing

Answer : D

Question 3

Which of the following are the predefined quick styles for formatting of documents?

Each correct answer represents a complete solution. Choose all that apply.

AParagraph

BHeader

CLinked

DCharacter

Answer : A, C, D

Following are the predefined quick styles for formatting of documents:

Paragraph styles: These styles can be applied to entire paragraphs, such as headings.

Character styles: These styles can be applied to words.

Linked styles: These styles can be applied to either paragraphs or words.

What are Quick Styles?

Quick Styles are galleries with a range of styles based on the current theme. These are combinations of different formatting options and are displayed in a thumbnail in the various Quick Style galleries. There are Quick Styles galleries for text, tables, charts, SmartArt, Word Art and more.

Answer option B is incorrect. It is not a valid quick style for formatting.

Chapter: ADVANCED WORD PROCESSING

Objective: Formatting

Question 4

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

AGo to Protect Document in the Tools tab.

BGo to the Properties option in the Developer tab and check both options of Locking.

CSelect the Protect option in the Insert tab and check the Protection check box.

DSelect the Protect option in the View tab and check the Protection check box.

Answer : B

Take the following steps to protect control fields in a form:

Select the control that you want to protect.

Select the Ribbon's Developer tab. Click the Properties option in the Controls group.

The Content Control Properties dialog box will open. In the Content Control Properties dialog box, check both options given in the Locking section, i.e., Content Control cannot be deleted and Contents cannot be edited. Click the OK button.

After doing the above steps, whenever you try to edit or delete control fields, you will get an error message in the status bar of the form.

Answer options C, A, and D are incorrect. These are not valid steps to protect the control fields. Reference: ECDL/ICDL Exam Course Manual, Contents: 'Protect control fields'

Chapter: ADVANCED WORD PROCESSING

Objective: Enhancing Productivity

Question 5

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:

AClip Art

BSmartArt

CWordArt

DCustom Animation

Answer : C

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

Question 6

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?

AComment

BMark as Final

CIRM

DHyperlink

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 7

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?

ARight-click on the text box, select the Format Shape option, and then select the Shadow pane.

BRight-click on the text box, select the Format Shape option, and then select the 3D Format pane.

CRight-click on the text box, select the Format Shape option, and then select the 3D Rotation pane.

DRight-click on the text box, select the Format Shape option, and then select the Textbox pane.

Answer : D

The Format Shape option can be used to rotate the text box to 180 degree. Take the following steps to rotate the text of a text box:

Select the text box. Right-click the text box and select the Format Shape option.

The Format Shape dialog box appears. Click the Text Box pane.

Click the Text Direction drop-down list. Specify the rotation option. Click the Close button.

Answer option B is incorrect. The 3D Format pane is used to rotate a text box on a slide.

Answer option C is incorrect. The 3D Rotation pane is used to organize the 3D format of a text box.

Answer option A is incorrect. The Shadow pane is used to organize a text box for its transparency, size, angle, distance, etc.

Chapter: PRESENTATION, ADVANCED - LEVEL

Objective: Slides

ECDL ADVANCED WORD PROCESSING ECDL-ADVANCED Exam Questions