Detailed Answers

[ LiB ]

Question 1	Answer A is correct. Only the monitor is solely hardware. Answer B is incorrect because Windows XP is software. Answer C is incorrect because a PDA is both hardware and software. Answer D is incorrect; a printer driver is specialized software that allows your printer and your computer to communicate.
Question 2	Answers A, B, and C are correct. Your system's CPU is responsible for performing calculations, controlling the overall logic, and coordinating functions and instructions between your peripherals and software. Answer D is incorrect; analyzing data requires specialized software for just that purpose. The CPU is responsible for evaluating values within the context of mathematic operators, but the CPU doesn't know the specific formulas necessary to get the results.
Question 3	Answer B is correct. Most home users work on a personal computer connected to a monitor, printer, and sometimes a scanner. Answer A is incorrect because a mainframe is large and extremely expensive and completely incompatible to home use. Answer C is incorrect. Although you could use a laptop at home, most likely you use the laptop while away from home, for instance, retrieving email while traveling. Answer D is incorrect. Like the laptop, you could use a PDA at home, but doing so would be inconvenient if you had a personal computer available. The PDA is a convenient tool for those times when a personal computer isn't practical.
Question 4	Answers A, B, and D are correct. The Internet, your company's intranet, and most online services are all examples of computer networks. Answer C is incorrect. Unless a personal computer is connected to a network, it isn't part of a computer network.
Question 5	Answer C is correct because it consists of at least seven characters that include lowercase and uppercase letters , symbols, and numbers . Answers A and B are incorrect because you shouldn't use personal information that someone can easily guess. Answer D is incorrect because it's less than seven characters and contains only lowercase letters.
Question 6	Answers B and C are correct. You probably benefit from a computer when booking a flight or making purchases, even though you don't realize it. Answer A is incorrect as it requires a judgment and computers shouldn't be used in that capacity. Answer D is incorrect because although a lot of electronic devices use computerized components , they aren't computers.
Question 7	Answers A and C are correct. An adjustable and supportive chair and monitor placement are both critical to the user 's comfort . Answer B is incorrect because although fresh air and good ventilation are important, the temperature should be comfortable to the usernot necessarily cold. Answer D is incorrect because bright lights tend to create glare, which is bad for the user. Use adequate but not glaring lights.
Question 8	Answer B is correct and then only if you fully comply with the copyright instructions. Answer A is incorrect; downloading copyright music files is illegal. Answer C is incorrect. You can install only software for which you have purchased a legal license. Answer D is incorrect for the same reason as Answer C. The company owns your software license, not you.
Question 9	Answer D is correct. Currently, the CD-ROM is the fastest removable storage medium, while remaining relatively low in cost. Answer A is incorrect because the Zip disk isn't as fast as the CD-ROM. Answer B is incorrect because a hard drive isn't removable. Answer C is incorrect because the diskette is slower than the CD-ROM.
Question 10	Answers A through E are all correct. All these precautions help you protect your system, but they are best used together; one or even a few measures, taken alone, aren't adequate.
Question 11	Answer A is the correct answer. The only safe way to regain control of your CPU is to follow the instructions in Answer A. Answer B is incorrect because you can't access that option when an application has stopped responding. Answers C and D are both incorrect because they could cause damage to the software or corrupt data.
Question 12	Answers A and C are correct; view the Windows XP About information from the Help menu in either window. Answer B is incorrect although you could eventually find the information you're after if you happened upon the right topic. Answer D is incorrect because there is no such link. However, in the Control Panel window, you can find the information from the About command on the Help menu.
Question 13	Answers A, B, and D are correct. You can adjust system settings, find Help topics, and install new software and hardware from the Control Panel. Answer C is incorrect because there's no link for turning off the system from the Control Panel. Use the Start menu to turn off the system.
Question 14	Answer C is the only correct answer, although you can also launch Help from the Control Panel window. Answers A, B, and D are incorrect because the appropriate icon, keystroke combination, or tool doesn't exist.
Question 15	Answers A, C, and E are all valid methods for copying text to the Clipboard. Answer B is incorrect because you must select the text first. Answer D is incorrect because you must select the text first.
Question 16	Answer C is the only correct answer. Use Windows Explorer to navigate and manipulate the files on your local system. Answer A is incorrect because the Control Panel doesn't work with individual files. Answer B is incorrect because My Computer displays the system's many storage mediums, but not the files stored on each, and it has no Find tool. Answer D is incorrect because Help and Support provides a number of ways to find Help topics, but not your files.
Question 17	Answers A, B, C, and D are correct. All the responses open a new blank document.
Question 18	Answers C and D are correct because the statements are true. Pressing Ctrl+C copies the selected text and pressing Ctrl+X deletes the text and also copies it to the Clipboard. Answer A is incorrect because Ctrl+X removes the text from the current position before copying it to the Clipboard. Answer B is incorrect; you can copy and move text from one document to another.
Question 19	Answers A, C, and D are correct; all three switch to another open document. Answer B is incorrect; open documents are not listed on the File menu. Don't confuse the list of most recently opened documents with the currently opened documents.
Question 20	Answers A and D are correct. To change the line spacing, you must select the text where you want the spacing to change. Otherwise, Ctrl+2 simply inserts a single blank line, and the Line Spacing control only applies to the paragraph where the cursor is located.
Question 21	Answers A, B, and C are all correct because they're true. Answer D is incorrect because it's false; margins are changed at the document level. You can change the margins for selected text, or a paragraph, but not using the Top, Left, Right, and Left page margin settings.
Question 22	Answers A, C, and D are all correct; each of these methods creates a blank table of three columns and four rows. Answer B is incorrect because there is no Table option on the Insert menu.
Question 23	Answer B is the only correct answer. You must drag the selection handles to change the picture object's size. Answer A is incorrect because there is no Resize command on the Edit menu. Answer C is incorrect because you must drag the selection handles; dragging the borders won't work. Answer D is incorrect because there's no Resize command on the Format menu.
Question 24	Answers A, B, and D are correct. You might use a mail merge to produce a mass mailing, address an internal memo, or to even print name tags. Answer C is incorrect. Unless the scheduling document is uniquely formatted, it couldn't be used in a typical mail merge.
Question 25	Answer B is correct. You can freeze the top and left portions of the screen. The data remains synchronized with the headings above and to the left of the data as you scroll through the columns and rows to the right and below, respectively. Answer A is incorrect; you could zoom out of the worksheet, but chances are the data would become so small, you'd not be able to read it. Answer C is incorrect. Although you can split the screen and work with two areas of the worksheet, you can't synchronize your movements as efficiently as freezing the headings can. Answer D is incorrect because there's no such command on the View menu.
Question 26	Answer A is correct; by default Excel displays the value you enter using a General Number format. Answer B is incorrect; there's no format that automatically deletes the decimal values you enter and displays two zeros. You'd need a custom format for that. Answer C is incorrect. You'd need a number format set to 0 decimal places. Answer D is incorrect because Excel doesn't round unless you tell it to.
Question 27	Answer C is correct. Although there are many ways to delete a row, Answer C is the quickest. Answer A is incorrect even though it works; it requires more steps than the method listed in Answer C. Answer B is incorrect because that method describes how to delete the contents of a cell . Answer D is incorrect because it's incomplete (see Answer A). However, Answer D works in versions later than Excel 2000.
Question 28	Answers B and D are correct. Either method fills a range with the same value. Answer A is incorrect because you can't select a range until you finish the active entry. Answer C is incorrect because it enters the value only in the current cell, not the entire range.
Question 29	Answers A and B are both correct, although Answer B is superior to Answer A because you don't need to count the number of entries in the range of values. Answer C is incorrect because Excel divides only the value in cell A4 by the number of entries in the range. Answer D is incorrect because the equal sign is missing and Excel interprets the formula as text.
Question 30	Answer C is correct; the value you entered is too wide to display. You must increase the width of the column. Answer A is incorrect. When Excel can't resolve a cell reference, it displays the error value #NAME? . Answer B is incorrect; this mistake results in the #REF error value. Answer D is incorrect. You see the error value #N/A when you omit an argument.
Question 31	Answer B is correct. The dollar sign makes the row numbers absolute. Answer A is incorrect because the column references aren't absolute and reference the current column, which is B. Answer C is incorrect because the row values aren't preceded by the $ sign. Answer D is incorrect because the row values are absolutes and remain rows 1 and 4, regardless of where you copy the function.
Question 32	Answer B is correct. Answer A is incorrect because there's no such menu or command. Answer C is incorrect because there's no Column option. Answer D is incorrect because there's no Modify menu or Chart Type tab.
Question 33	Answer D is correct; it's the only false statement. A primary key value must be unique and can't be null. Answers, A, B, and C are incorrect because each statement is true.
Question 34	Answer B is correct; tables store data, queries display data in answer to your questions, forms allow you to view and modify data, and reports display data in meaningful groups and order. Answer A is incorrect; all the statements are true, but they aren't the most accurate description of the objects. Answer C is incorrect for the same reason. Answer D is incorrect because tables don't temporarily store data; data is permanently stored until you delete it.
Question 35	Answer B is correct because it's the only invalid set of instructions for creating a new table. You can only click Design if an existing table is selected. Answers A, C, and D are all incorrect because they all are valid instructions for creating a new table.
Question 36	Answers C and D are correct. You can use either method to set a table's primary key. Answer A is incorrect because there's no such command on the Edit menu. Answer B is incorrect because the table must be in design view and because there's no such command on the Edit menu.
Question 37	Answer C is correct because it's the only way to create a permanent relationship between two tables. Remember, the relationship doesn't have to be based on a primary/foreign key field. Answer A is incorrect because you don't define a permanent relationship in design view nor is there an Insert Relationship command on the Insert menu. Answer B is incorrect because there's no such window or grid known as the Relationships grid. Answer D is incorrect because you don't drag the join line from one list to another; you drag the actual field.
Question 38	Answer A is the most correct because it is the most efficient way to return records that were placed after January 1, 2003. Answer B is incorrect because it would return orders placed before January 1, 2003. Answer C is incorrect even though it returns the same recordset as A. It's incorrect because the AND Now() component isn't necessary. Answer D is incorrect because it returns only those records placed during 2003, and that isn't the same as all the records placed after January 1, 2003.
Question 39	Answers A and D are both correct. Either method sorts and groups a report. Not every group can be easily created at the query level, however, so you should keep that in mind. Answer B is incorrect because the table's layout would have to change from object to object, and that just wouldn't be practical. Answer C is incorrect because there's no such command from the Format menu and because you don't have to identify a section before applying a group .
Question 40	Answers A and C are both valid ways to sort data in a table, query, or form. Answer B is incorrect because you don't determine a table's sort order in design view. Answer D is incorrect because you must choose Sort from the Records menu and then one of the sort options.
Question 41	Answer C is correct. Slide Sorter gives you a visual overview of your entire presentation. Answer A is incorrect because Notes displays the printed note pages. Answer B is incorrect because Slide Show runs the actual presentation, one slide at a time. Answer D is incorrect because it displays the presentation's outline. Answer E is incorrect because Slide is where you edit individual slides.
Question 42	Answer B is correct. Elements on the master slide are included automatically in every slide in your presentation. Answer A is incorrect. You can apply a design template to a new presentation, but it might or might not include all the attributes you want to include. Answer C is incorrect even though it would work. You don't have to add each element to every slide. Answer D is incorrect because there is no such slide as the design slide.
Question 43	Answer A is correct because it's the only false statement. Simply adding text to the header or footer won't display the text on every slide. You must click the Apply All button to display the text on every slide. Answers B, C, and D are all incorrect because they're true statements about adding header or footer elements to slides.
Question 44	Answer C is correct; choose Organization Chart from the Picture command's submenu. Answers A and B are both incorrect because those instructions insert a chart. Answer D is incorrect because there is no Chart on the Insert menu; you must choose Picture.
Question 45	Answers A, C, and D are correct. The AutoShapes toolbar offers starbursts, lightning bolts, and speech balloons. Answer B is incorrect. You find the arrow element on the Drawing toolbar.
Question 46	Answer A is correct. Answer B is incorrect because there is no Line Style command on the Format menu. You must select AutoShapes from the Format menu. Answer C is incorrect because there is no Format option in the context menu; you must select Format AutoShapes. Answer D is incorrect because there is no Choose Line Style command on the Format menu.
Question 47	Answer C is correct. Transitions determine how one slide switches to the next . Answer A is incorrect because you can add animation to a slide, but you don't animate the transition between two slides. Answer B is incorrect because it's just one facet of transitions. Answer D is incorrect because it's specific to images, not what the viewer sees in between slides.
Question 48	Answers A and C are correct; both statements are true. Answer B is incorrect because it's false; you can produce slides from your presentation. Answer D is incorrect because you can move slides in Slide Sorter view.
Question 49	Answers A and C are both correct. Most modern browsers assume the http:// even if you omit it when entering the URL. Answer B is incorrect because it's an email address. Answer D is incorrect because the . character before ICDL.html should be a / character.
Question 50	Answer D is correct, most search browsers interpret the character before an entry as instructions to exclude documents that include that word or phrase. Answers A and B are both incorrect because they include documents that might or might not include the word "bugs." Answer C is incorrect because it displays only those documents that do contain the word " bugs ."
Question 51	Answer C is correct because the lock icon indicates that the Web site has been properly verified by a third-party resource. Answer A is incorrect because there is no such service. Answer B is incorrect. A site might display a message of that kind, but it isn't reliable. Answer D is incorrect; you can tell by the lock icon at the bottom of the screen.
Question 52	Answer C is correct; a cookie is a small text file stored by a Web site on your local system. Answers A and B are both incorrect because neither really exist within the context of a cookie. Answer D is incorrect because that definition describes what's known as a pop-up.
Question 53	Answer C is correct. Email and regular postal mail aren't connected, so you still have to go out into the rain to collect your regular mail. Answers A, B, and D are all incorrect because they're all advantages to using email to communicate in business or with family and friends .
Question 54	Answer C is correct. Answer A is incorrect because that opens the email, not the attachment. Answer B is incorrect. Even though it opens the attachment, you shouldn't open attachments until you know they're virus free. Answer D is incorrect because that saves, not opens, the attachment.
Question 55	Answers A and B are both correct; either way adds a new email address to the Address Book. Answer C is incorrect because clicking the To label opens the Address Book so you can select existing addresses. Answer D is incorrect; it works, but it's inefficient and unnecessary.
Question 56	Answers A and D are both correct. Answer B is incorrect because there isn't a New Folder command on the Tools menu. Answer C is incorrect because you can add new folders.

[ LiB ]