. MS - Module 2 Microsoft Digital Literacy The Internet and the World Wide Web TECH LIT FINAL EXAM FY2011 Lesson 1: The Internet Objective 1.1: Describe the uses of the Internet. 1. You use your computer to chat with a friend who lives in another country. Which network lets you transfer the messages between your computer and your friend's computer? A. Intranet B. Internet C. Local area network (LAN) D. Ethernet 2. You visit your friend's house and find her searching for books on the Internet. Which of the following describes the status of your friend's computer? A. Online B. Offline C. Stand by D. Logged off 3. At home, your grandfather watches you working on your computer. He recently heard about the Internet and wants to know what it is. How will you define the Internet to him? A. A program installed on a computer B. An electronic device for printing documents C. A worldwide collection of computer networks D. A power backup source Objective 1.2: Identify the requirements for an Internet connection. 4. Your friend runs the local grocery store. He wants to provide online services for his customers and therefore needs to set up an Internet connection. Which of the following components does he need to set up the connection? Select two. A. Personal computer B. Printer C. Modem D. Web cam E. Floppy drive 5. Your neighbor has moved to another country. He informs you about his new job. You want to congratulate him by sending an e-mail message. Which of the following devices must you use to connect your computer to the Internet? A. Printer B. Scanner C. Modem D. Sound card 6. You own a small bookstore. Because of the popularity of the Internet, you decide to provide online services for your customers. Where will you go to get an Internet connection for your computer? A. Software development company B. Hardware company C. Internet cafe D. Internet service provider (ISP) 7. You purchase a computer so that you can work from home. You request an Internet connection from an Internet service provider (ISP). Which of the following physical devices will the ISP use to connect your computer to the Internet? A. Cables B. Speakers C. Scanners D. Floppy disks 8. Alan wants an Internet connection for his new laptop. He does not want to connect to the Internet through cables. Which of the following components will Alan use to connect his computer to the Internet? A. Floppy drive B. Modem C. WiFi card D. Display card Objective 1.3: Identify the features of two types of Internet connections. 9. Wide World Importers has clients in various countries. It requires its employees to work in shifts and communicate with each other through the Internet. Therefore, it needs an Internet connection that is fast and always available. What type of Internet connection does Wide World Importers use? A. Dial-up B. Dedicated C. Digital D. Modem 10. You go to your friend's house to play an online game. You hear modem tones when your friend's computer sends a request to the Internet service provider (ISP) to establish the Internet connection. What type of Internet connection does your friend use? A. Dial-up B. Broadband C. WiFi D. Dedicated 11. You have a computer at home. The computer is connected to the Internet through a dial-up connection. Every time you connect to the Internet, you send a request to the Internet service provider (ISP). Which device establishes this connection? A. Sound card B. Modem C. Microphone D. Speaker Objective 1.4: Relate the term bandwidth to types of Internet connections. 12. Four of your friends simultaneously download a large article from the Internet. If your friends have the connections shown in the following exhibit, who will be the last one to finish downloading the file? A. Nikhil B. David C. Susan D. Ken Lesson 2: The World Wide Web Objective 2.1: Describe the components of the Web. 13. You want to use the Internet to view a list of the latest movies. Which of the following must you use to access the Internet? A. Microsoft® Notepad B. Microsoft® Paint C. Web browser D. Address book 14. Your friend wants to create and publish a Web page. He tells you that he wants to learn the language that is used to create a Web page. Which language will you suggest to him? A. Wireless Markup Language B. Hypertext Transfer Language C. Hypertext Markup Language D. Standard General Language Objective 2.2: Explain how Web addresses work. 15. Your friend creates and publishes a Web site. You want to open it on your computer. Which of the following options will you need to easily identify and access the Web site? A. Domain name B. Alphanumeric code C. American Standard Code for Information Interchange (ASCII) D. Your friend's name 16. Sabina creates a Web site for the first time. She wants to know which protocol her Web browser uses to display Web pages. Which of the following protocols does her Web browser use? A. File Transfer Protocol (FTP) B. Hypertext Transfer Protocol (HTTP) C. Simple Mail Transfer Protocol (SMTP) D. Internet Protocol (IP) 17. Your brother sends you an e-mail message that includes various URLs. Which one of the following is a valid URL? A. http://www.margiestravel.com B. www\\margiestravel.com C. http://com.margiestravel.www D. http\\:www.margiestravel.com Objective 2.3: Explore Web sites by using a browser. 18. You open the home page for www.alpineskihouse.com. On the home page, you see a link for the weather report. You want to view the weather report in a separate window, but you do not want the home page to close. What will you do to view the weather report in a separate window? A. Type the keyword weather in the address bar and then click New Page. B. Click the link for the weather report. C. Right-click the link for the weather report and then click Open in New Window. D. Type the keyword weather in the Search box. Lesson 3: Using E-mail Objective 3.1: Explain how e-mail works. 19. You recently bought a computer and set up an Internet connection. You want to compose, send, receive, and store e-mail messages on your computer by using Windows Mail. Your operating system is Microsoft® Windows® Vista. You access the Internet through an Internet service provider (ISP). Which of the following options must work properly for you to send and receive e-mail messages by using Windows Mail? Select three. A. E-mail server B. E-mail client C. Home page on your ISP Web site D. E-mail account page on your ISP Web site E. Internet connection F. Authoring program 20. You are explaining the concept of e-mail to your friend. Which of the following options will you use as an analogy? A. Postal mail B. Telephone directory C. Fax machine D. Digital diary 21. Peter wants to exchange e-mail messages with his friends and colleagues. Which of the following entities does he need to exchange e-mail messages? Select two. A. Computer B. Internet access C. Printer D. Plug-in E. Search engine 22. You need to send a message over the Internet to your friend Paula. What information do you need to send a message to Paula? A. Telephone number B. E-mail address C. Home address D. Company address 23. You want to tell a friend about the significance of e-mail. Which of the following options can you use to explain the significance of e-mail? Select two. A. You can access it anywhere in the world. B. You can use it to send text and picture messages. C. You can use it to send fax messages. D. You can use it to scan pictures. E. It allows you to record audio. 24. Salman is curious about e-mail. He asks you about the medium that is used to send an e-mail message. Which of the following options will you use to answer his question? A. Fax machine B. Postal service C. Courier service D. Internet 25. Your friend has received a promotion. You want to send an e-mail message to congratulate him. You want to create a Microsoft Hotmail® account to send this message. Arrange the steps in the list below in the order in which you will proceed to create a Hotmail account. Steps A. Enter account information. B. Create an e-mail address. C. Open www.hotmail.com. D. Click the link for the new account. Objective 3.2: Manage e-mail messages. 26. As you read your e-mail messages in Windows Mail, you notice that some messages require a follow-up activity. What will you do to ensure that you remember to do the follow-up activity for the messages? A. Create a To Do list. B. Sort messages by name. C. Set a flag. D. Move the e-mail messages to a new folder. 27. Anna has used e-mail for more than a year. She now has difficulty keeping track of the contact details of all the people with whom she communicates. Identify the method by which Anna can easily access all of the contact details in alphabetical order. A. Create Signature B. Use Address Book. C. Sort by name D. Set a Flag Objective 3.3: Identify the correct e-mail etiquette. 28. You want to write an e-mail and convey your emotions to a friend. Which of the following will you use in your e-mail message? A. Upper case characters B. Inflammatory language C. Smilies D. Exclamation points 29. You want to send an e-mail to apply for a job in a company. Which of the following will you use in your e-mail message? A. Attractive colors B. Smilies C. Fancy quotations D. Formal Salutation 30. You want to send your photographs to a friend. What should you do to make sure that your friend's e-mail inbox does not get filled? A. Compress Attachment B. Format Message C. Use Rich Format D. Use Default Formatting 31. You want to write an e-mail to your senior applying for leave. Which of the following will you use in your e-mail message? A. Fancy Quotations B. Signature C. Emoticons D. Ellipses Lesson 4: Other Methods of Communicating on the Internet. Objective 4.1: Identify the features of online communities. 32. Your brother wants to create an online journal to document a special event so that all of your friends can view the pictures and illustrations. Which of the following online communities will help him create this online journal? A. Blog B. Chat group C. Newsgroup D. Bulletin board 33. You want to chat with your friends over the Internet. Which program must you install to do this? A. Microsoft Windows Messenger B. Microsoft Paint C. Microsoft® Office Word® 2007 D. Microsoft® Office Excel® 2007 Objective 4.2: Explain how to create and publish Web pages. 34. You are working on an assignment to create a Web site. Which of the following programs will you use to create the Web pages for the Web site? A. Microsoft® Paint B. Microsoft® Expression® Web C. Microsoft® Office PowerPoint® 2007 D. Microsoft® Office Excel® 2007 35. Your friend wants to know about Microsoft® Expression® Web. Which of the following terms will you use to describe Microsoft® Expression® Web? A. Web browser B. Web authoring tool C. Spreadsheet D. Graphics tool 36. You want to tell Michael about the uses of Microsoft® Expression® Web. Which of the following uses will you mention? A. Taking photographs B. Creating graphics C. Sending e-mail messages D. Creating Web sites 37. David wants to publish a Web site. He has an Internet connection from an Internet service provider (ISP). Which one of the following features provided by an ISP will enable David to publish the Web pages? A. File Transfer Protocol (FTP) B. Hypertext Transfer Protocol (HTTP) C. Simple Mail Transfer Protocol (SMTP) D. Simple Network Management Protocol (SNMP) Comments Anonymous You do not have permission to add comments. MS - Module 3 Microsoft Digital Literacy Productivity Programs TECH LIT FINAL EXAM FY2011 Lesson 2: Common Features and Commands Objective 2.1: Identify the main components of the graphical user interface (GUI) of a productivity program. 1. Markus creates a document by using Microsoft® Office Word 2007 and saves it with the name Office.doc. Which of the following components of Word 2007 will display the document name? A. Work Area B. Quick Access Toolbar C. Title bar D. Status bar 2. Cornelia uses Microsoft® Office Excel® 2007 to create a worksheet that contains the estimated costs of her business project. She wants to update certain costs. Which component of Excel 2007 will display the changes in the worksheet? A. Title bar B. Work area C. Name box D. Formula bar Objective 2.2: Use the pointer to navigate in a program. 3. You use Office Word 2007 to write an essay about uses of computers. After typing the document, you notice that a few words have a red wavy underline as shown in the exhibit. Using the mouse, which action will you perform to view the shortcut menu for the underlined words? A. Right-click B. Double-click C. Click D. Scroll 4. You want to send an e-mail message to your friend to describe your meeting with Michal. However, you incorrectly type the name as Michael. Where will you place the insertion point if you want to use the DELETE key to remove the letter e in the name Michael? A. After the letter l B. Before the letter l C. Before the letter e D. After the letter e Objective 2.3: Identify the tabs, groups, and commands on the Ribbon. 5. Stephan creates a business presentation by using Microsoft Office PowerPoint 2007. He saves it with the name Presentation.pptx. Stephan opens the file to make some changes, and he wants to save it with a different name. Which of the following commands on the Microsoft Office menu will Stephan use to save the file with a different name? A. Save B. Save As C. Publish D. Prepare 6. Nina uses Excel 2007 to create a work plan for her team. She wants to print the plan and discuss it with the team members in a meeting. Which of the following tabs will Nina use to print the plan? A. Home B. Page Layout C. Data D. View 7. You use Office Word 2007 to create a business document. You copy text from another document and want to add it to your business document. Which group on the Home tab will you use for this? A. Clipboard B. Font C. Paragraph D. Editing 8. Ewa creates a table by using Word 2007 to record some data. She wants to increase the size of the text in the table to make it more readable. Which group on the Home tab will Ewa use to change the size of the text in the table? A. Font B. Paragraph C. Styles D. Editing Objective 2.4: Use the buttons on the toolbars to perform various tasks. 9. You want to access the commands used frequently while formatting a text. Where can you add the buttons for accessing the commands promptly in the interface? A. Ribbon B. Mini Toolbar C. Quick Access Toolbar D. Groups 10. You want to use the Mini Toolbar that appears when the text is selected. What option can you use in the Mini Toolbar? A. Print B. Copy C. Cut D. Font type Objective 2.5: Type text and characters in a program by using the keyboard. 11. You want to access your MSN® Hotmail® account to check e-mail messages. The characters in your password are in upper case. Which key will you press on the keyboard to type the password correctly in upper case? A. NUM LOCK B. CAPS LOCK C. INSERT D. CTRL 12. You create a document in which you forget to include an important line in a paragraph. When you type the missing text, you begin to overwrite the existing text. Which key do you press on the keyboard to ensure that the new text does not overwrite the existing text in the paragraph? A. INSERT B. BACKSPACE C. SPACEBAR D. ENTER Objective 2.6: Explain the use of keyboard shortcuts and key combinations. 13. You create a business presentation by using Office PowerPoint 2007. Which key will you use as a shortcut to display a slide show in PowerPoint 2007? A. F5 B. F6 C. F7 D. F8 14. You are at the tenth page of a 20-page document. You need to make changes on the last page of the document. Which key will you use in combination with CTRL to move to the bottom of the last page? A. ESC B. SHIFT C. HOME D. END 15. Peter wants to protect a confidential document by using a password. He wants to use an asterisk and an ampersand symbol in his password. Which of the following keys does he press in combination with the number keys to correctly type the symbols in his password? A. SHIFT B. INSERT C. SPACEBAR D. BACKSPACE 16. You create a document by using Office Word 2007. You need to enter the copyright symbol in this document. Which key combination will you use to add the copyright symbol? A. ALT+0169 B. TAB+0169 C. INSERT+0169 D. SHIFT+0169 Lesson 3: Introduction to Word Processors Objective 3.1: Perform basic tasks in a word processor. 17. Anna is learning how to use a word processor. She wants to know the various tasks that she can perform by using this program. Which of the following options will answer her question? Select four. A. Create documents B. Edit videos C. Host a Web site D. Format text E. Edit documents F. Print pages G. Perform real-time communication 18. Your friend sees you working on Microsoft® Office Word 2007. He wants to know how to start this program. Arrange the steps in the following list in the order in which you will perform them to start Word. Steps: A. Click Start. B. Click Microsoft Office. C. Point to All Programs. D. Click Microsoft Office Word 2007. 19. Waleed creates a 100-page document. He wants to review the document from the beginning. He does not want to scroll up, but he wants to reach the beginning of the document by using the shortest method. Which of the following keys will he use? A. CTRL+UP ARROW B. HOME C. CTRL+HOME D. UP ARROW Objective 3.2: Edit and format text 20. Christa makes a list of the guests she wants to invite to her daughter's wedding. She types the guest names and contact details in a document in Office Word 2007. She wants to know how many guests are on the list. Which of the following features will help Christa track the number of guests while she makes the list? A. Bullets and Numbering B. AutoFormat C. Reviewing D. Word Count 21. Your friend wants to move text from the first paragraph of an article to the last paragraph by using the quickest method. Which of the following options will help him do this? A. Delete the text from the first paragraph and then type it in the last paragraph. B. Use the Cut command to delete the text from the first paragraph, and then paste it in the last paragraph. C. Type the text of the first paragraph in the last paragraph and then delete it from the first paragraph. D. Enter the text of the first paragraph in a new document. Objective 3.3: Work with tables and pictures 22. Tony creates a table by using Office Word 2007. He wants to shade some cells in a row. He selects the cells and now wants to know how to shade them. Arrange the steps in the following list in the order in which Tony will perform them to shade the cells. Steps: A. In the Table Styles group, click the Shading drop-down list. B. Click OK. C. Select a color. D. Click the Design tab. 23. Jim wants to insert the logo of his company at the top of a document in Word 2007. The logo is saved in the Pictures folder. Arrange the steps in the following list in the order in which Jim will perform them to insert the logo from the Pictures folder. Steps: A. Click the Insert button. B. Select the file that contains the logo image. C. Place the pointer where the logo should be inserted. D. Click the Insert tab. E. Click Picture. 24. Karim uses Word 2007 to create a table that lists his expenses for January and February, as shown in the exhibit. He also wants to include his transportation expenses for January and February. What will he do to include in the table the information about his transportation expenses? A. Add a column. B. Insert a row. C. Add a cell. D. Modify the paper size. Objective 3.4: Proofread a document 25. Isabel wants to write an essay in Spanish by using Office Word 2007. She wants to use the language tools for Spanish, such as the spelling checker that Word provides. Which of the following tabs will she use to set the language to Spanish so that she can use the language tools for Spanish? A. Review B. View C. References D. Insert 26. Daniela creates a document by using Office Word 2007, as shown in the exhibit. She uses the Spelling and Grammar tool to detect a misspelled word. Which of the following buttons will Daniela use to correct the spelling of this word throughout the document? A. Change All B. Accept Change C. AutoFormat D. Track Changes 27. Your friend wants to know about the AutoCorrect feature of Word 2007. What will you tell her about the AutoCorrect feature? A. It helps you define the formatting attributes in a document. B. It identifies spelling errors while you type and suggests alternatives for them. C. It formats the styles of the text. D. It enables you to set default paper margins. Objective 3.5: Identify the benefits of DTP. 28. Barbara wants to create a newsletter. She needs a program that provides several newsletter templates. Which of the following programs will meet her needs? A. Desktop publishing program B. Presentation program C. E-mail program D. Spreadsheet program 29. David wants to know the benefits of desktop publishing programs. Which of the following benefits do desktop publishing programs provide? Select Two. A. Advanced formatting techniques B. Control for longer documents C. Video editing D. Virus scanning E. Web site browsing Lesson 4: Introduction to Spreadsheet Programs Objective 4.1: Identify the components of a spreadsheet. 30. Syed wants to know how to properly refer to the intersection of a row and a column in a spreadsheet. Which of the following options answers his question? A. Cell B. Label C. Value D. Worksheet 31. Richard creates his monthly budget on a worksheet in Microsoft® Office Excel 2007. He enters data in the worksheet, as displayed in the exhibit. What is the collection of cells containing the data called? A. Cell range B. Row C. Column D. Cell pointer 32. Charlotte creates her expense sheet for the month, as shown in the exhibit. Which column will she use to enter the amount spent on fuel? A. B B. C C. 7 D. 8 Objective 4.2: Enter data into a spreadsheet. 33. Your friend sees you working in Excel 2007 and wants to know how to start this program. Arrange the steps in the following list in the order in which you will perform them to start Excel. Steps: A. Click Start. B. Click Microsoft Office. C. Point to All Programs. D. Click Microsoft Office Excel 2007. 34. Oliver plans to buy some household items. He lists all the household items and their expected prices in a worksheet in Excel 2007. He wants to sort all of the items by price, in ascending order. Arrange the steps in the following list in the order in which Oliver will perform them to sort the items in the budget. Steps: A. On the Ribbon, click Data. B. Select the cell range that needs to be sorted. C. Select Sort by as price D. Open the worksheet. E. Click Sort. F. Select Order as Smallest to Largest G. Select Sort On as Values H. Click OK. 35. John creates budget sheets for his project by using Office Excel 2007. He wants to replace the name of the current budget sheet with another name. Arrange the steps in the following list in the order in which John will perform them to rename the worksheet. Steps: A. Press ENTER. B. Type the new name. C. Select the worksheet that needs to be renamed. D. Double-click the worksheet tab. Objective 4.3: Perform basic mathematical tasks in a spreadsheet. 36. Alexander lends some money to Niraj. Alexander maintains a worksheet that lists the amount and the date when he lent money to Niraj, as displayed in the exhibit. He wants to calculate the total amount of money he lent to Niraj. The list is very long, and he wants to know if there is a button that he can click to calculate the total amount due. Which of the following options will Alexander select? A. AutoSum B. AutoCorrect C. AutoSummarize D. AutoFormat 37. Erik receives his report card and wants to calculate his average marks. The exhibit displays the worksheet that Erik created. Identify the formula that Erik will use to calculate the average. A. =AVERAGE(A2:A6) B. =AVERAGE(B2:B6) C. =AVERAGE(A6:B6) D. =AVERAGE(A2:B6) 38. Vladimir borrows some money from Victor and then returns some of the amount to Victor the next day. Vladimir wants to know how much money he still owes to Victor. He maintains all of the records in a worksheet, as displayed in the exhibit. Which of the following formulas will Vladimir use? A. =Sub(A2,B2) B. =A2-B2 C. =Minus(A2-B2) D. =Sub(A2-B2) 39. David wants to copy all the files from his office computer to his laptop. To prepare, he calculates the total size of the files he needs to copy. The files and their sizes are displayed in the exhibit. David wants to enter the formula in a cell to calculate this sum. Arrange the steps in the following list in the order in which David will perform them. Steps: A. In the Select A Function list, select SUM. B. Select the cell range. C. Click the Functions tab. D. Click OK. E. Click Insert Function. F. Click OK. 40. David uses Office Excel 2007 to calculate his average marks. He enters a formula in cell B5 to calculate the average based on the values in cells B2 to B4, as displayed in the exhibit. David realizes that he entered his Science score as 67 instead of 69. What will cell B5 display if he changes the value in cell B4 to 69? A. Updated average B. Blank cell C. Error message D. #DIV/0! Objective 4.4: Insert charts in a spreadsheet program. 41. Dina plans her budget. She wants to know what part of the total expenses she spent on groceries last month. She uses a spreadsheet and wants to make a chart to depict the portion spent on the groceries. Which of the following charts will meet her needs? A. Line B. Pie C. Surface D. Area 42. Marko uses Excel 2007 to create a budget sheet for the total expenses that he spends on household items. He wants to view the data in a graph. Which tool will he use to represent the data through a graph? A. Chart Wizard B. AutoContent Wizard C. Clip art gallery D. Budget Template Wizard 43. Patrik wants to show his household expenses through a pie chart. He wants to know the method to insert a pie chart in a worksheet in Excel 2007. Arrange the steps in the following list in the sequence that will help Patrik to insert the chart. Steps: A. Click the Insert tab. B. Select the type of Pie chart C. In the Chart group, click Pie. D. Select the cell range. Lesson 5: Introduction to Presentation Programs Objective 5.1: Identify the elements of a presentation program. 44. Your friend sees you working on a presentation program. She wants to know about the features of this program. Identify the features of presentation programs. Select two. A. Creates audio-visual presentations B. Creates handouts C. Edits video D. Performs calculations E. Enables real-time communication Objective 5.2: Create a presentation. 45. David uses Microsoft® Office PowerPoint® 2007 to create a presentation. He wants to add more slides to the presentation. Which of the following tabs will he use to add slides to the presentation? A. Home B. Insert C. Design D. View 46. Carol is learning to create a presentation by using PowerPoint 2007. She wants to know how to add display effects on various slides of the presentation. Which of the following options will you suggest to her? A. Layout B. Transition to this slide C. Themes D. Illustrations 47. Pia creates a presentation by using PowerPoint. The slides in the presentation must contain a title, a bulleted list, and a diagram. Which of the following options will she select to do this? A. Chart B. Transition to this slide C. Background Styles D. Layout Objective 5.3: Add graphics and multimedia into a presentation. 48. You create a presentation by using Office PowerPoint 2007.You open the Insert tab to add a sound file to a slide. Arrange the following steps in the order in which you will perform them to add a sound file to the slide. Place the first step at the top of the list. Steps: A. Click Sound. B. Select the audio file that you want to add. C. Select Sound from File D. Go to Media Clips group E. Click OK. 49. You create a presentation by using PowerPoint. Which of the following tabs will you use to add geometric shapes to the presentation? A. Drawing tools B. Design C. View D. Animations 50. Laura wants to rearrange the slides of a presentation created by using PowerPoint 2007. Which of the following views will enable Laura to perform her task easily? A. Notes Page B. Slide Sorter C. Normal D. Slide Show 51. Stella uses PowerPoint to create a presentation about the performance of her class. In the presentation, she wants to show a comparison between the assessment scores of her class in the current year and the previous year. Which of the following objects will Stella add to the presentation to display the comparison? A. SmartArt B. Video clips C. Clip Art D. Chart 52. You use PowerPoint 2007 to prepare a presentation about the quarterly performance of your organization across various regions. You represent this graphically by adding a Line chart in your presentation. However, you want to transform the Line chart to a Column chart. To do this, you double-click the chart to display the Chart menu. Which of the following Chart menu commands will you use to replace the Line chart with a Column chart? A. Change Chart Type B. Shape Styles C. Chart Styles D. Chart Layouts Objective 5.4: Use the print options that are available in a presentation program. 53. You create a presentation by using PowerPoint. You include examples in the presentation for your reference, as shown in the exhibit. You need to print the presentation to take it home. Which of the following options will you select in the Print box to ensure that the examples are also printed? A. Notes Pages B. Slides C. Handouts D. Outline View 54. Larry prepares a presentation by using PowerPoint 2007. He needs to print the presentation to keep the key points handy. He wants an overview of the text in the slides, and he does not want to print the graphics. Which of the following formats will Larry select in the Print box to print the presentation? A. Notes Pages B. Slides C. Handouts D. Outline View Lesson 6: Introduction to Database Programs Objective 6.1: Explain basic concepts of a database. 55. Paula manages the recruitments for A. Datum Corporation. The company hires 500 employees. Paula needs to store on her computer the personal details, compensation structure, and insurance details for each employee. Which of the following programs will Paula use? A. Microsoft® Notepad B. Photo editing program C. Presentation program D. Database program 56. Raman is a school administrator. He wants to store the records of all the students on his computer. He wants to maintain a database of all the records. Which of the following objects can he create by using a database program? Select three. A. Reports B. Forms C. Tables D. Video clips E. Presentations F. Pictures 57. Michelle is a teacher at the School of Fine Art. She wants to start Microsoft Office Access 2007 to update the student database by entering details about the students in her class. Arrange the steps in the following list in the order in which Michelle will perform them to start Access on her computer. Steps: A. Point to All Programs. B. Click Microsoft Office Access 2007. C. Click Microsoft Office. D. Click Start. 58. Ken creates a database in Access and saves it on his computer. He wants to open this database to view some details. Arrange the steps in the following list in the order in which Ken will perform them to open the database. Steps: A. In the Microsoft Office menu, click Open. B. In the folder, double-click the database file. C. In the Database window, click Open. D. Select the folder where the file is saved. E. In the Database window, click the object that you want to open. Objective 6.2: Create a database. 59. You create a table in the employee database of your company. You want the employee codes to be unique. Which of the following actions will you perform on the Employee Code field in the database table? A. Define the field as a primary key. B. Specify the data type as text. C. Set a Validation Rule for the field. D. Create an Input Mask for the field. 60. Stephanie wants to create a new table in Access 2007 and set indexing options to it. Which of the following options in Tables will she use? A. Table. B. Table Design. C. Table Template. D. Sharepoint Lists. 61. Larry creates a table by using Access 2007. He wants to set data types for the fields in the table. In which of the following views will Larry open the table to set the data types? A. Datasheet View B. Design View C. PivotTable View D. PivotChart View 62. Mark is a librarian at the School of Fine Art. By using Access 2007, he wants to create a database of the books, along with its category, price and description. Which of the following Table Templates will Mark use? A. Events B. Assets C. Issues D. Tasks Objective 6.3: Work with records in a database. 63. You work with Contoso, Ltd. Jesper is a newly hired manager in your company. You want to include his personal details in the employee database table. Which of the following actions will you perform to include Jesper's details in the table? A. Add a record in the table. B. Add a field in the table. C. Apply a filter to the database. D. Generate a report by using the table. 64. Karim is a shopkeeper. Every day he needs to check the quantity of available items in his shop. To easily maintain the records and get the updated inventory details, he creates a table in Access. Which of the following data types will Karim use to enter the quantity of each item? A. Text B. Number C. Memo D. AutoNumber 65. You create a table in Access 2007. You want to view the names in the table in alphabetical order. Which of the following actions will you perform on the Name field? A. Set up Validation Rule. B. Set up a Format. C. Sort in ascending order. D. Create a query. Objective 6.4: Explain what database queries are and how they work 66. You want to create a new query in Access 2007 that displays data in a compact, spreadsheet-like format. Which of the following wizard will you use? A. Simple Query B. Crosstab Query C. Find Duplicates Query D. Find Unmatched Query 67. Richard joins your team. You ask him to update the office database. He wants to know what a database query is. What will you tell Richard? A. A question that retrieves data, based on the criteria you specify B. A program that produces a printed report of the data in the database C. A program that simplifies data entry D. An object that updates the operating system Objective 6.5: Work with reports. 68. Daniel needs to work with databases frequently. He wants to learn about database reports. For which of the following purposes can he use the reports? Select two. A. Organize data B. Summarize data C. Enter data D. Search data E. Modify data Comments Anonymous undefined Your +mention will add people to this discussion and send an email. Making sure people you mentioned have access… The assigned person will be notified and responsible for marking as done. Cancel You do not have permission to add comments. Sign in|Report Abuse|Print Page|Powered By Google Sites MS - Module 4 Microsoft Digital Literacy Module 4: Computer Security and Privacy TECH LIT FINAL EXAM Lesson 1: Introduction to Computer Security and Privacy Objective 1.1: Explain computer security and privacy. 1. You accidentally delete a registry file. Now you cannot start your computer. What kind of computer threat is this? 1. Spoofing 2. Phishing 3. Software piracy 4. Human error 2. Someone has tampered with your computer and erased data. What kind of computer threat is this? 1. Physical theft 2. Security 3. Environmental 4. Spyware 3. You want a new stand-alone computer. What will you do to prevent others from accessing your confidential data in this computer? 1. Use an uninterruptible power supply (UPS) and a surge protector. 2. Use a user name and password. 3. Back up data and save it in a different location. 4. Install a spyware program and an antivirus program. 4. Your friend is confused with the terms privacy and security. She comes to you with a list of threats to computers. Which of the following threats will you categorize as a threat to computer privacy? 1. Accidental erasure of data 2. Hardware failure 3. Damage to computer because of an earthquake 4. Theft of confidential data Objective 1.2: Identify natural threats to your computer. 5. Your computer does not work when it heats up. What is affecting your computer in this case? 1. Hackers trying to access your computer 2. Firewall installed in your computer 3. Many programs opened simultaneously 4. Environment surrounding your computer 6. After a voltage fluctuation, your computer stops working. What will you do to prevent this problem in the future? 1. Use a surge protector. 2. Install an antivirus program. 3. Use spyware. 4. Back up data. Objective 1.3: Identify measures to protect your computer against natural threats. 7. There is a hurricane alert in your area. Which one of the following actions will you take to protect the data in your computer? 1. Install a virus protection program. 2. Store the data in a safe location. 3. Install spyware-fighting software. 4. Install a firewall to prevent hacking. 8. Frequent power outages happen in your area. How can you protect your computer from this when a power outage happens? 1. Use an uninterruptible power supply (UPS). 2. Use a firewall. 3. Use a surge protector. 4. Install an antivirus program. Objective 1.4: Identify threats to your computer from human actions. 9. You spilled coffee on your computer. What kind of threat is this? 1. Human error 2. Natural disaster 3. Environmental threat 4. Hacking 10. You receive an e-mail message. The sender of the message claims to be a bank executive and wants your personal information to open an account for you. Which one of the following terms describes this activity? 1. Internet Scam 2. Spyware 3. Hacking 4. Online Predating 11. You are unable to log on to your e-mail account. You realize that someone has changed the password without your knowledge. Which one of the following terms describes this activity? 1. Online Predating 2. Theft 3. Internet Scam 4. Spyware Objective 1.5: Identify measures to protect your computer against threats from human actions. 12. The system administrator informs you that a Trojan horse has infected your computer. Which program did the system administrator use to determine this? 1. Microsoft® Windows® Firewall 2. Microsoft® Internet Explorer® 3. Antivirus 4. Uninterruptible power supply (UPS) 13. You cannot access a file in a computer that belongs to your friend. What prevents you from accessing the file? 1. Spyware 2. Firewall 3. Antivirus 4. Uninterruptible power supply (UPS) 14. The network administrator informs you that Niraj is viewing inappropriate Web sites. A program installed on Niraj's computer monitors his browsing activities without his knowledge. What type of program is installed on Niraj's computer? 1. Antivirus 2. Microsoft Windows Update 3. Spyware 4. Firewall Lesson 2: Protecting Your Computer Objective 2.1: Identify guidelines for protecting your computer. 15. Northwind Traders wants to grant network access only to specific employees. Which of the following methods can help Northwind Traders restrict the use of the network? A. Lock combination B. Data encryption C. Data backup. D. User identification 16. You need to go to an urgent meeting. You do not want your colleagues to use your computer in your absence. Which of the following methods will you use to ensure that no one uses your computer while you are away? A. Turn off the monitor. B. Use Lock Computer button. C. Use a firewall. D. Install updates for your computer. 17. Tulin sets a password for her computer. However, she suspects that someone is accessing her computer in her absence. Which of the following methods will help Tulin ensure that nobody accesses her computer without her permission? A. Use a spyware-fighting program. B. Update the operating system. C. Deploy a firewall. D. Change the password frequently. 18. Your friend installs security patches on his computer. Which of the following benefits will these security patches provide? A. Protecting the computer from malicious attacks. B. Updating the antivirus program C. Creating periodic backups D. Preventing spam e-mail messages Objective 2.2: Identify best practices for securing online and network transactions. 19. Robert works for Blue Yonder Airlines. Managers of his organization notice that some employees use corporate applications for unethical purposes. Which of the following tools can managers use to check this unethical practice? A. Antivirus program B. Spyware C. Cookies D. Firewall 20. Tony wants to purchase books from a Web site. Which of the following will ensure that the Web site is secure for online transactions? A. Windows Firewall B. Secure Sockets Layer (SSL) C. Cookies D. Antivirus program 21. Your friend wants to know about Secure Sockets Layer (SSL). What will you explain to him? A. A means of checking if a document on the Web is genuine B. A standard and a secure way of presenting information C. A means to validate the identity of the user who accesses a Web site D. A standard for encoding information that is sent over the Web 22. Syed visits his friend Karen. He uses her computer to perform multiple banking transactions online. He wants to ensure that after he leaves, no one else can know which Web sites he visited. Which of the following actions will he perform to ensure this? Select three. A. Enable active content B. Disable Windows Firewall C. Delete cookies D. Reset Web settings E. Clear browser cache F. Empty Recycle Bin G. Clear history 23. Apurva Dalia wants to set a password for his online banking account. Which of the following passwords is a strong password? A. Password B. ABC C. ApurvaDalia D. ADalia#175 24. Your friend wants to know about the methods for securing online and network transactions. Which of the following methods will you suggest to her? Select two. A. Check history files. B. Disable Automatic Updates. C. Enable Windows Firewall. D. Use strong passwords. E. Enable active content. Objective 2.3: Identify measures for securing e-mail and instant messaging transactions. 25. Viktor likes to exchange e-mail messages with his friends. Every day, he receives many messages with attachments. Viktor wants to protect his computer from virus attacks by e-mail. Which of the following guidelines will Viktor apply to protect his computer? A. Reply to spam e-mail messages B. Copy attachments to his computer before opening them. C. Avoid opening e-mail attachments from unknown users. D. Reinstall the e-mail client periodically. 26. Your friend uses instant messaging to chat with friends. He wants to ensure that his instant messaging transactions are secure. Which of the following guidelines will you suggest? A. Chat with only one user at a time. B. Use different programs to chat with different users C. Open attachments received over chat. D. Chat with known users. 27. You receive an e-mail message from an unknown user. This message includes an .exe file as an attachment. What will you do with this message? A. Install the .exe file. B. Save the attachment on your computer. C. Delete the message. D. Move the message to another folder. 28. Manish wants to know about some common guidelines for securing e-mail transactions. Which of the following guidelines will you suggest to him? A. Archive e-mail messages that include attachments. B. Save junk e-mail messages in a separate folder. C. Reply to spam e-mail messages. D. Delete e-mail messages that include attachments from unknown users. 29. Milena receives several e-mail messages in a day. Her mailbox holds messages from her bank, Internet service provider (ISP), and friends. She also has unsolicited messages about products and discounts. Which of the following messages in Milena's mailbox is a spam message? A. Account details from her bank B. E-mail account details from her ISP C. Commercial information from an unknown sender D. A message from a friend that includes family pictures Lesson 3: Protecting Your Family from Security Threats. Objective 3.1: Identify measures that you can use to protect your privacy. 30. Your friend wants to ensure that his project data is secure and can be restored in case of an environmental disaster. Which of the following measures will you suggest to him? A. Maintain a backup in a secure location. B. Update the antivirus program. C. Use Microsoft® Windows® Update. D. Install a spyware-fighting program. 31. You receive an e-mail message from an unknown e-mail address. The message requests you to share your credit card details to receive a discount on some music CDs. What will you do with this message? A. Reply to the message to provide your credit card details. B. Encrypt the message. C. Scan the message for viruses. D. Delete the message. 32. Karim wants to send confidential information over e-mail to his colleague. Which of the following measures will he apply to ensure the privacy of the e-mail message? A. Use a spyware-fighting program. B. Encrypt the e-mail message. C. Use e-mail filters. D. Maintain a backup of the e-mail message. 33. Gloria uses the Internet frequently for online purchasing. To protect her system from virus attacks, she installs an antivirus program. However, within a few days, she gets a virus alert on her system. Which of the following measures will she implement to prevent this virus in the future? A. Update and run virus scans daily. B. Update the Internet browser. C. Check Windows Update. D. Use a strong password. 34. You want to encrypt a confidential e-mail message before you send it to your colleague. Which of the following programs will you use to encrypt the message? A. Firewall B. Spyware C. Microsoft® Office Outlook®2007 D. Microsoft® Windows® Update 35. Pia wants to verify that the system she is using is updated with the latest security patches. Which of the following options will she use to check these settings? A. Windows Mail B. Microsoft® Office Outlook® 2007 C. Microsoft Office D. Microsoft Windows Update 36. You want to purchase DVDs from a Web site. Which of the following options will you use to verify that the Web site is secure for online transactions? A. Encryption tool B. Automatic Updates icon C. Locked padlock icon D. Internet service provider (ISP) logo 37. Lina is unable to access the e-mail account that her Internet service provider (ISP) provides. She realizes that someone has hacked into her account. What action will she take to remedy this issue? A. Protect her computer from surges and spikes. B. Use Microsoft® Windows® Update. C. Install spyware. D. Report the incident to her ISP. Objective 3.2: Identify guidelines to protect your family from online predators. 38. You want to educate your family about the signs of an online predator. Which of the following signs will you share with your family? A. Sends viruses B. Tries to involve you in a relationship C. Steals passwords D. Sends junk e-mail messages 39. Naoki notices that his teenage children like to chat online. Which of the following guidelines will Naoki recommend to ensure their safety from online predators? A. Chat only with people they know. B. Use private chat areas. C. Install multiple chat programs. D. Chat with one person at a time. 40. Your children need to access the Internet frequently. Therefore, you install an Internet connection on your computer. Which of the following precautions will you take when your children access the Internet? A. Regularly check the Web sites your children visit. B. Block Web sites that offer free e-mail accounts. C. Block all search engines. D. Recommend use of chat rooms instead of e-mail. 41. Your niece uses the Internet frequently. You want to block some Web sites that are inappropriate for her age group. How will you block these Web sites? A. Update the antivirus program. B. Install spyware. C. Use filter programs. D. Check Windows Update. 42. Tamer's children use the Internet to chat with their friends. He wants to protect his children from online predators. Which of the following guidelines will you recommend? A. Update the operating system B. Deploy a firewall. C. Block Web sites that offer free chat programs. D. Set up a program that monitors online chat. 43. You see your friend chatting with an unknown user. Which of the following guidelines will you recommend to ensure safety over chat? A. Close the chat program. B. Reply to users who seek your personal information. C. Share personal information only with people you trust. D. Use private chat areas. 44. Kitti receives an e-mail message from an unknown e-mail address offering discounts on game CDs. As specified in the message, Kitti needs to share his name, age, and contact information to receive the discount. Which of the following actions does Kitti need to take? A. Send his personal information to receive the discount. B. Delete the e-mail message. C. Use a spyware-fighting program. D. Forward the e-mail message to friends. Lesson 4: Keeping Your Computer Secure and Updated Objective 4.1: Explain the different security settings on your computer. 45. Jim discovers that his son visits Web sites that are inappropriate for his age. Jim wants to restrict access to these sites. Which of the following security settings will help Jim to block these sites? A. Windows Firewall B. Internet Options C. Automatic Updates D. Antivirus Options 46. Jack is annoyed with the pop-up messages that appear whenever he visits a Web site. He wants to block all of the pop-up messages. Which of the following security settings will help him to block all of the pop-up messages? A. Automatic Updates B. Windows Firewall C. Antivirus Options D. Internet Options 47. Martin wants to set Windows to automatically check for the latest security patches released by Microsoft. Which security settings will he use to check for the latest security patches at periodic intervals? A. Internet Options B. Windows Firewall C. Automatic Updates D. Antivirus Updates 48. Bill wants to understand the purpose of Windows Firewall. Which of the following options states the purpose of Windows Firewall? A. Installs security patches. B. Restricts unauthorized access. C. Blocks pop-up messages. D. Blocks Web sites. 49. Jim wants to block a Web site. Which of the following Internet Properties tabs will he use to do this? A. Security B. Content C. Privacy D. Connections Lesson 5: Computer Ethics Objective 5.1: Explain Intellectual Property and copyright as they apply to computing. 50. While reading a novel, you realize that the author has copied material from another author. How will you categorize this violation? A. Phishing B. Plagiarism C. Libel D. Slander Objective 5.2: Identify the various acts of copyright violation and measures to prevent those acts. 51. Monica recently heard about copyright. She wants to know what actions violate copyright. Which one of the following actions is a copyright violation? A. Sharing a Web site address B. Reading material from a publicly available Web site C. Copying software and distributing it to your friends D. Quoting a paragraph and mentioning the source 52. Ken decides to download the latest song from his favorite band from a publicly available Web site and share it with his friends. What is Ken doing? A. Breaching copyright B. Breaching security C. Slandering the singer D. Violating privacy Objective 5.3: Identify the various legal concerns associated with information exchange. 53. For a project, Bill decides to use content from a Web site. However, he forgets to state the source. What has Bill done? A. Libel B. Plagiarism C. Gambling D. Defamation 54. Glenn notices that his colleague is making false statements about him in an online public forum. What is Glenn's colleague doing? A. Plagiarism B. Defamation C. Gambling D. Phishing Comments Anonymous You do not have permission to add comments. Sign in|Report Abuse|Print Page|Powered By Google Sites MS - Module 5 Microsoft Digital Literacy Module 5: Digital Lifestyles TECH LIT FINAL EXAM Lesson 1: The Digital Experience Objective 1.1: Describe the benefits of digital technology. 1. Nina works with Alpine Ski House, which has clients in various locations. She needs to conduct a live video conference to discuss a project report with a few clients who are in different countries. Which options in the following list does she need for a video conference? Select three. A. Printer B. Microphone C. Web cam D. Internet connection E. MP3 player F. Transistor radio 2. Your friend creates music for a musical event that you plan to host at your home. He sends the music to you on a CD. Which one of the following devices will you need to listen to the music on the CD? A. Analog camcorder B. Microphone C. Transistor radio D. CD player 3. Eric reads interesting information about MP3 players and wants to buy one. Which of the following tasks can he perform by using an MP3 player? A. Send e-mail messages B. Play music C. Capture movies D. Create graphics 4. You have an old camera that belonged to your great-grandfather. Now you purchase a digital camera. What features does your new camera offer that the old one does not offer? Select two. A. Can be connected to a computer to transfer pictures B. Can be connected to a photo printer to print pictures C. Uses film to store pictures D. Need to process the film 5. You are on a vacation and want to go sightseeing. You want to capture video of the places that you visit so that you can share the video with your friends when you return. Which of the following devices will you use? A. MP3 player B. DVD player C. Video game system D. Camcorder 6. Your friend does not like to travel frequently to conduct business conferences. He discovers that by using video conferencing, he can participate in business meetings and conferences without being physically present. He is curious to know more about video conferencing. Which of the following options will you identify as features of video conferencing? Select two. A. Allows participants to see each other B. Allows participants to talk to each other C. Uses speech synthesis to transmit audio among participants D. Requires the participants to be in the same country E. Can be conducted by using a stand-alone computer Objective 1.2: Explain how digital technology expands the features of media devices. 7. Nuno likes to play games and listen to music. He wants to purchase a portable multipurpose device that works as personal organizer and can be used to communicate with his friends and to play games and music. Which of the following devices offers all the functions that Nuno wants? A. Transistor radio B. Camcorder C. Smartphone D. Web cam 8. You like to chat with your friends over the Internet. Your friends want to see your live images when you are chatting with them online. Which of the following devices enables you to do this? A. Web cam B. DVD player C. CD player D. Video game system 9. You record a video of the wedding of your friend. Later, you want to transfer the video to the computer so that you can add titles and effects to the video. Which of the following devices will you use to record the video? A. MP3 player B. Scanner C. Video game system D. Camcorder 10. Monica purchases a personal digital assistant (PDA). She uses the PDA to organize her daily tasks. Which of the following tasks can she perform by using this device? Select two. A. Burn CDs B. Perform calculations C. Play CDs D. Scan pictures E. Store data 11. Roger is curious to know what a personal digital assistant (PDA) is. How will you describe a PDA to Roger? A. Handheld computer used as a personal organizer B. Hardware device used to scan pictures C. Software used to edit videos that are stored in a digital format D. Digital device used to burn CDs Lesson 2: Introduction to Digital Audio Objective 2.1: Identify the various characteristics of digital audio. 12. Your friend Leo travels to another town to attend his brother's musical recital. He records a part of the recital by using his portable cassette recorder. Leo wants to share the recording with you. You ask Leo to send you a copy of the recorded music by e-mail. Leo needs to save his music file in a different format to send it by e-mail. What can Leo save the audio file as? Select two. A. MP3 B. WMA C. DOCX D. GIF E. BMP 13. Christina is a computer teacher. She is teaching her students how computers record and play audio files. She needs to explain the process. Arrange the steps in the following list in the order in which computers record and play audio files. Steps: A. Sound in the analog form is converted to a digital form by software on the computer. B. The computer is connected to an analog sound source. C. The sound can be heard by using a speaker. D. When the audio is played, it is converted back to analog form. E. The computer stores the audio as a digital file. 14. Dan visits the Web site of Lucerne Publishing and hears a live poetry recital. Which one of the following technologies does the Web site use to transmit the poetry recital over the Internet? A. Streaming B. Sampling C. Speech recognition D. Speech synthesis 15. Fabricio connects his computer to the Internet. He wants to listen to music from an Internet radio station. He knows that audio files can be played before they are completely downloaded from the Internet radio station. Which of the following options will Fabricio use to listen to the Internet radio station? A. Streaming audio player B. Digital media converter C. Audio compression software D. Digital audio synthesizer 16. David is a guitarist. He uses a digital recorder to record a song played by his band. He sends the audio file to you by e-mail. David tells you that he has compressed the audio file. What is the benefit of compressing the audio file in this case? A. Reduces the file size. B. Enhances the quality. C. Adds special effects. D. Removes noise. Objective 2.2: Explain the concepts of recording, copying, and converting digital audio. 17. Rie records a song her daughter sings. She wants to know what she can do to the recording by using audio-editing software. Which of the following tasks can she perform by using audio-editing software? Select two. A. Host the audio file on the Internet for streaming. B. Change the format of the audio file. C. Compress the audio file to reduce file size. D. Send the audio file by e-mail. E. Transfer the audio file over the phone line. 18. Aldis is a song writer. He records his new song on his computer. He saves it on a CD in WAV format and gives the CD to you as a gift. You do not have a computer at home and want to listen to the music on your MP3 player. Therefore, you ask Aldis to save the music on a CD in MP3 format. Which of the following processes will Aldis follow to save the music in MP3 format? A. Recording B. Converting C. Audio streaming D. Speech synthesis 19. You order a new personal computer. A representative from the store calls to ask if you need CD-copying software in your personal computer. Which one of the following statements describes the purpose of CD-copying software? A. Records data on a recordable CD B. Scans images from a scanner C. Streams digital audio files from a CD D. Plays digital audio and video files from a CD 20. Oliver reads about audio streaming and wants to know more about its functions. Which of the following functions will help you explain audio streaming to Oliver? A. Copy an audio file from a CD and convert it to a different format. B. Listen to audio files without completely downloading them from the Internet. C. Communicate with the computer by using voice. D. Enhance the quality of audio files without downloading them from the Internet. Objective 2.3: Identify the features of speech technologies. Heidi uses her computer to write articles for a newspaper. She uses a program to listen to the articles before she submits them for printing. 21. Which technology enables a computer to convert the written text to audio? A. Speech recognition B. Speech synthesis C. Audio streaming D. Audio compression 22. Carol purchases a computer. She installs speech recognition software on the computer. Which of the following hardware devices will help her use the speech recognition software? A. Microphone B. DVD writer C. Audio amplifier D. CD player 23. You read in a magazine about computer software that supports speech recognition technology. Which of the following benefits will the speech recognition technology provide? A. Allow you to interact with the software through speech B. Make the computer speak to you C. Let your computer communicate with other computers by using speech D. Help your computer learn how to speak 24. Yury installs speech recognition software on his computer. He wants to know the tasks he can perform by using this software. Which of the following tasks will Yury be able to perform? Select two. A. Enter data into documents by using his voice B. Select menu, toolbar, and dialog box items by using his voice C. Listen to the text written in the documents D. Have a conversation with the computer E. Make the computer recognize whether an audio file contains a human voice 25. Susana has speech synthesis software installed on her computer. Which of the following devices does she need to use this software? Select two. A. Speaker B. Sound card C. Printer D. Web cam E. Uninterruptible power supply (UPS) 26. Rafal wants to know about speech synthesis technology and its uses. Which one of the following conversions does speech synthesis technology perform? A. Text to audio B. Audio to text C. Audio to video D. Analog to digital audio Lesson 3: Introduction to Digital Video Objective 3.1: Identify the characteristics of digital video. 27. Oliver learns that he can compress digital video. He wants to know the advantage of compressing digital video. Which one of the following options describes the advantage of compressing digital video? A. Reduces the file size B. Improves brightness C. Adds special effects D. Improves contrast Objective 3.2: Explain what digital video editing is and the various output formats for digital video. 28. Paulo records a video clip of his college on a magnetic tape. He wants to share it with you. Paulo needs to save the clip as a video file before sending it by e-mail. Which of the following formats can Paulo use to save the video file? Select two. A. WMV B. MPG C. DOCX D. BMP E. HTM 29. You saved a video clip of your vacation by the name MyTrip. Now you want to edit this video. Which of the following files will you open to edit the video? A. MyTrip.jpg B. MyTrip.wmv C. MyTrip.mp3 D. MyTrip.gif 30. While browsing the Internet, Karl reads about video streaming. He wants you to tell him more about it. What will you tell him about video streaming? A. Adds special effects to video files B. Converts video files from analog to digital format C. Displays video files on a network without downloading them D. Removes audio from media files 31. Andrea records a video clip of the setting sun. She asks you how video editing software can help her in modifying the clip. Which of the following tasks can she perform by using video editing software? Select three. A. Insert titles in the video. B. Compress the video file to reduce its size. C. Add background music to the video. D. Host the video file on the Internet for streaming. E. Send the video file by e-mail. F. Transfer the video file over the phone line. 32. You record a video clip of your visit to a tourist location. Your friend Henrik is unable to view the file by using the media player on his computer. Which of the following options can you use to enable Henrik to view the video clip on his computer? A. Converting B. Recording C. Streaming D. Mixing Objective 3.3: Identify the features of different Web video technologies. 33. You visit the Litware, Inc., Web site. The site has a link to a video that demonstrates how computers are assembled. You click the link to view the demonstration, and the clip starts playing immediately. Which of the following technologies does the Web site use to transmit the video clip over the Internet? A. Streaming B. Recording C. Converting D. Mixing 34. Peter is interested in watching an action movie released recently. He visits the movie Web site to watch a preview of the movie. Which one of the following options will enable Peter to view the video clip without downloading it completely? A. Streaming video player B. DVD player C. Portable MP3 player D. Videocassette player 35. Carlos is the chairperson of Blue Yonder Airlines. He schedules an interactive meeting with the company's regional sales managers, who are at remote geographical locations. In the meeting, he wants to deliver a presentation about the future challenges of the company and to discuss possible solutions. Which of the following digital technologies can he use to conduct this meeting? A. Video conferencing B. On-demand video streaming C. On-demand audio streaming D. E-mail 36. Susana returns from a vacation and discovers that there was a senior management meeting in her absence. The recording of the meeting is available on her company's intranet. Which of the following Web video technologies will allow Susana to view this recording? A. Real-time video streaming B. On-demand video streaming C. Web conferencing D. Voice over Internet Protocol (VoIP) 37. Patrik finds that a news Web site plans to cover a solar eclipse live. He visits the site and watches the solar eclipse live. Which of the following technologies enables Patrik to watch the event live? A. Real-time video streaming B. Voice over Internet Protocol (VoIP) C. On-demand video streaming D. Internet radio Lesson 4: Introduction to Digital Photography Objective 4.1: Explain the benefits, features, and working of a digital camera. 38. Your friend Julia wants to know where a digital camera stores its pictures. Which of the following options will you use to answer her query? A. Flash memory B. Film C. Tape D. Graphics card 39. Vanessa wants to know the benefits of a digital camera before buying it. Which of the following benefits are true for a digital camera? Select two. A. No film cost B. View photos without printing C. Browse the Web D. Scan pictures E. No power required 40. Your friend Monica wants to purchase a digital camera. She needs your help to describe the resolution of the camera to the sales person. Which one of the following terms will she use to describe picture resolution in digital cameras? A. Photo sites B. Pixels C. Bitmaps D. JPEG 41. Bob wants to understand the concept of resolution in a digital camera. He needs your help. Which of the following options will you use to define the term "resolution" to Bob? Select two. A. Clarity of a picture B. Sharpness of a picture C. Zoom of the camera D. Size of the lens E. Color of a picture 42. Janko sees a digital camera he likes. He asks you about the features of digital cameras. What will you tell him? Select two. A. Uses flash memory for storing photos B. Has a sensor for capturing photos C. Operates without a lens D. Has a built-in photocopier E. Uses dye sublimation for taking photos Objective 4.2: Explain how to edit and manage digital images. 43. Julia finds an old picture on her computer. She wants to remove the white borders from this picture. What will Julia do to edit the picture? A. Crop B. Resize C. Merge D. Sort 44. Bob sees an advertisement about photo editing software. He is eager to purchase the software. He contacts you and wants to know more about the features of the software before he purchases it. What features of photo editing software will you tell him about? Select three. A. Adds special effects B. Alters background of an image C. Adjusts brightness or contrast of an image D. Streams video and audio files on the Internet E. Transfers photos to film for storage F. Edits sound in an image Objective 4.3: Identify the features of different types of printers that are available for printing photos. 45. Julia uses a printer that sprays small color drops on the paper to print a picture. Which one of the following types of printers is Julia using? A. Inkjet B. Dye sublimation C. Laser D. Dot matrix Comments Anonymous You do not have permission to add comments.