| Question 1 | Which of the following items is solely hardware? -
A. A 17-inch flat monitor -
B. The Windows XP operating system -
C. Your new personal digital assistant (PDA) -
D. The printer driver that controls your printer |
| Question 2 | Which functions is your computer's central processing unit (CPU) responsible for controlling and manipulating? -
A. Performing calculations -
B. Controlling logic flow -
C. Coordinating functions between peripherals and software -
D. Analyzing data |
| Question 3 | Which of the following computer types are you most likely to use while at home? -
A. Mainframe -
B. Personal computer -
C. Laptop -
D. PDA |
| Question 4 | Which of the following technologies are examples of a computer network? -
A. The Internet -
B. Your company's intranet -
C. Your personal computer -
D. Your bank's new online banking service |
| Question 5 | You need a new password to protect your home system. Which of the following is a good password? |
| Question 6 | Which of the following are valid and efficient uses of computers in everyday life? -
A. A medical diagnosis -
B. Booking a plane ticket -
C. Using a personal and automated checkout register to pay for items after shopping -
D. Taping your favorite TV show while you're out |
| Question 7 | Identify the items you should consider when putting together the most ergonomically correct workstation: -
A. An adjustable chair that you can adjust for height and lumbar support. -
B. A brisk air conditioning unit that keeps each office cold so the occupants remain alert. -
C. Place the monitor directly in front of the user . -
D. Bright lights. |
| Question 8 | Copyright laws are applicable to data on your system and information you glean from the Internet. Which of the following activities is legal? -
A. Downloading copyrighted music to a CD-ROM and listening later at your leisure -
B. Forwarding copyrighted material that gives you permission to forward or share the material within certain guidelines -
C. Installing your next -door neighbor's software so you can evaluate ityou might decide to purchase it yourself later -
D. Installing your work- related software at home |
| Question 9 | Choose the fastest removable data storage from the following list: -
A. Zip disk -
B. Hard drive -
C. Diskette -
D. CD-ROM |
| Question 10 | How can you protect your system from the destruction and annoyance caused by a virus? -
A. Run regular system scans that search for hidden virus files. -
B. Don't open an email attachment if you aren't expecting it or don't know the sender. -
C. Don't use diskettes or Zip disks from unknown sources. -
D. Install a firewall. -
E. Install special virus-scanning software that can find and deal with virus files. |
| Question 11 | An application has stopped responding. What do you do? -
A. Press Ctrl+Alt+Del and then choose Restart from the Shut Down menu. -
B. Choose Turn Off Computer from the Start menu. -
C. Turn off the system at the switch. -
D. Unplug the system to dump everything in the current memory and then plug it back in. |
| Question 12 | How can you learn important information about a system, such as the amount of RAM and the operating system? -
A. Choose My Computer from the Start menu, and then choose About from the Help menu. -
B. Look it up in the Help topics. -
C. Open the Windows Explorer and then choose About from the Help menu. -
D. Choose Control Panel from the Start menu and then click the System link. |
| Question 13 | From the Windows XP Control Panel window, you can find links to complete which of the following tasks ? -
A. Adjust the system's date and time settings. -
B. Launch the Help window. -
C. Turn off the computer. -
D. Install new software and hardware. -
E. Launch your most-often used files. |
| Question 14 | What's the quickest way to find Help for using Windows XP? -
A. Click Help on the taskbar. -
B. Press Ctrl+H. -
C. Choose Help and Support from the Start menu. -
D. Double-click the Help icon on the current toolbar or the Windows Explorer toolbar. |
| Question 15 | What three methods will copy text to the Clipboard? -
A. Select the text and click the Copy button on the toolbar. -
B. Press Ctrl+C and then select the appropriate text and press Enter. -
C. Highlight the text and then select Copy from the Edit menu. -
D. Choose Copy from the Edit menu, select the text, and then click OK. -
E. Select the text, and press Ctrl+C. |
| Question 16 | What Windows tool can you use to view, locate, copy, and move files stored on your system? -
A. The Control Panel -
B. My Computer -
C. The Windows Explorer -
D. Help and Support |
| Question 17 | Which of the following will open a new blank document in Word? |
| Question 18 | Which of the following statements about duplicating and moving text in a Word document are true? -
A. To copy text, select the text, press Ctrl+X, position the cursor where you want to paste the text, and press Ctrl+V. -
B. You can't copy or move text from one document to another. -
C. To copy text, select the text, press Ctrl+C, position the cursor where you want to paste the text, and press Ctrl+V. -
D. To move text, select the text, press Ctrl+X, position the cursor where you want to paste the text, and press Ctrl+V. |
| Question 19 | Identify the different methods for switching between multiple Word documents: -
A. Choose a file from the Window menu. -
B. Select a file from the File menu. -
C. Click the appropriate file-representing icon on the Windows Taskbar. -
D. Press Alt+Tab to cycle through the open documents. |
| Question 20 | To change your entire document from single to double space, you'd do which of the following? -
A. Select the entire document, choose Paragraph from the Format menu, and select Double from the Line Spacing control on the Indents and Spacing tab. -
B. Press Ctrl+2. -
C. Choose Paragraph from the Format menu and select Double from the Line Spacing control on the Indents and Spacing tab. -
D. Select the entire document by holding down the Ctrl key and clicking the document's left margin and then pressing Ctrl+2. |
| Question 21 | Each of the following statements denotes a formatting level for a particular formatting task. Which statements are true? -
A. Specifying subscript or superscript is done at the text or font level. -
B. Line spacing is done at the paragraph level. -
C. Lead spacing or leading is done at the paragraph level. -
D. Change page margins at the paragraph level. |
| Question 22 | Which of the following processes will insert a table of three columns and four rows? -
A. Click Insert Table, drag across three columns and four rows, and then press Enter. -
B. Choose Table from the Insert menu; enter 3, 4; and click OK. -
C. Choose Insert from the Table menu, choose Table, and then enter 3 in the Number of Columns control and 4 in the Number of Rows control. -
D. Select properly formatted text (tabs between each column), select the Table menu, choose Insert, and then click Table. |
| Question 23 | To change the size of an inserted picture object, do the following: -
A. Select the picture object, choose Resize from the Edit menu, and click the percentage option by which you want to increase the object's size. -
B. Click the picture object to select it and then drag any of the selection handles to adjust the object's size. -
C. Simply drag any border until the picture object is the desired size. -
D. Click the picture object, and choose Resize from the Format menu. |
| Question 24 | In a mail merge operation, the mailing list document might consist of the following: -
A. Customer names and addresses for a mass mailing -
B. Employee names and departments for routing a memo -
C. A class schedule -
D. List of meeting attendees for name tags |
| Question 25 | The spreadsheet data you're viewing extends past the right and bottom edges, and it's impossible to view the column and row headings and the data at the same time. What do you do? -
A. Change the Zoom value until you can see both the headings and the data you're working with. -
B. Freeze the worksheet by clicking in the cell just below and to the right of the headings. Then, select Freeze Panes from the Window menu. Doing so keeps the headings visible while you scroll to any area of the worksheet. -
C. Split the worksheet vertically or horizontally so you can see the headings in one pane and the data in another. -
D. Choose Split Screen from the View menu. |
| Question 26 | By default, what does Excel display if you enter the value 123.456 in any cell? -
A. 123.456 -
B. 123.00 -
C. 123 -
D. 123.46 |
| Question 27 | What's the quickest way to delete a row from the current worksheet? -
A. Click anywhere in the row, select Delete from the Edit menu, click the Entire Row option, and click OK. -
B. Click anywhere in the row and press the Delete key. -
C. Right-click on the row header and select Delete. -
D. Select the row header and choose Delete from the Edit menu. |
| Question 28 | To fill a range of columns with the same value, you'd do the following: -
A. Type the value, select the range, and then press Enter. -
B. Type the value, and pull down the Fill handle to select the remaining cells in the range. -
C. Select the range, type the entry, and then press Enter. -
D. Select the range, type the value, and press Ctrl+Enter. |
| Question 29 | Cells A1:A4 contain values you want to average. Which of the following formulas or functions might you use? -
A. =(+A1+A2+A3+A4)/4 -
B. =AVERAGE(A1:A4) -
C. =A1+A2+A3+A4/4 -
D. (A1+A2+A3+A4)/4 |
| Question 30 | You enter a value into a cell, but Excel displays ##### . What's wrong and how do you solve the problem? -
A. Excel can't resolve the cell references. Usually, it means there's a typo in the formula; find and correct the mistake. -
B. There's no data in one of the referenced cells. Find the empty cell and enter an appropriate value. -
C. The value is too wide to display. Make the column wider to accommodate the entire value. -
D. A value isn't available. Most likely, you've omitted a function's argument; find the missing argument and enter an appropriate value. |
| Question 31 | The simple formula in cell A5, =SUM(A$1:A$4) , copied to cell B6 results in the following formula: -
A. =SUM(A$1:A$4) -
B. =SUM(B$1:B$4) -
C. =SUM(B1:B4) -
D. =SUM(B$2:B$5) |
| Question 32 | Suppose the current worksheet displays a pie chart, but you need a column chart. Which of the following actions changes the pie chart to a column chart? -
A. Select the pie chart and choose Column from the Chart menu. -
B. Right-click the chart, select Chart Type, and select the appropriate column option. -
C. Right-click the chart and select Column. -
D. Right-click the chart, select Modify, click the Chart Type tab, and click Column. |
| Question 33 | Which of the following comments about database technology is false? -
A. A relational database is a collection of persistent data that's stored in multiple but related tables. -
B. Tables are usually related on a primary key/foreign key field. -
C. A relationship is an association between two tables. -
D. A primary key stores unique values, but null values are allowed if necessary. |
| Question 34 | An Access database can contain a number of objects. The following list matches some of these objects to their purpose. Which list is the most accurate for all the listed objects? -
A. Tables display data, queries limit data, forms interact with the user, and reports create a hard copy of the data. -
B. Tables store data, queries display data in answer to your questions, and forms allow you to view and modify data. Reports display data in meaningful groups and order. -
C. Tables store data, queries display data, forms interact with data, and reports print data. -
D. Tables temporarily hold data, queries ask questions, forms display data, and reports allow you to print data. |
| Question 35 | Which of the following sets of instructions isn't a valid method for creating a new table? -
A. Choose Table from the Insert menu, and choose Datasheet View in the New Table dialog box. -
B. Click the Tables shortcut on the Objects bar and then click New. -
C. Click the Tables shortcut on the Objects bar and then double-click the Create Table in Design View shortcut in the Database window. -
D. Click the Tables shortcut on the Objects bar and then double-click the Create Table by Using Wizard shortcut in the Database window. |
| Question 36 | A primary key field's main purpose is to uniquely identify each record. How do you set a primary key? -
A. Open the table in design view and choose Primary Key from the Edit menu. -
B. Open the table in view mode, select the field or fields that you want to be the primary key, and select Primary Key from the Edit menu. -
C. Open the table in design view, select the field or fields you want to be the primary key, and then click the Primary Key button the toolbar. -
D. Open the table in design view, select the field or fields you want to be the primary key, right-click the selection, and choose Primary Key. |
| Question 37 | Relationships enable Access to pull together related data. How do you create a relationship between two tables? -
A. In query design, choose Insert Relationship from the Insert menu. -
B. Open the Relationships grid, select the field in both tables, and click Create Relationship. -
C. Click the Relationships button on the Database toolbar to open the Relationships window. Add the two tables to the window if necessary. Then, drag the field by which you're relating the two tables from one table to the corresponding field in the second table. In the resulting dialog box, click Create. -
D. In the Relationships window, drag the join line from one table list to the other and then identify the field by which you're relating the two tables from the resulting field list. |
| Question 38 | You want to use a query to view only those customers who have made purchases since January 1, 2003. To do so, you'd use which of the following criteria expressions in the order date column? |
| Question 39 | You want to create a report that groups orders by their customers and sorts each order by the date the order was placed, within the context of each customer group . Which of the following will produce the desired results? -
A. Base the report on a query that groups and sorts the data appropriately. -
B. Sort the table in design view and save the layout. Then, base a report on that table and use the Grouping dialog box to create the group. -
C. Open the report in design view, click the appropriate section's title bar and choose Grouping from the Format menu. -
D. After basing the report on the appropriate table or query, open the report in design view and display the Sorting and Grouping dialog box to create the groups and sort the data. |
| Question 40 | Viewing data is much simpler if it's sorted in a meaningful way. Which of the following processes will sort data? -
A. Click the field by which you want to sort and then click Sort Ascending or Sort Descending on the toolbar. -
B. Open a table in design view, right-click the appropriate field, and choose Sort Ascending or Sort Descending. -
C. Click the field by which you want to sort, choose Sort from the Records menu, and then select Sort Ascending or Sort Descending from the resulting submenu. -
D. Click the field by which you want to sort, and choose Sort Ascending or Sort Descending from the Records menu. |
| Question 41 | When you want a visual overview for your entire PowerPoint presentation, which view do you choose? -
A. Notes -
B. Slide Show -
C. Slide Sorter -
D. Outline -
E. Slide |
| Question 42 | You want to apply certain design attributes consistently to all slides in your presentation. To do so, you'd do the following: -
A. Apply a Design template. -
B. Add a master slide to the presentation and add those attributes to the master slide. -
C. Add the attributes to each slide in the presentation. -
D. Add the attributes to the presentation's design slide. |
| Question 43 | Which of the following statements about using footers is false? -
A. Any text you add to a slide's footer appears on every slide in the presentation. -
B. Display the slide number in the slide's footer by clicking the Slide Number check box. -
C. To insert a date that updates automatically, check the Date and Time check box and then click the Update Automatically radio button. -
D. To add text just to the current slide's footer, select Header and Footer from the View menu. Then, select the Slide tab, enter the text, and click Apply. |
| Question 44 | To add an organizational chart to a presentation you'd use which of the following sets of actions? -
A. Select Chart from the Insert menu. -
B. Click the Insert Chart button. -
C. Choose Picture from the Insert menu and then choose Organization Chart. -
D. Choose Chart from the Insert menu and then choose Organization Chart. |
| Question 45 | The AutoShapes toolbar offers which of the following elements? -
A. Starbursts -
B. Arrow -
C. Lightning bolts -
D. Speech balloons |
| Question 46 | You want to change the style of a line element on a slide. How do you do so? -
A. Right-click the line, select Format AutoShape, and select the new style from the Line Style drop-down control. -
B. Select the line, and choose Line Style from the Format menu. Then, click the appropriate style. -
C. Right-click the line, choose Format from the resulting context menu, and then choose a new style from the Line Style section of the resulting dialog box. -
D. Select the line, Choose Line Style from the Format menu, and then click a new style from the resulting dialog box. |
| Question 47 | To control the way one slide flows into another, you'd define which of the following? -
A. Animation -
B. Special effects -
C. Transition -
D. Image animation |
| Question 48 | Which of the following statements about PowerPoint are true? -
A. You can print copies of the presentation as handouts. -
B. You must use a computer to view a PowerPoint presentation. -
C. Use the Notes section to help cue you during a presentation; only you can view notes in a presentation. -
D. Be careful when creating your presentation because you can't change the order of the slides once you create them. |
| Question 49 | Which of the following are properly formatted URLs? -
A. http://www.quepublishing.com -
B. harkins@rabbittracks.com -
C. www.quepublishing.com -
D. www.quepublishing.com.ICDL.html |
| Question 50 | Using a search engine, which of the following text entries would return links to only those documents that don't include the word " bugs ?" -
A. bunny -
B. bunny, rabbit -
C. bunny +bugs -
D. bunny -bugs |
| Question 51 | How do you know if a Web site is secured, which means you can trust it with you personal data? -
A. You look it up in an online secured site registry. -
B. When you sign in, the site displays a special dialog box assuring you that the site is secure. -
C. A secured site displays a small lock at the bottom of the screen. -
D. There's really no way to know for sure. |
| Question 52 | Which of the following most accurately defines a cookie, within the context of Web technology? -
A. A small reward, in the form of animation or some other small treat, displayed unexpectedly and without a request from you -
B. Mnemonic for a special type of security technology -
C. A small text file stored on your local system by a Web site -
D. A small window that's automatically displayed, usually for the purposes of advertising, when you access a Web site |
| Question 53 | Which of the following isn't an advantage of using email? |
| Question 54 | Someone has sent you an email with an attachment. How do you view the attachment? -
A. Choose Open from the File menu. -
B. Click the paper clip icon in the message header in the Preview pane and double-click the attached file. -
C. After ascertaining that the email has come from someone you know and that the attachment is virus free, you click the paper clip icon in the message header in the Preview pane and double-click the attached file. -
D. Choose Save Attachment from the File menu. |
| Question 55 | You want to add the email address from a recently received email to your Address Book. How do you do so? -
A. Open the email and double-click the From address. -
B. Click Reply to open the email and double-click the actual email address in the To control. -
C. Click Reply to open the email and double-click the To label to the left of the To (recipient) control. -
D. Use Ctrl+C to copy the email address and then open the Address Book and paste it in. |
| Question 56 | You want to add a new folder for storing email from friends. How can you add a new folder named Friends ? -
A. Right-click the folder to which you're adding the folder, choose New Folder, enter Friends and click OK. -
B. Choose New Folder from the Tools menu, select the folder to which you're adding the folder, enter Friends , and click OK. -
C. You can't add new folders, but you can rename an existing folder. -
D. Select Local Folders (or the folder to which you want to add the new folder as a subfolder) and choose New from the File menu. Then, select Folder, enter Friends , and click OK. |
