ECDL CODE: ECDL-ADVANCED Exam Name: ECDL Advanced
http://www.testsexpert.com/ECDL-ADVANCED.html
Type
Microsoft
1
IBM
Demo
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Question: 1 Which of the following tools can be used to eliminate spelling and grammar errors? Each correct answer represents a complete solution. Choose all that apply. A. AutoCorrect B. Error indicators C. Spelling and Grammar D. Grammar troubleshooting
Answer: A, B, and C Explanation: Following are the three tools that can be used to eliminate spelling and grammar errors: 1.AutoCorrect: The AutoCorrect option is used to correct misspelled words, such as explane to explain. It has a long list of commonly used words with correct spellings. However, if a user misspells a word that AutoCorrect does not change, then the user can add it to the list in the AutoCorrect dialog box. 2.Error indicators: Microsoft Word provides a feature to underline the wrongly spelled word with a red wavy line. If there is any grammatical issue, Word indicates it with a green wavy line. A user can right-click an underlined word or phrase for displaying suggestions in a shortcut menu. 3.Spelling and Grammar: The user can check spelling or grammar of the entire document by pressing F7 or by clicking the Spelling & Grammar button. Answer: D is incorrect. It is not a valid tool to eliminate spelling and grammar errors.
Question: 2 Which of the following characteristics is the most important characteristic of a field that is elected as a primary key in a table? A. Easily remembered B. Simple datatype C. Unique D. Small in size
Answer: C Explanation:
Microsoft
2
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
A table usually has a column or combination of columns whose values uniquely identify each row in the table. This column (or columns) is called the primary key. Primary key ensures that no duplicate or null values are entered in the column (or columns) defined as primary key columns. This enforces integrity of the table. A primary key can be created by defining a primary key constraint while creating or altering a table. A table can have only one primary key constraint. As primary key constraints ensure uniqueness, they are often defined by using an identity column. Answer: D is incorrect. It is not important to consider the size of a primary key. Answer: A is incorrect. For using a database, it is not necessary to remember record keys. Answer: B is incorrect. A simple datatype is helpful in the key indexing, but it is not a primary characteristic.
Question: 3 Which of the following controls are available in a form? Each correct answer represents a complete solution. Choose all that apply. A. Building Block Gallery B. DataGrid C. Legacy Forms D. Drop-Down List
Answer: C, D, and A Explanation: The following controls are available in a form: Rich Text: It is used to provide a text block control and is typically used for text entry that a user does not want changed or accessed. Text: It is used to provide a text block control. Picture Content Control: It is used to select an image to insert into the form. Building Block Gallery: It is used to select text blocks from a building block gallery. Combo Box: It is used to select a response from a drop-down list. DropDown List: It is used to provide a list of responses for the user. Date Picker: It is used to select a date from an interactive calendar. Check Box Content Control: It is sued to provide a check box for user response. Legacy Forms: It is used to supply a list of legacy Word form controls and ActiveX controls. Answer: B is incorrect. It is not a valid control in a form.
Question: 4 Which of the following steps will you take to ensure that field controls can be neither edited nor deleted?
Microsoft
3
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
A. Go to Protect Document in the Tools ta b. B. Select the Protect option in the View tab and check the Protection check box. C. Go to the Properties option in the Developer tab and check both options of Locking. D. Select the Protect option in the Insert tab and check the Protection check box.
Answer: C Explanation: Take the following steps to protect control fields in a form: 1.Select the control that you want to protect.
2.Select the Ribbon's Developer tab. Click the Properties option in the Controls group.
3.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
Microsoft
4
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
and Contents cannot be edited. Click the OK button.
4.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.
Microsoft
5
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Answer: D, A, and B are incorrect. These are not valid steps to protect the control fields.
Question: 5 Which of the following attributes can be used to change the look and format of a document? Each correct answer represents a complete solution. Choose all that apply. A. Effect B. Size
Microsoft
6
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
C. Line spacing D. Style
Answer: B, D, and A Explanation: The following attributes can be used to change the look and format of a document: Size: The font size can be measured in points and each font comes in a range of sizes. Style: Each font has a number of styles, i.e., regular, italic, bold, and bold italic. Effect: Fonts can be enhanced by applying effects, such as underlining, small capital letters, or shadows. Color: For specifying custom colors, a palette of coordinated colors is available. Character spacing: A user can change the spacing between characters by pushing them apart or squeezing them together. Answer: C is incorrect. It is not an attribute that can be used to change the look and format of a document.
Question: 6 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. Keep with Next B. Page Break Before C. Widow/Orphan Control D. Keep Lines Together
Answer: C Explanation: Following are paragraph-level formatting controls: Widow/Orphan Control: It is used to prevent a single paragraph line from being stranded on a page all by itself. Keep with Next: It is used to force a paragraph to appear with the paragraph that follows. Keep Lines Together: It is used to prevent a paragraph from breaking across two pages. Page Break Before: It is used to force an automatic page break before the paragraph. Do not Hyphenate: It is used to instruct Microsoft Word not to perform hyphenation in a given paragraph.
Question: 7 Microsoft
7
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
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. Explanation: Take the following steps to insert control fields to a form: 1.Select the Ribbon's Developer tab and then select the Design Mode option in the Controls group.
2.As per requirement, control fields can be added by clicking on them.
3.Insert all form fields to complete the form.
Microsoft
8
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
4.Click the Save button to save the form.
Answer: D is incorrect. It is not a valid step to insert control fields to a form.
Question: 8 Which of the following functions will return the current system date and time? A. Format() B. NOW() C. DatePart()
Microsoft
9
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
D. Date()
Answer: B Explanation: The Now() function is used to return the current system date and time. Following is the syntax for the Now() function: Now() Answer: A is incorrect. The Format() function is used to take an expression and return it as a formatted string. Following is the syntax for the Format() function: Format(expression, [format, [firstdayofweek, [firstweekofyear]]] ) Answer: C is incorrect. The DatePart() function is used to return a specified part of a given date. Following is the syntax for the DatePart() function: DatePart(interval, date, [firstdayofweek], [firstweekofyear]) Answer: D is incorrect. The Date() function is used to return the serial number of a date. Following is the syntax for the Date() function: Date(year, month, day)
Question: 9 Which of the following steps will you take to import slides from another presentation? A. View > New Slide > Reuse Slides > Browse File... B. Home > New Slide > Reuse Slides > Browse File... C. Insert > New Slide > Reuse Slides > Browse File... D. Import > New Slide > Reuse Slides > Browse File...
Answer: B Explanation: Take the following steps to import slides from another presentation: 1.Click the New Slide option and select the Reuse Slides option.
Microsoft
10
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
2.In the Reuse Slides dialog box, click the Browse button and select the Browse File... option.
3.Select a PowerPoint presentation file to import.
Microsoft
11
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
4.After completion of the import process, click on the slides that you want to import. These slides will be added in the current presentation.
Answer: C, A, and D are incorrect. These are not valid steps to import slides from another presentation.
Question: 10 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?
Microsoft
12
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
A. On the Quick Access toolbar, click the Convert Presentation to PDF option, and select the file type as PDF. B. On the Quick Access toolbar, click the Save as type drop down menu, and select the file type as PDF. C. Export the presentation from the Home tab and save the presentation in PDF. D. Click the Convert Presentation to PDF option in the View tab and save PDF.
Answer: B Explanation: Take the following steps to save a presentation in PDF: 1.Click the Save As icon in the Quick Access toolbar.
2.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.
Microsoft
13
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
3.Click the Save button.
Microsoft
14
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Answer: D, C, and A are incorrect. These are not valid steps to save a presentation in PDF.
Question: 11 Which of the following steps will you take to insert a caption to an image? A. Insert > Insert Caption > Caption B. References > Caption > Insert a Caption C. Insert > Caption > Insert a Caption D. References > Insert Caption > Caption
Answer: D Explanation: Take the following steps to insert a caption to an image: 1.Insert an image from the Picture option in the Insert tab.
Microsoft
15
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
2.Go to the References tab and click the Insert Caption option to open the Caption dialog box.
3.In the Caption text box, fill the caption, and click the OK button.
Microsoft
16
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Answer: B, A, and C are incorrect. These are not valid steps to insert a caption to an image.
Question: 12 You work as a Database Designer for www.company.com 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? A. Datasheet B. Layout C. Design D. Pivot Table
Answer: C Microsoft
17
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
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.
Answer: A is incorrect. A DataSheet view is a type of view in which a table is displayed with its fields and data. A user can double-click on the caption and rename a field or create a new field.
Microsoft
18
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
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.
Microsoft
19
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Answer: B is incorrect. You can use the Layout view to make changes in the design while viewing data in a form or report. Answer: D 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.
Microsoft
20
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Question: 13 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. Data B. Domain C. Entity D. Referential
Answer: C 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.
Microsoft
21
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Answer: 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: A 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 exactly the same as that sent from the source. In order to maintain data integrity, the data values must be within a specified 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: B is incorrect. Domain integrity enforces data validity by restricting the data type, valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY constraints) for columns in a table.
Question: 14 Which of the following steps will you take to put a fill effect background on a presentation? Each correct answer represents a complete solution. Choose all that apply. A. Click the Fill option in the Format Background dialog box and select any fill option given in the dialog box. B. Click the Format Background option in the Format tab. The Format Background dialog box will open. C. Click the Format Background option in the Design tab. The Format Background dialog box will open. D. If you want to apply the effect on the currently selected slide, then click the Close button or click the Apply to All button.
Answer: C, A, and D Explanation: Take the following steps to put a fill effect background on a presentation: 1.Click the Format Background option in the Design tab. The Format Background dialog box will open.
Microsoft
22
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
2.Click the Fill option in the Format Background dialog box and select any fill option given in the dialog box.
3.If you want to apply the effect on the currently selected slide, then click the Close button or click the Apply to All button.
Microsoft
23
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Answer: B is incorrect. It is not a valid step to put a fill effect background on a presentation.
Question: 15 Which of the following datatypes generates a consecutive number that can be used as the primary key of a table? A. Currency B. OLE Object C. AutoNumber D. Hyperlink
Answer: C Microsoft
24
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
Explanation: 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 The AutoNumber datatype generates a consecutive number that can be used as the primary key of a table. Answer: A is incorrect. The Currency datatype is used to store monetary values. The format of the currency can be changed by using the Format property. The various formats of the Currency datatype are as follows: General Number Currency Euro Fixed Standard Percent Scientific Answer: D is incorrect. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of dat a. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink. Answer: B is incorrect. 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.
Microsoft
25
IBM
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec
ECDL CODE: ECDL-ADVANCED Exam Name: ECDL Advanced
http://www.testsexpert.com/ECDL-ADVANCED.html Microsoft
Cisco
IBM
MCTS 70-337
CCNA 640-802 640-822 640-816 640-460
MBS 98-361 70-332
CCNP 642-832 642-813 642-825 642-845
000-G01 000-M44
MCAS 77-602
CCSP 642-627 642-637 642-647 642-545
000-444 000-910
MCSE 70-282
CCIE 350-001 350-018 350-029 350-060
COG-105 COG-185
MCSA 2003 70-461 70-620
DATA CENTER 642-972 642-973 642-974 642-975
70-336 70-462
MB3-861
77-601 77-604 70-281 70-284 70-680
70-463
MB3-862
77-605 70-285
70-291
Microsoft
26
IBM
IBM Lotus
000-M42 000-M60
000-M41 000-M62
IBM Mastery
000-M43 000-M45
Solutions Expert
000-640 000-913
IBM Cognos
COG-180 COG-200
IBM Specialist
000-005 000-032
000-015 000-042
HP
Other
AIS
70-323 9L0-063 9L0-010 9L0-517 HP2-E53 70-321 650-179 1Y0-A20 00M-646 MB2-876 646-206 9L0-314 MB6-884 220-701 650-196 3305 MB6-871 HP2-Z22 9L0-407 9A0-146 HP2-H23 000-184 1Z0-527 HP2-B91 000-781 M70-201 M70-101 7004 HP3-X11 HP3-X08
HP0-311
HP0-M28
HP0-A25
HP0-M30
APC
HP0-D11 HP0-S29
HP0-J37 HP0-P14
MASE HP0-J33 HP0-M48 HP0-M49 HP0-M50 ASE
HP0-066 HP0-781
HP0-082 HP0-782
CSE
HP0-090 HP0-277
HP0-276 HP0-760
HP Cisco Oracle Instant download after purchase
http://www.testsexpert.com/ECDL-ADVANCED.html
Symantec