Detailed Answers | ICDL Exam Cram 2

[ LiB ]


Question 1	Answers B, C, and D are correct. Information technology (IT) refers to the entire system of computers, including the hardware, software, and the networks that tie computers together. Answer A is incorrect because the user is not generally considered to be a part of the technology.

Question 2	Answer A is correct. Typically, mainframe computers cost millions of dollars. Answers B, C, and D are incorrect because these types of computers cost hundreds or thousands of dollars.

Question 3	Answers A and D are correct. The CPU is the "brain" of the computer, which performs calculations and controls the logic of all programs running on the computer. Answer B is incorrect because devices such as hard drives and CD-ROMs are used for storing large amounts of data. Answer C is incorrect because input is handled by input devices such as keyboards and mice.

Question 4	Answer A is correct. One page of text is about 5KB in size, so several pages will be perhaps 30KB. Answers B, C, and D are incorrect because they are all much larger units of storage.

Question 5	Answers A and C are correct. Monitors and printers are designed to take information from the computer to you, so they are output devices. Answers B and D are incorrect because mice and trackballs take information from you to the computer; they are input devices.

Question 6	Answer B is correct. An intranet application uses a network entirely contained within a single company. Answer A, sending email, is an example of an Internet application. Answer C, which uses the large network that connects everyone, is also an Internet application. Answer D, using a private network with business partners , is an example of an extranet application.

Question 7	Answer D is correct. Answer A is incorrect because words in the dictionary are usually not accepted as good passwords. Answer B is incorrect because good passwords should be at least seven characters long. Answer C is incorrect because it is too short and because it contains only numerals. Only Answer D is long enough, is not a real word, and contains a good mix of characters .

Question 8	Answers A, B, and C are correct. Viruses can be transmitted in all sorts of software, whether that software is stored on a diskette, downloaded as email, or viewed as a Web page. Answer D is incorrect because hardware such as keyboards do not harbor computer viruses.

Question 9	Answer C is correct. Placing the computer in standby mode reduces its power consumption but keeps the contents of memory intact. Answers A, B, and D are incorrect because rebooting or turning off the computer erases all information in the computer's memory.

Question 10	Answer A is correct. The title bar is at the top of each window, and it displays the name of the current application or document. Answer B is incorrect because you use the scrollbar to move the contents of the window up and down. Answer C is incorrect because the menu bar contains the application's menus . Answer D is incorrect because the toolbar contains the application's toolbar buttons . Answer E is incorrect because the status bar, at the bottom of the window, contains information about the application but not its name.

Question 11	Answers A and B are correct. Folders can store files or other folders. Answer C is incorrect because open windows are not stored; they are just displayed on your desktop. Answer D is incorrect because display settings are stored outside of the file system and managed by Windows itself.

Question 12	Answer C is correct. When you hold down the Ctrl key and click, Explorer keeps your previous selection and adds the new file to the selection. Answers A and B are incorrect because in each case only the last file clicked will be selected. Answer D is incorrect because holding Shift while you click selects all files between the original click and the current click, which in this case would include `B.txt` .

Question 13	Answers A and C are correct. The Search tool in Windows lets you find files by name or size, as well as some other ways. Answers B and D are incorrect because the Search tool does not offer those options.

Question 14	Answer D is correct. Disinfecting the file removes the virus while retaining your critical information. Answer A is incorrect because deleting the file loses the information inside of the file. Answer B is incorrect because scanning the file only tells you that it contains a virus; it doesn't do anything about the problem. Answer C is incorrect because compressing a file does nothing to remove viruses.

Question 15	Answer C is correct. Before the computer will recognize your printer, you must install the proper printer drivers. Answers A, B, and D are incorrect because the printer itself is unlikely to be the problem.

Question 16	Answers B and C are correct. The print manager lets you pause, cancel, and restart print jobs. Answers A and D are incorrect because the print manager does not let you repeat or alter print jobs.

Question 17	Answer A is correct. Word can save documents to a variety of text formats, including `.txt` , `.rtf` , and `.doc` . Answers B, C, and D are incorrect because Word cannot convert documents into the native formats used by the other Office applications.

Question 18	Answer C is correct. To enter new text in Word, just click where you want the text and start typing. Answer A is incorrect because clicking the Insert key sets Word to overwrite mode, and the new text overwrites existing text. Answer B is incorrect because it is more work than is required. Answer D is incorrect because highlighting the existing text causes the new text to replace the existing text.

Question 19	Answer A is correct. Word's Undo facility lets you reverse any changes to the document so you can recover from mistakes. Answer B is incorrect because closing and reopening the document loses any other changes that were made since the most recent save operation. Answers C and D are incorrect because deleting the new text does not restore the existing text.

Question 20	Answer D is correct. The Format Painter provides an easy way to transfer all formatting in a single operation. Answers A and B are incorrect because it takes more work to recreate a format than it does to copy formatting. Answer C is incorrect because this procedure doesn't format existing text.

Question 21	Answer A is correct. Shift+Enter inserts a soft carriage return in a Microsoft Word document. Answer B is incorrect because Ctrl+Break interrupts a running program. Answer C is incorrect because Ctrl+Alt+Del reboots your computer. Answer D is incorrect because Alt+Enter deletes the current line.

Question 22	Answers C and D are correct. The Page Setup dialog box lets you change the document orientation and paper size. Answers A and B are incorrect because to change which pages are printed or the number of copies to print, you must use the Print dialog box.

Question 23	Answer B is correct. Text in the header of the document is printed at the top of each page. Answer A is incorrect because it would take a lot of extra work. Answer C is incorrect because footer text appears at the bottom of each page. Answer D is incorrect because it would take a lot of extra work.

Question 24	Answer C is correct. Adding the company name to the dictionary helps you make sure that it is spelled consistently in the future and keeps Spell Check from flagging it as a misspelled word. Answers A and B are incorrect because ignoring the spelling just leaves it to be flagged the next time you run Spell Check. Answer D is incorrect because canceling Spell Check leaves the rest of the document unchecked.

Question 25	Answer C is correct. The Freeze command freezes rows, columns , or both so that they are not affected by scrolling. Answers A and B are incorrect because Freeze does not prevent you from editing data. Answer D is incorrect because the Freeze command does not affect the worksheet's color scheme.

Question 26	Answer A is correct. The single quote tells Excel that you are entering a literal value rather than a formula. Answers B, C, and D are incorrect because they are treated as invalid formulas rather than as literal text.

Question 27	Answers B and C are correct. These actions select the entire worksheet. Answers A and D are incorrect because these actions do not select the entire worksheet.

Question 28	Answer D is correct. The formula `=A1+A2` makes the cell stay equal to the sum of the other two cells no matter what is entered in those cells. Answer A is incorrect because Excel does not update the literal value 9 if one of the other cells changes. Answers B and C are incorrect because they do not start with the = sign, so Excel will not recognize them as formulas.

Question 29	Answer D is correct. Excel displays `#####` if the data is too wide to display. Answer A is incorrect because Excel displays `#DIV/0!` if you attempt to divide by zero. Answer B is incorrect because Excel displays `#NAME?` if a cell reference is invalid. Answer C is incorrect because Excel displays `#VALUE!` if you attempt to put invalid values into a formula.

Question 30	Answer D is correct. The dollar signs before both the row and column references convert them into absolute references. Answers A, B, and C are incorrect because they use relative column references, relative row references, or both.

Question 31	Answer B is correct. To specify a rectangular range, you specify the upper-left and lower-right corners of the range, separated by a colon . Answers A, C, and D are incorrect because those references are not syntactically valid.

Question 32	Answer C is correct. Clicking the Decrease Decimal button changes the display of the cell but does not affect the value stored in the cell, so Answers A, B, and D are incorrect.

Question 33	Answer A is correct. The primary key is the field or combination of fields that is used to identify records in a table. Answers B, C, and D are incorrect because those are not definitions of the term primary key .

Question 34	Answers B and C are correct. You can undo data changes in Access with the Undo toolbar button. Answers A and D are incorrect because you can't undo table creation or deletion.

Question 35	Answer C is correct. When you convert a Text field to a Number field, Access converts as much of the textual data to numbers as it can. Answer A is incorrect because Access doesn't try to do anything with letters, even if they spell the name of a number. Answer B is incorrect because you can't store letters in a Number field. Answer D is incorrect because Access does not stop the conversion at the first error.

Question 36	Answer B is correct. A query lets you retrieve a smaller set of records from a table according to some criteria. Answer A is incorrect because the table itself holds all the data. Answers C and D are incorrect because forms and reports can be based on queries but do not themselves apply criteria to the data.

Question 37	Answers A, B, and C are correct. You can view and edit data in a table or query datasheet or in an open form. Answer D is incorrect because you cannot edit data in a report.

Question 38	Answer B is correct. Using `>=` causes the query to include records that are greater than or equal to the specified number. Answer A is incorrect because it only retrieves records where the salary is exactly 40000. Answer C is incorrect because it retrieves records that exceed 40000 but not those where the salary is exactly 40000. Answer D is incorrect because it retrieves records where the salary is less than 40000.

Question 39	Answers A and B are correct. Tables and queries are objects that contain data, and this data can be used in forms and reports. Answers C and D are incorrect because forms and reports do not have data of their own and so cannot be used as a data source.

Question 40	Answers B and D are correct. You can display summary information by creating a totals query or by adding a group to a report. Answer A is incorrect because tables don't display summaries. Answer C is incorrect because forms display all records or a single record but no summaries.

Question 41	Answers A and D are correct. You can use the Zoom menu item, or Ctrl+wheel, to change the zoom factor in PowerPoint. Answers B and C are incorrect because those actions do not change the zoom factor.

Question 42	Answers A and C are correct. PowerPoint notes are visible in Normal view and Outline view. Answers B and D are incorrect because notes are hidden in Slide Sorter view and Slide view.

Question 43	Answer C is correct. When you create a slide footer, you can specify to include the slide number automatically on each slide. Answer A is incorrect because text on the master slide appears unchanged on every slide in the presentation. Answer B is incorrect because you can't insert text in the design template. Answer D is incorrect because this technique doesn't automatically renumber slides if you rearrange your presentation.

Question 44	Answer B is correct. You can copy PowerPoint objects such as charts and images from one presentation and paste them into another presentation. Answers A and D are incorrect because they require extra work. Answer C is incorrect because you cannot save an entire presentation as a single JPG file.

Question 45	Answer B is correct. Transitions control the effect when you leave one slide to show another slide. Answer C is incorrect because animations happen on a single slide, not between slides. Answers A and D are incorrect because the master slide and design template are static, not animated.

Question 46	Answer A is correct. By hiding selected slides, you can make sure that the other slides remain identical even if you continue to edit the presentation. Answers B and C are incorrect because they result in a second copy of the presentation that can get "out of sync" with the first copy. Answer D is incorrect because a printout isn't a presentation.

Question 47	Answer D is correct. The icon with the slash indicates that the slide is currently hidden. Answers A and B are incorrect because transitions and animations are indicated with other icons. Answer C is incorrect because deleted slides are not displayed in Slide Sorter view.

Question 48	Answer B is correct. Outline view lets you edit many slides quickly by working in the outline. Answer A is incorrect because Slide view is geared towards working with a single slide. Answer C is incorrect because Slide Sorter view shows you slides but does not let you edit them. Answer D is incorrect because you cannot edit slides when in Slide Show view.

Question 49	Answer B is correct. The History panel gives you an easy way to revisit recently visited pages. Answer A is incorrect because there's no easy way for you to look in the browser's cache. Answer C is incorrect because you didn't bookmark the site. Answer D is incorrect because there's no need to search for the site when it's sitting in your history.

Question 50	Answer C is correct. Flagging a message provides a visual cue to remind you to review the message later. Answers A, B, and D are incorrect because these actions don't do anything to make the message stand out from other messages.

Question 51	Answer A is correct. An unexpected attachment from an unrecognized recipient might be a computer virus. The safest thing to do is simply delete the message and the attachment. Answers B, C, and D are incorrect because these actions could trigger a computer virus if one is present.

Question 52	Answer C is correct. The bcc: box allows you to send a copy of a message without the original recipient knowing that the copy has been sent. Answers A and B are incorrect because they result in the customer knowing that you sent the copy. Answer D is incorrect because it's easier to use the bcc: box.

Question 53	Answer C is correct. Saving an address in your email address book makes it easy to address new mail to that recipient. Answers A, B, and D are incorrect because if you save the address anywhere else you need to retype it every time you want to send a message.

Question 54	Answer B is correct. A URL is an address for a Web page or other resource on the Internet. Answers A, C, and D are incorrect because those are not definitions of a URL.

Question 55	Answers B and C are correct. A secured Web site will use the `https ://` address format and will display a lock in the Internet Explorer toolbar. Answer A is incorrect because `http://` is used for regular, unsecured Web sites. Answer D is incorrect because any Web site can use any background color.

Question 56	Answer C is correct. The Favorites list gives you a way to quickly jump to favorite Web sites from your browser. Answer A is incorrect because the saved copy is never updated. Answer B is incorrect because sites vanish from the history after a fixed time. Answer D is incorrect because it's easier to choose from the Favorites list than it is to cut and paste the address from a file.

[ LiB ]