Question 1

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 Borders button on the Design tab will not help in displaying the gridlines. Which of the following is the cause of the issue?

AYou are viewing the document in Print Layout view.

BYou are viewing the document in a Web browser.

CYou are viewing the document in Draft view.

DYou are viewing the document marked as final.
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

Answer : B

Question 2

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?

AShe selects the border of the text box and starts typing.

BShe selects the text box and delete it.

CShe selects the slide and starts typing.

DShe selects the text of the text box and starts typing.
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

Answer : A

Question 3

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?

AOn the Quick Access toolbar, click the Convert Presentation to PDF option, and select the file type as PDF

BExport the presentation from the Home tab and save the presentation in PDF.

CClick the Convert Presentation to PDF option in the View tab and save PDF

DOn the Quick Access toolbar, click the Save as type drop down menu, and select the file type as PDF
Explanation:
Take the following steps to save a presentation in PDF:
Click the Save As icon in the Quick Access toolbar.

Write the name of file in the File name section, click the Save as type drop down menu, and select the file type as PDF.

Click the Save button.

Answer options C, B, and A are incorrect. These are not valid steps to save a presentation in PDF.
Reference: ECDL/ICDL Exam Course Manual, Contents: 'Save a presentation in PDF'
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Slides

Answer : D

Question 4

In which of the following formats can the date and time be formatted?

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

Amm/dd/yyyy

Bh:m:s

Ch:m

Dmm/dd/yyyy h:m:s
Explanation:
The Format property is used to format the Date/Time datatype. The date and time can be formatted as follows:
General Date: The date is displayed in the format of mm/dd/yyyy h:m:s. For example,
10/19/2011 6:30:45 PM
Long Date: The date is displayed in the following format:
Friday, October 19, 2011
Medium Date: The date is displayed in the following format:
19-Oct-11
Short Date: The date is displayed in the format of mm/dd/yyyy. For example,
10/19/2011
Long Time: The time is displayed in the format of h:m:s. For example,
6:30:45 PM
Medium Time: The time is displayed in the format of h:m. For example,
6:30 PM
Short Time: The time is displayed in the following format:
18:30

Answer : A, B, C, D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design

Question 5

You work as a Database Designer for ABC Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Information in Microsoft Office Access 2007. The database contains 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?

ADesign

BPivot Table

CLayout

DDatasheet
Explanation:
In order to view a list of fields in the table, you must open the table in the Design view.The Design view of a table displays its fields and datatypes. New fields can be added to the table and assigned to a datatype. A user cannot insert data in this view. The datatype of a field can be formatted and other table properties such as field size, validation rule, etc., can be set for the field.

The datatype of the new field is defined by the data inserted in it by a user. The default datatype is text. The datatype can be explicitly assigned to a field through the Datatype list in the Data type and Formatting group on the DataSheet tab.

Answer option C is incorrect. You can use Layout view to make changes in the design while you view data in a form or report
Answer option B is incorrect. The PivotTable view of a table can be used to display the data of a table in the desired format. This view cannot be used to create or delete a field or modify its properties. The data can be filtered according to fields. When the PivotTable view is opened, a blank work area is displayed and the columns of the table are displayed in the Pivot Table Field List window. A user has to drag and drop the fields to view the desired result.