ECDL-ADVANCED Exam Training Practice Tests (ECDL/ICDL Advanced)]

Question 1

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?

A. Design B. Format C. Arrange D. Page Setup

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

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?

A. Widow/Orphan Control B. Keep with Next C. Keep Lines Together D. Page Break Before

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

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

A. PivotTable view B. Form view C. Datasheet view D. PivotChart view

Correct Answer: B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

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.

Correct Answer:

Explanation:
Chart styles are a set of formatting attributes that can be applied to a chart with one shortcut command. These styles use the colors of the current document theme that is applied to the workbook. A user can change the colors by switching to a different document theme. Chart styles can also be customized by changing the color and texture of the styles.Take the following steps to apply chart styles to a chart:
1. Click the chart to format.
2. The Chart Tools tab will be displayed containing the Design, Layout, and Format tabs.
3. Click on the Design tab. In the Chart Styles group, click the chart style to be applied.
4. Select the chart styles to be applied.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs

Question 5

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 SalaryData created in Microsoft Office Access 2010. This database has a report named SalaryReport. You have to determine bonuses based on a percentage of sales and display it in the report. For this, you want to insert an arithmetic expression in the report. Mark the tab/button that you will use to accomplish the task.

Correct Answer:

Explanation:
You should click on the Property Sheet button displayed on the Design contextual tab. It is used to insert an expression for the calculation. You can also use the Property Sheet button to define formats for dates, currency, and other numeric data.

Type an expression in Expression Builder and click the OK button.
Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design

Question 6

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a table named Table1 in Microsoft Office Access 2010. Table1 contains a sub-datasheet named Datasheet1. You want to work with contents of this table in Excel 2010. In order to perform this task, you need to export the table. Which of the following actions will MS Access perform while exporting the table from Access to Excel?

A. It creates an RTF document. B. It creates a copy of the table and stores the copy as a SharePoint list.
Explanation: When you export a table from Microsoft Office Access 2010 to Excel and the table contains a sub-datasheet, it exports only the main datasheet. To export the sub-datasheet, you should perform another export operation. In order to combine multiple Access objects into a single Excel workbook, you should export individual objects to different workbooks, and then merge all worksheets from within Excel.
Answer option C is incorrect. Microsoft Office Access 2010 creates an RTF (Rich Text Format) document if you export information from Access to Word. This RTF document can be opened by Word and various other applications.
Answer option B is incorrect. Microsoft Office Access 2010 converts a table into an HTML table if you export the table from Access to an HTML file.
Answer option D is incorrect. Microsoft Office Access 2010 creates a copy of the table and stores the copy as a list if you export the table from Access to the SharePoint list. C. It converts the table into an HTML table. D. It exports only the main datasheet.

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

Which of the following options are available in PowerPoint to arrange multiple windows?
Each correct answer represents a complete solution. Choose all that apply.

A. Cascade B. Arrange All C. Slide Sorter D. Normal

Correct Answer: A,B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 8

John works as an Office Assistant for HappyTech Inc. He is assigned the task of creating invitation cards for his colleagues. There are about 200 employees in the company. Choose and arrange the steps that he would take to ease the creation of cards.

Correct Answer:

1 - Click the File tab
2 - Click New.
3 - Click Blank document.
4 - Make changes in the document.
5 - Click the File tab.
6 - Click Save As.
7 - Give the new template a file name.
8 - Select Word Template in the Save as type list.
9 - Click Save.
10 - Choose the template
Explanation:
A template is a tool that is used to create a standard layout and look and feel across multiple pages. A user creates a template when he wants to apply the same layout to multiple pages in a document. When he makes a change in the template, all pages associated with it are affected and the corresponding change is reflected on all pages.
Take the following steps to create a template:
Click the File tab and then click New.

Click the Blank document and then click Create.

Make changes in the document. Click the File tab and then click Save As.

In the Save As dialog box, do one of the following:
Scroll to the top of the folder list, click Templates on a computer that is running Windows 7.
Under Favorite Links, click Templates on a computer that is running Windows Vista.
Under Save in, click Trusted Templates on a computer that is running Windows XP.
Give the new template a file name, select Word Template in the Save as type list, and then click Save.

Close the template.
Reference:
http://office.microsoft.com/en-us/word-help/save-a-word-document-as-a-template-HA101868862.aspx Chapter: ADVANCED WORD PROCESSING Objective: Enhancing Productivity

Question 9

Which of the following steps will you take to hide a sheet in a worksheet?

A. Insert > Format > Hide & Unhide > Hide Sheet B. Home > Format > Hide & Unhide > Hide Sheet C. Page Layout > Format > Hide & Unhide > Hide Sheet D. View > Format > Hide & Unhide > Hide Sheet
Explanation: Take the following steps to hide a sheet in a worksheet:
Go to the Format drop down icon in the Home tab.

After clicking the Hide Sheet option, it will automatically hide the sheet.

Answer options C, D, and A are incorrect. These are not valid steps to hide a sheet.

Correct Answer: B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 10

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.

Correct Answer:

Explanation:
In order to perform the operations specified by the query, you should click the Run button. It displays the datasheet of a selected query and serves the same function as selecting Datasheet View from the View button.
Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

ECDL/ICDL Advanced - ECDL-ADVANCED Exam Practice Test