Microsoft Digital Literacy Certificate Test Item File

The Digital Literacy Certificate Test Item File contains 89 test items that cover objectives from across all 5 of the Digital Literacy courses. We recommend that you select 30 items that represent a balance across the lessons to create a student test. For most questions, there is only one correct answer. If an item has multiple answers, the question will state how many answers to select. Please note that while all the test items are drawn from the online assessments, not all of the online assessment items are included (for technical reasons) so the numbering convention does not match the online experience.

Computer Basics
Lesson 1: Introduction to Computers
1. Tina creates a business proposal on her home computer. She wants to use a storage device to save the proposal and take it to her office. Which of the following devices will Tina use to store the files? A. B. C. D. Microphone Speakers CD-R Modem

2. Apurva needs to connect a printer to his computer. He asks you about the parts of a computer that he can use to connect the printer. What will you tell Apurva? Select two. A. B. C. D. E. Graphics card Modem Sound card Parallel port Universal serial bus (USB) port

3. You want to create a document on your computer. In what order will you perform the following steps when you start creating the document? Arrange the steps in the following list in the order in which you will perform them. Place the first step at the top of the list. Steps: A. Log on to the computer. B. Create the document. C. Turn on the computer. D. Save the changes. E. Start the program. 4. Your friend wants to view your live image while you chat with her online. Which of the following devices installed on your computer will help her do this? A. B. C. D. Web cam Printer Scanner Microphone

5. Alexander needs to prepare the transcript for an audio file saved on his office computer. He wants to listen to the audio without disturbing his colleagues sitting nearby. Which of the following hardware devices will Alexander use? A. B. C. D. Headphone Speaker Microphone Web cam

6. Niraj wants to use his office computer. To log on to the computer, he needs to enter his logon details. Which of the following options does Niraj need in order to log on to the computer? Select two. A. B. C. D. E. User name Home address Office name Password Office address

7. Markus uses his computer to calculate the money he spent on transportation costs in the last two months. Which part of his computer will perform the calculations? A. B. C. D. Monitor Central processing unit (CPU) DVD Hard disk

Lesson 2: Define common computer terminology.

8. Elisabeth reads an article on common computer terminology. She does not understand the meaning of operating system. She comes to you for help. How will you explain operating system to Elisabeth? A. B. C. D. An electronic device connected to your computer A storage device in your computer A program that controls and manages the computer A circuit board that connects the input, output, and processing devices

9. You use a word processor to create and save a text-based document on your computer. What does the text in your document represent? A. B. C. D. Data Hardware Operating system Application

10. Enrique reads an advertisement about a computer hardware store. He wants to know the meaning of the term hardware. How will you define the term hardware for Enrique? A. B. C. D. Physical parts of a computer An item of information Instructions that make programs work Rules designed to enable computers to connect with one another

11. Arif sees you reserve your train tickets over the Internet. He wants to know about the various things one can do on the Internet. Which of the following options will you tell him? Select three. A. B. C. D. E. F. Service your car Communicate in a real-time environment Reserve travel tickets Withdraw cash Burn a CD Send e-mail messages

12. Marko uses an instant messenger to chat with his friends over the Internet. How will you categorize an instant messenger? A. B. C. D. Hardware Software Operating system Data

13. Kaspars listens to his friends talking about the Internet. He is curious about the Internet. How will you define the Internet to him? A. B. C. D. A software program installed on a computer An electronic device for printing documents A worldwide collection of computer networks A power backup source

Lesson 3: Computer Performance and Features

14. Dan learns that he can control the access rights to his computer and specify a user name and password. He wants to know what process the operating system performs to confirm his logon information. What will you tell Dan? A. B. C. D. Computation Initialization Authentication Authorization

15. Tom notices that when he runs several programs simultaneously on his computer, the performance of the programs slows down considerably. What is the reason for this? A. B. C. D. Nonfunctional keyboard Nonfunctional mouse Insufficient random access memory (RAM) Low monitor speed

16. John works as a sales representative with Northwind Traders. He has to make a presentation to his customers in another town. The presentation occupies 10 gigabytes (GB) on his computer. He wants to make some final changes to this presentation while he is traveling. Which of the following types of computer will help John carry this data with him? A. B. C. D. Mainframe Personal digital assistant (PDA) Laptop Desktop computer

17. David wants to create business cards and brochures for his new company. Which of the following programs will David use? A. B. C. D. Instant messenger Antivirus Desktop publishing (DTP) Movie maker

18. Your friend Jan travels to various parts of the world. Which of the following options will you use to have a real-time conversation with him? A. B. C. D. Instant messenger Spreadsheet program E-mail Presentation program

Lesson 4: Computer Operating Systems

19. You tell Carol about the various types of operating systems. She now wants to know about the functions of an operating system. Which of the following options will you use to describe the functions of an operating system to Carol? Select four. A. B. C. D. E. F. G. Scans images Takes pictures Manages file system Runs programs Detects viruses Manages data storage Allocates memory usage

Lesson 5: Computer Careers

20. Arnos uncle owns a small business with 20 office employees. The computers in his office are connected on a network. Arno often helps his uncle to install new computers on the network, add and remove individuals from the list of authorized users, and archive files on a computer. He likes to perform these activities and wants to make them the focus of his profession. Which of the following job opportunities can Arno consider? A. B. C. D. Graphics designer Software developer Network administrator Database administrator

Internet and the World Wide Web

Lesson 1: The Internet
21. You connect your computer to the Internet to find some information. Which of the following terms describes a computer that is connected to the Internet? A. B. C. D. Online Offline Stand by Logged off

22. Your sister travels to another country for an on-site business project. You want to tell her about your new job by sending her an e-mail message from your computer. Which of the following devices will you use to connect your computer to the Internet? A. B. C. D. Printer Scanner Modem Sound card

23. Morten wants to play a game online. He hears modem tones every time his computer sends a request to the Internet service provider (ISP) to establish the Internet connection. What type of Internet connection does Morten use? A. B. C. D. Dial-up Broadband WiFi Dedicated

Lesson 2: The World Wide Web

24. Your friend publishes some photographs on his Web site. You want to view these photographs. After connecting your computer to the Internet, which of the following programs will you start to access your friend's Web site and view the photographs? A. B. C. D. Web browser Word processor E-mail client Antivirus

25. You want to know more about active volcanoes in the world. You connect your computer to the Internet to find information based on the keyword "active volcanoes." Which of the following features of the World Wide Web (WWW) will you use? A. B. C. D. Search engine Plug-in Uniform Resource Locator (URL) E-mail

26. Chris wants to send an e-mail message to his friends. He has a modem connected to his desktop computer. What else does Chris need to send the e-mail message? A. B. C. D. Personal digital assistant (PDA) Internet connection Web cam Printer

27. Susan helps her son prepare for a computer exam. While describing the World Wide Web (WWW), she explains that he can access a Web site by using a unique alphanumeric address. To which of the following terms is Susan referring? A. B. C. D. Uniform Resource Locator (URL) Web browser Internet service provider (ISP) World Wide Web (WWW)

Lesson 3: Communicating on the Internet

28. Hristina wants to know what an e-mail is and what she will need to be able to exchange e-mail messages with her friends. What will you tell Hristina? Select two. A. B. C. D. E. Computer Internet access Printer Plug-in Search engine

29. You want to create an online journal that describes a music concert you attended last week. You want your friends to read the journal and view the pictures of the concert. Which of the following online communities will you use to create this online journal? A. B. C. D. Blog Chat group Newsgroup Bulletin board

Productivity Programs
Lesson 2: Common Features and Commands
30. Carol uses Microsoft Office Word 2003 to create documents and store data in them. She often uses a block of on-screen buttons, displayed in the following exhibit, to quickly perform common tasks. What is the term used to describe the block of on-screen buttons displayed in the following exhibit?

A. B. C. D.

Menu bar Toolbar Title bar Scroll bar

31. You need to print a few documents that you create by using Word 2003. After printing the documents, you then save the documents on your office computer. Which of the following menus will you use to print the documents? A. B. C. D. File View Format Tools

32. Eric teaches his daughter Tina how to work with productivity programs. Tina notices a small blinking bar that stays in place until Eric clicks the mouse in a new location in the document. Tina wants to know the name of this blinking bar. Which of the following terms will Eric use to answer Tina's question? A. B. C. D. Mouse pointer Insertion point Scroll bar Status bar

33. Ursula creates a document in which she needs to insert some uppercase letters. She prefers not to use the CAPS LOCK key, and she needs to complete the document quickly. Which of the following keyboard keys can Ursula use in combination with the letters she wants to type in uppercase? A. B. C. D. ESC CTRL ALT SHIFT

Lesson 3: Word Processing Programs

34. Barry purchases a computer that has a word processor installed in it. Which of the following tasks can he perform by using a word processor? Select three. A. B. C. D. E. F. Create documents Edit videos Host a Web site Format text Perform real-time communication Print pages

35. You use Microsoft Office Word 2003 to create a text-based document. You open three other documents to copy data from them. Which of the following menus will you use to paste the copied text into your document? A. B. C. D. File Window Edit View

36. Bob reviews a document by using Word 2003. He needs to replace a word with another word of the same meaning. Which of the following features in Word 2003 can he use to do this? A. B. C. D. Copy and Paste Thesaurus AutoCorrect Research

37. Susan uses Word 2003 to create a document. She wants to place the title in the center of the page. Which of the following features in Word 2003 can Susan use to do this? A. B. C. D. Alignment Spacing Font style Font size

Lesson 4: Spreadsheets
38. Michelle uses Microsoft Office Excel 2003 to create her expense sheet for the month. She wants to view the data in a graph. Which tool will she use to represent the data through a graph? A. B. C. D. Chart Wizard AutoContent Wizard Clip Art gallery Budget Template Wizard

39. John trains his team to work with spreadsheets. One of his team members wants to know what the point of intersection of a row and a column is known as. Which of the following options will John use to answer his team member's question? A. B. C. D. Label Cell Value Worksheet

40. Don is a teacher. He uses Excel 2003 to store the scores of all of his students. He wants to find the total score for each student. Which of the following toolbar buttons will he use to calculate the total score? A. B. C. D. AutoSum AutoCount AutoSummarize AutoFormat

41. Angela plans her office budget for the next month. She wants to know what part of the total expenses she spent on office supplies last month. Using a worksheet, she wants to insert a chart showing the part spent on office supplies. Which of the following charts will she use? A. B. C. D. Line Pie Surface Area

Lesson 5: Presentation Programs

42. You want to use Microsoft Office PowerPoint 2003 to create a presentation on your computer. You need to add some geometric shapes to the presentation. Which of the following toolbars will you use to do this? A. B. C. D. Drawing Formatting Reviewing Standard

43. Your friend needs to create a presentation about a product launch by his company. He wants to know the features available in presentation programs. Which of the following features will you list for him? Select two. A. B. C. D. E. Create audiovisual presentations Create handouts Edit video Perform calculations Enable real-time communication

44. Mark creates a business presentation by using PowerPoint 2003. In this presentation, he needs to show a comparison between the productivity of his company in the current year and the previous year. Which of the following objects will he add to the presentation to show the comparison? A. B. C. D. AutoShape Audio clip Clip Art Chart

45. Thomas creates a presentation on his computer by using PowerPoint 2003. He wants to add display effects on various slides of the presentation. Which of the following options in PowerPoint 2003 can he use to add the display effects? A. B. C. D. Slide Design Slide Transition Slide Show Slide Layout

Lesson 6: Databases
46. Alan works as an administrator in a school. He wants the registration numbers of the students to be unique in the student database table. He adds a field named Registration Number in the student database table. Which of the following actions will Alan perform on the Registration Number field in the database table to ensure that each student receives a unique registration number? A. B. C. D. Define the field as a primary key Specify the data type as text Set a Validation Rule for the field Create an Input Mask for the field

47. Raman works as an administrator with The Phone Company. He wants to use Microsoft Office Access 2003 to maintain customer records on his computer. Which of the following objects can he create in Access 2003? Select three. A. B. C. D. E. F. Animations Forms Tables Video clips Reports Pictures

48. Patricia is a travel agent. She enters a customer name, address, and phone number in the customer database. She wants to know which object is used to organize and store this data in Access 2003. Which of the following objects will you select to answer her query? A. B. C. D. Query Table Form Report

49. Amy works in a travel agency. She wants to manage records of more than 10 thousand clients. Which of the following productivity programs can Amy use to manage this information? A. B. C. D. Graphics Word processor Desktop publishing (DTP) Database

Computer Security and Privacy

Lesson 1: An Overview of Computer Security and Privacy
50. Paul receives an e-mail message from his friend Karen that asks for his passport details. Paul doubts that Karen actually sent him the message. He calls Karen and discovers that she did not send any such message. Which of the following terms refers to the kind of attack described in this scenario? A. B. C. D. Spoofing Tracking Decoding Redirection

51. Kate receives an e-mail message from an online computer store offering her a new laptop at a very low price. She clicks the hyperlink in the message to open the Web page. The page requests her credit card details, and she enters her credit card number. After a few days, Kate finds that more money has been drawn on her credit card than she specified and that she did not receive the laptop. Kate realizes that she has been tricked by someone who created a site that looks like the actual computer store, but is not the official site for the computer store. Which one of the following terms refers to the type of attack described in this scenario? A. B. C. D. Decoding Encryption Phishing Spying

52. Susan accidentally deletes her company's inventory report from her computer. What is this type of computer threat called? A. B. C. D. Human error Spoofing Phishing Software piracy

53. The office of A. Datum Corporation is located in an earthquake-prone area. The corporation wants to protect its critical data that is stored on computers. Which one of the following actions will help the corporation protect the critical data in case of an earthquake? A. B. C. D. Installing a virus protection program Backing up the data and storing it at another location Using spyware-fighting software Installing a firewall to prevent hacking

Lesson 2: Protecting Your Computer and Your Data

54. Brian installs a new program on his computer. One day, his friend Jason visits him and notices the program. Jason informs Brian that this particular program can send sensitive information to a malicious recipient. Which of the following programs can help Brian detect and prevent such malicious activities on his computer? A. B. C. D. Worm Trojan horse Spyware-fighting software Ethernet

55. You store sensitive data on your computer. Therefore, you need to restrict access to this data by others who use your computer. What will you do to restrict access? A. B. C. D. Install Microsoft Windows Firewall on your computer Create new folders to save the data Install spyware on your computer Create accounts and define rights for users

56. Darren is an administrator at Woodgrove Bank. He wants only certain employees to have access to the accounts network. Which of the following methods can Darren use to restrict access to the network? A. B. C. D. User identification Lock combination Data encryption Data backup

57. Michelle wants to purchase jewelry from an online store. During the transaction, she needs to enter information such as her credit card details. Which one of the following options will ensure secure online transactions between the online store and Michelle? A. B. C. D. Antivirus program Windows Firewall Cookies Secure Sockets Layer (SSL)

Lesson 3: Protecting Yourself and Your Family from Security Threats

58. On a daily basis, you get many e-mail messages from unknown senders. What is this type of security threat called? A. B. C. D. Spam Spoofing Phishing Slander

You want to classify some Web sites as trusted or restricted on your computer. 59. Which of the following security settings in the Microsoft Windows Security Center window will help you do this? A. B. C. D. Internet Options Automatic Updates Windows Firewall System Properties

Lesson 4: Keeping Your Computer Secure and Updated

60. You need to send your credit card details to your brother by e-mail. Which of the following guidelines will you apply to ensure the privacy of the e-mail message? A. B. C. D. Use a spyware-fighting program Encrypt the e-mail message Use e-mail filters Maintain a backup of the e-mail message

61. A new type of Trojan horse infects Neil's computer What can Neil do to prevent this from happening again? A. B. C. D. Use a strong password Install a plug-in Update the media player Update the antivirus program

62. Susan wants to change the privacy settings on her computer. She wants to block thirdparty cookies that use personally identifiable information without implicit consent. Which of the following security settings will help her do this? A. B. C. D. Microsoft Windows Firewall Internet Options Automatic Updates Antivirus Options

63. Tom is a trainer with Adventure Works. He wants to explain to his trainees how Windows Firewall functions. Which of the following functions describes Windows Firewall? A. B. C. D. Installs security patches Restricts unauthorized access Blocks pop-up windows Blocks word-processing programs

64. Bob wants to update his Windows operating system to help secure it from malicious threats. Which of the following commands on the Start menu can he use to update the operating system? A. B. C. D. Control Panel Search Windows Tour Documents

65. Jim is facing some security problems because of a computer worm. His friend tells him to install the latest security patches for his Windows operating system to address the issue. Which one of the following options will allow him to install these patches? A. B. C. D. Internet Options Windows Firewall Windows Updates Patch Locator

66. Stephan wants to update his Windows operating system with the latest security patches. Which of the following settings can he use to set Windows to periodically check for the latest patches? A. B. C. D. Internet Options Windows Firewall Automatic Updates Antivirus Updates

Lesson 5: Computer Ethics

67. Michael is creating his own Web site. While browsing the Internet, he finds some images that he wants to use on his site. Which of the following options indicates an ethical way for Michael to use the images on his site? A. B. C. D. Save the images on his computer Copy the images and reduce their size Obtain permission from the copyright owner, if required Cut only the required portion of the images

68. Bob copies an article from a magazine and uses it for his new book on computers. However, he fails to obtain permission from the magazine publisher. What kind of an action is this? A. B. C. D. Libel Plagiarism Gambling Slander

69. Jim finds that David is downloading songs from the Internet and sharing them with friends. Jim informs David that this is a copyright violation. Now David wants to know about other actions that might violate copyright laws. Which of the following actions can Jim describe as a copyright violation? A. B. C. D. Sharing a Web site address Reading material from a publicly available Web site Distributing someone else's original work as your own Quoting a paragraph and mentioning the source

70. Keith notices that his neighbor is posting false statements about him on the message board of a Web site. Which of the following activities is Keith's neighbor performing? A. B. C. D. Plagiarism Defamation Gambling Phishing

Digital Lifestyle
Lesson 1: The Modern Digital Experience
71. Your father needs to travel frequently to conduct business meetings in various cities. You tell him that he can use video conferencing to attend and conduct the meetings without traveling. Your father wants to know more about video conferencing. Which of the following options will you identify as features of video conferencing? Select two. A. B. C. D. E. Requires the participants to be in the same country Allows participants to talk to each other Uses speech synthesis to transmit audio among participants Allows participants to see each other Can be conducted by using a stand-alone computer

71. Don likes to play games, whereas his sister likes to listen to music. Don wants to buy a multipurpose device that he can use to play games and listen to music. Which one of the following devices will you suggest to him? A. B. C. D. Transistor radio Camcorder Smartphone Web cam

72. Mark reads about mobile phones while browsing the Internet. He wants to know about the functions of a mobile phone before he purchases one. Which of the following functions of mobile phones will you list? Select three. A. B. C. D. E. F. Scans images Photocopies documents Can be used for listening to songs Burns CDs Can provide access to the Internet Can be used for playing games

73. Karen wants to record the first steps of her eight-month-old son by using a digital video device. Which one of the following devices can she use? A. B. C. D. Camcorder Scanner CD player MP3 player

74. Bob gives you an audio CD of your favorite music band as a gift. Which of the following devices will you use to play the CD? A. B. C. D. Analog camcorder Transistor radio Microphone DVD player

Lesson 2: Digital Audio

75. Thomas purchases a portable computer. Speech synthesis software comes with the portable computer. Which of the following tasks can Thomas perform by using this software? A. B. C. D. Convert text to audio Upload audio files to the Internet Identify human voice in audio files Make voice commands to computers

76. Jenny is a song writer. She records her new song on her computer and saves it in the WAV format. She wants to give you a copy of the song. You do not have a computer at home. Therefore, Jenny decides to save the music in the MP3 format so you can listen to the music by using an MP3 player. Which of the following processes will Jenny use to save the music in the MP3 format? A. B. C. D. Recording Converting Audio streaming Speech synthesis

77. Jim records a song by using an audio recorder. He now wants to add special effects to this song. Which of the following digital technologies will he use for this purpose? A. B. C. D. Audio editing software Audio streaming software On-demand streaming software Digital audio recognizer

78. Jim has a recording of his daughter's voice on his home computer. He wants to save the audio on a recordable CD. Which of the following processes will help him do this? A. B. C. D. Compressing Converting Streaming Copying

79. A music concert takes place in Amy's hometown. She cannot attend the event because she is away on a business trip. She visits the Southridge Video Web site to listen to the concert live over the Internet. Which of the following technologies does the Web site use? A. B. C. D. Speech recognition Sampling Streaming Speech synthesis

80. You order a new computer from a computer store. You inform the store manager that you need CD-writing software installed on your personal computer. Which of the following statements describes the purpose of CD-writing software? A. B. C. D. Plays digital audio and video files from a CD Scans images from a scanner Streams digital audio files from a CD Records data on a recordable CD

Lesson 3: Digital Video

81. Adam talks to you about the characteristics of digital video. He says that it can be compressed. You want to know the advantage of compressing digital video. Which of the following options states the advantage of compressing digital video? A. B. C. D. Saves space Improves brightness Enhances sound quality Improves contrast

82. Anna saves a video of her family picnic by using the name MyPicnic. She wants to edit this video before sharing it with her friends. Which of the following files will Anna open to edit the video? A. B. C. D. MyPicnic.jpg MyPicnic.gif MyPicnic.wmv MyPicnic.mp3

83. John helps coach a soccer team. He is unable to accompany the team to a game. He logs on to the Internet and visits the Web site of a local news agency to watch the event live. Which Web video technology does the local news agency use? A. B. C. D. On-demand video streaming Real-time video streaming Web conferencing Voice over Internet Protocol (VoIP)

84. You use your digital camera to record your friend Jerry riding his new bike. You want to remove the portion in the video where he skids. Which one of the following software categories will you use to do this? A. B. C. D. Desktop publishing Instant messaging Digital video editing Presentation

85. Larry gives you a video of an event at his school. You are unable to view it by using the media player on your computer. What can Larry do to the video to help you view the video by using your media player? A. B. C. D. Convert the video from the existing format to another format Transfer the video through the Internet Store the video as a data file on a CD Add special effects to the video

Lesson 4: Digital Photography

86. Michael reads an article about digital cameras. He wants to know more about the term resolution. To help Michael, which of the following options will you use to define resolution? Select two. A. B. C. D. E. Sharpness of a picture Clarity of a picture Color of a picture Size of a lens Zoom of a camera

87. Angela's brother gives her a digital camera as a gift. She wants to know where the digital camera stores its pictures. Which of the following options will Angela's brother use to answer her question? A. B. C. D. Flash memory Film Tape Graphics card

88. Edmund wants to create an article by using his computer. However, his typing speed is quite slow. His friend Peter suggests a technology that enables him to enter text into documents on a computer by using voice. Which technology is Peter talking about? A. B. C. D. Speech synthesis Speech recognition Audio streaming Audio compression

89. Karina takes a few photos by using her friend's digital camera. She is now interested in buying a digital camera for herself. Karina asks you about the benefits of digital cameras. Which of the following points will you explain to her as benefits of digital cameras? Select two. A. B. C. D. E. No power required View photos without printing Browse the Web No lens required No film cost