The Best BEA certifications -Visualexams ccna-dumps.com help you pass any IT exams

ICDL-WIDOWS Free Demo Download

Certinside offers free demo for ICDL-WIDOWS 50 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download ICDL-WIDOWS Exam Pdf Demo

Download ICDL-WIDOWS Exam iEngine Demo

ICDL-Word Free Demo Download

Certinside offers free demo for ICDL-Word 31 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download ICDL-Word Exam Pdf Demo

Download ICDL-Word Exam iEngine Demo

　
　
Exam : ICDL ICDL-Word
Title : The ICDL L4 Word Exam

1. Save this document as a Web Page. Note: Do not change the default file name’ or location.
Answer: File->save as web page->save.

2. Cut the selected word possible and paste it between the words best and scenario.
Answer: Click cut from the standard toolbar -> put the cursor after the word best -> click paste from the standard toolbar

3. Change the view mode for this document to Print Layout View.
Answer: View -> select print layout

4. Select ONLY the 2nd sentence Our products … in the above text.
Answer: Select the sentence -> Our products provide quality at minimal cost.

5. Remove the Standard toolbar from the Microsoft Word application window.
Answer: Right click on any place in the toolbar -> uncheck the standard

6. TM Insert the trademark symbol at the insertion point.
Answer: Insert -> symbol -> select the tm symbol -> click insert -> close

7. Use Microsoft Word Help to access information on Format Painter.
Answer: Help -> Microsoft word help -> write the sentence format painter -> click search

8. Use the Find and Replace dialog box to find the next instance of the word area in this document.
Answer: Edit -> find -> type area in the find what box -> find next

9. Switch to the other open document Mission Statement.
Answer: Click on the Mission Statement from the task bar

10. Use the Change Case dialog box to change the selected text to Sentence case.
Answer: Format -> change case -> check the sentence case -> ok

ICDL-Powerpoint Free Demo Download

Certinside offers free demo for ICDL-Powerpoint 64 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download ICDL-Powerpoint Exam Pdf Demo

Download ICDL-Powerpoint Exam iEngine Demo

　
　
Exam : ICDL ICDL-Powerpoint
Title : The ICDL L4 Powerpoint Exam

1. Open the presentation named Training.ppt, which is in the My Documents folder.
Answer: Click on open tool ->click on my documents -> select Training.ppt ->open

2. Switch to Slide Sorter View.
A. View -> select slide sorter
Answer: A

3. Move the graphic to Slide 7 in this presentation.
Answer: Right click on the graphic -> cut -> select slide number 7 -> right click paste

4. Access the Header and Footer dialog box and add slide numbers to all slides except for the title slide of this presentation.
Answer: View -> header and footer -> check the slide number -> check don’t show on title slide -> apply to all

5. Save the Company Strategy presentation as an Outline/RTF file. You don’t need to change the file location.
Answer: File -> save as -> use the drop down list in the save as type box and select outline/RTF-> save

6. Access the Slide Master, and remove the graphic of the skier.
Answer: View -> master -> slide master -> select the graphic -> press delete from the keyboard

7. Add an image of a Lion to this slide from the Animals category of Microsoft’s Clip Art gallery.
Answer: Double click on the clip art icon -> select animals -> select the lion -> apply

8. Without retyping, make all of the letters in the selected word upper-case.
Answer: Format -> change case -> select upper-case -> ok

9. Create a Title Slide, with placeholders for both a title and a sub-title.
A. Insert -> new slide -> select the title slide
Answer: A

10. This travel company uses an approved range of corporate templates.
Apply the design template Sunny Days to this presentation.
A. Format -> apply design template -> select Sunny Days -> Apply
Answer: A

11. Change the default user name for this application to Lee Smith.
A. Tools -> options -> General tab -> in the name box delete msingh -> type Lee Smith
Answer: A

12. Add the word Introduction as the first item in the bulleted list on this slide. Click SUBMIT when you have finished.
Answer: Put the cursor on click to add text -> type Introduction

13. Change the second bullet on this slide from Bonanza sale to Mammoth sale. Click anywhere outside the bulleted list placeholder when you have finished.
Answer: Delete the name Bonanza sale and type Mammoth sale

14. If Maria were deleted from this organisation chart, which one of the following statements would be True?
A. Miguel and Lee would become sub-ordinates of Paul.
B. Miguel and Lee would report directly to Alexandra
C. Miguel and Lee would become co-workers of Naim and Michelle.
D. You would be prompted to give Miguel and Lee a new manager.
Answer: B

15. Create a new blank presentation.
Answer: Click on the new tool from the standard toolbar

ICDL-Net Free Demo Download

Certinside offers free demo for ICDL-Net 82 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download ICDL-Net Exam Pdf Demo

Download ICDL-Net Exam iEngine Demo

　
　
Exam : ICDL ICDL-Net
Title : The ICDL L4 Net Exam

1. Which two of these statements about e-mail are true?
A. You must send and receive e-mail on separate telephone lines.
B. E-mail stands for Electronic Mail.
C. The cost of sending e-mail depends on where the recipient lives.
D. You can only send or receive e-mail offline.
E. The distance over which e-mail is sent does not significantly affect the speed of delivery.
Answer: BE

2. Make this page http://www.fruit.com your browser’s new Home Page. Do not change any other setting.
Answer: Tools -> internet options -> click on use current -> ok

3. Which one of these statements is false?
A. The content of web pages that you view while using a browser is lost from memory after the computer is shut down.
B. Web browsers are software applications that are used to visit Web pages in various locations.
C. Browsers contain hypertext links to different documents and sites on the Web.
D. A web browser is a site where you can search for information on the web
Answer: D

4. Which one of the following statements about online credit card transactions is true?
A. This globe symbol means a site is secure for entering credit card details.
B. You should only enter credit card details into a form on a secure web site
C. You credit card statement may not include extra costs such as shipping.
D. E-mail is the most secure way to send your credit card details to a website.
Answer: B

5. The World Wide Web is:
A. A huge collection of linked files held on computers all over the world
B. a huge wide network of telephone cables and related equipment.
C. a network of computers and cables that connect e-mail users all around the world.
D. a global netowrk of communication satellites.
Answer: A

6. The main purpose of a firewall is to:
A. prevent unauthorized users from gaining access to a network
B. protect network servers from the risk of fire.
C. prevent employees from accessing the Internet during work hours.
D. prevent network users from sending and receiving personal e-mail.
Answer: A

7. Which one of these statements about e-mail is true?
A. You can only access one e-mail account at any time.
B. Each user can only access their e-mail account from a single PC.
C. You need a user name and password to access your e-mail
D. Email accounts on a single PC share the same folders.
Answer: C

8. Which one of these statements about digital signatures is true?
A digital signature:
A. Automatically encrypts the contents of an e-mail.
B. Is a scanned image of your real signature.
C. Is used to verify the identity of the sender of a message
D. Is used to add a personal touch to e-mail messages.
Answer: C

9. A search engine is a program
A. that helps you to find information located on the internet
B. that can be used to find errors in the HTML code for a web page.
C. that is used to find the web sites you have most recently visited.
D. on the Internet that locates all users logged onto a web site.
Answer: A

10. Which one of these statements is true?
A. It is not possible to encrypt the content of e-mail message.
B. Encryption prevents unauthorised users from reading data
C. You can’t send encrypted data out over the Internet.
D. Encryption converts data so that it can be understood.
Answer: B

11. Drop
Answer:
15.Make this page http://www.fruit.com your browser’s new Home Page. Do not change any other setting.

12. Which two of the following statements, about organising your e-mail within most popular e-mail applications, are true?
A. You need to create folders before you can send or receive e-mail.
B. You must read e-mail before you can organize it into folders
C. You can use cut-and-paste to move mail to different folders.
D. You must open an e-mail before you can duplicate it.
E. E-mail messages can be sorted alphabetically inside a folder
Answer: BE

13. Use Internet Explorer Help to access information on History lists.
Answer: Help -> contents and index -> type History lists -> display

14. An Internet tool that enables you to quickly find information on the Web is called:
A. a Uniform Resource Locator.
B. a Search Engine.
C. a Find Wizard.
D. Online Help.
Answer: B

15. Which two of these statements regarding the risk of transmitting viruses via e-mail are true?
A. Viruses can only be transmitted via an e-mail attachment.
B. A virus can spread via e-mail by mailing itself to everyone in a victim’s address book
C. Viruses are only spread via unsolicited mail.
D. You should not open e-mail if it has a suspicious subject line
E. You are more at risk from viruses if you use Web based e-mail.
Answer: BD

16. Which two of these statements about encryption are true?
A. An encryption key is used to compress documents that you wish to store safely.
B. Encryption prevents unauthorised users from reading your data
C. Encryption converts data so that it cannot be understood
D. You can’t encrypt your e-mail messages.
E. Encryption can only be used to encrypt text files.
Answer: BC

ICDL-Excel Free Demo Download

Certinside offers free demo for ICDL-Excel 88 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download ICDL-Excel Exam Pdf Demo

Download ICDL-Excel Exam iEngine Demo

　
　
Exam : ICDL ICDL-Excel
Title : The ICDL L4 Excel Exam

1. If the Enter key was pressed to accept the formula in cell E9, which of the following would be the result:
A. A #REF! error message.
B. A #VALUE! error message.
C. A #NAME! error message.
D. A Circular Reference error message
Answer: D

2. Which formula would display 7% in cell D8 if the customers order value is over 10,000 and would display 0% if not.
A. =IF (D7=10,000,7%,0%)
B. =IF (D8>10000,7%,0%)
C. =IF (D7>10000,7%,0%)
D. =IF(D7<10000, 7%, 0%)
Answer: C

3. If row 4 is deleted, which formula will then be in cell B6?
A. =SUM(B3:B6)
B. =SUM(B3:B5)
C. =B3+B4+B5
D. =SUM(B3:B7)
Answer: B

4. Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.
A. =IF(C3>300,10%,0%)
B. =IF (B3>300, 10%, 0%)
C. =IF (B3>300, 0%, 10%)
D. =IF (B3<300, 10%, 0%)
Answer: B

5. 3
C. A #VALUE error message
D. A #NAME? Error message
Answer: D
3. Which formula entered into C3 would calculate the Total Cost of Barrels for the Oil Deco company and if copied down would automatically calculate the Total Cost for all the other customers.
A. =B3*C1
B. =B3*$C$1
C. =$B$3*$C$1
D. =$B$3*C1
Answer: B
4. Which formula entered into B5 will calculate the total cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair?
A. SUM($B$2:$B$4)+B8
B. =SUM(B2:B4)+$B$8
C. =SUM(B2:B5)+$B$8
D. =SUM(C2:C4)+$C$8
Answer: B
5. Which formula entered into B10 would find the total amount of rainfall that in the seven days?
A. =SUMB3:B9
B. =SUM(B3:B9)
C. =(SUM)B3:B9
D. SUM=(B3:B9)
Answer: B
6. Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.
A. =IF(C3>300,10%,0%)
B. =IF (B3>300, 10%, 0%)
C. =IF (B3>300, 0%, 10%)
D. =IF (B3<300, 10%, 0%)
Answer: B
7. If the Enter key was pressed to accept the formula in cell E9, which of the following would be the result:
A. A #REF! error message.
B. A #VALUE! error message.
C. A #NAME! error message.
D. A Circular Reference error message
Answer: D
8. If row 4 is deleted, which formula will then be in cell B6?
A. =SUM(B3:B6)
B. =SUM(B3:B5)
C. =B3+B4+B5
D. =SUM(B3:B7)
Answer: B
9. Which formula entered into E2 would calculate the total cost (including delivery) of a Barbados garden suite and, if copied down, would automatically calculate the total cost for the other two garden suites.
A. =SUM(B2:D2)+$B$6
B. =SUM(B3:D3)+$B$6
C. =SUM($B$2:$D$2)+B6
D. =SUM(B2:B42)+$B$6
Answer: A

6. If the Enter key was pressed to accept the formula in cell E8, what would appear in the cell?
A. #REF!
B. 6,000
C. #VALUE!
D. #NAME!
Answer: C

7. Which formula entered into B10 would find the total amount of rainfall that in the seven days?
A. =SUMB3:B9
B. =SUM(B3:B9)
C. =(SUM)B3:B9
D. SUM=(B3:B9)
Answer: B

8. Which formula entered into B10 would find the heaviest rainfall in the seven days?
A. =MAXIMUM(B3:B9)
B. (MAX B3:B9)
C. =MAXIMUM(B3:B10)
D. =MAX(B3:B9)
Answer: D

9. If the formula in B7 is copied to cell D7, which formula will display in the formula bar when D7 is selected?
A. =SUM(B3:B5)-B6
B. =SUM(C3:C5)-C6
C. =SUM(D3:D5)-B6
D. =SUM(D3:D5)-D6
Answer: D

10. If the Enter key was pressed to accept the formula in cell B9, which of the following would be the result:
A. A #REF! error message
B. 9.3
C. A #VALUE error message
D. A #NAME? Error message
Answer: D

11. Which one of the following formulas would be appropriate to calculate the monthly surplus for September in this worksheet?
A. =B5+B11
B. =SUM(B5:D5)-SUM(B11:D11)
C. = B5-B11
D. =AVERAGE(B5:D5)-AVERAGE(B11:D11)
Answer: C

12. Which formula entered into B5 will calculate the total cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair?
A. SUM($B$2:$B$4)+B8
B. =SUM(B2:B4)+$B$8
C. =SUM(B2:B5)+$B$8
D. =SUM(C2:C4)+$C$8
Answer: B

13. Which formula entered into C3 would calculate the Total Cost of Barrels for the Oil Deco company and if copied down would automatically calculate the Total Cost for all the other customers.
A. =B3*C1
B. =B3*$C$1
C. =$B$3*$C$1
D. =$B$3*C1
Answer: B

14. Dragging the fill handle up to cell B3 will fill B3 with:
A. Envelopes
B. Pens
C. Paper
D. Stamps
Answer: B

15. Which formula entered into C12 would calculate the number of recorded rainfall readings taken over the 3 weeks?
A. =NUMBER(B4:D10)
B. =COUNT(B4:B10)+(C4:C10)+(D4:D10)
C. =COUNT(B4:D10)
D. =NUM(B4:D10)
Answer: C

16. Which TWO of the following would calculate the amount left to spend for March?
A. =D12-D8
B. =SUM(D4:D7)-SUM(D10:D11)
C. =(D10:D11)-(D4:D7)
D. =SUM(D10:D11)-SUM(D4:D7)
Answer: AD

ICDL-IT Free Demo Download

Certinside offers free demo for ICDL-IT 161 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download ICDL-IT Exam Pdf Demo

Download ICDL-IT Exam iEngine Demo

　
　
Exam : ICDL ICDL-IT
Title : The ICDL L4 IT

1. ______ Prints the output on paper.
A. Scanner
B. Printer
C. CPU
Answer: B

2. Peripherals Devices Are Part Of Hardware?
A. True
B. False
Answer: A

3. Which one of the following printers uses a toner in printing.
A. Laser.
B. Dot matrix
C. Ink jet
Answer: A

4. ________ Helps you input data and give commands.
A. Pointer
B. Mouse
C. Keyboard.
Answer: C

5. The Speed Of The Central Processing Unit is measured in
A. Mege hertz
B. Hectares
C. Revolutions per minute.
D. Bits per second
Answer: A

6. Which of the following statements is true?
A. A mainframe computer enables users to share files, printers and other resources.
B. Mainicomputer enables users to share files, printers and other resources.
C. Network computer enables users to share files, printers and other resources.
Answer: C

7. One byte is equivalent to:
A. 2 bit
B. 8 bit
C. 16 bit
D. 4 bit
Answer: B

8. Which of The Following Can Convert The Computer Signals From Digital To Analog?
A. ISDN
B. Modem
C. DSL
D. HDSL
Answer: B

9. Which of the following statements is TRUE?
A. ROM loses information when the computer is powered off.
B. ROM chips can be plugged into the motherboard to provide more memory.
C. ROM can’t be written to , it’s preprogrammed.
Answer: C

10. With Suitable Applications Installed, PCs Can Process graphics as well as text.
A. True
B. False
Answer: A

11. Ram Can Hold The Data And Programs Which In Currently Use, It Is UN Volatile Memory.
A. True
B. False
Answer: B

12. When working away from the office a sales representative might typically use which type of computer?
A. Desktop computer.
B. Laptop computer
C. An analogue computer
D. A mainframe computer
Answer: B

13. Which one of these statements is False?
A. A network of computer linked within a building is called a LAN
B. Databases can be accessed by many users who connected to a LAN.
C. A network-linking computer over cities countries is called WAN
D. Applications cannot be shared over a LAN.
Answer: D

14. Which one of these computers is too expensive?
A. Minicomputer
B. Lap top
C. Mainframe
Answer: C

15. Which of the following requires power to be on in order to maintain the data it stores?
A. ROM
B. RAM
C. Hard disk
D. Floppy disk
Answer: B

16. Which printer type would MOST likely produce the most noise?
A. Dot Matrix.
B. Ink Dispersion
C. Laser
Answer: A