MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.

1) All of the following are considered to be personal computers (PCs) except:

A) microcomputers.

B) minicomputers.

C) notebook computers.

D) network computers.

2) The Internet is owned by:

A) the U.S. government.

B) an international consortium of universities.

C) a private business.

D) nobody.

3) A simple terminal includes hardware to support all of the following actions except:

A) storage.

B) connectivity.

C) input.

D) output.

4) The protocol describing standard rules for Internet communication is:

A) Web browser.

B) LAN.

C) ISP.

D) TCP/IP.

5) The piece of hardware that permanently holds data and programs is called:

A) primary storage.

B) secondary storage.

C) CPU.

D) output.

6) What is the main purpose of secondary storage devices?

A) executing computer instructions

B) temporary storage of data

C) output of information

D) permanent storage of data

7) The computing job that requires the least training and expertise is:

A) computer programmer.

B) systems librarian.

C) systems analyst.

D) data entry operator.

8) Which of the following people is responsible for ensuring that all the individual programs within a computer system are designed to work well together and effectively meet the users' needs?

A) Systems analyst

B) Computer programmer

C) Network manager

D) Computer operator

9) Another term for task-oriented software is:

A) productivity software.

B) packaged software.

C) provider software.

D) system software.

10) If coding, testing, and maintaining software is your primary interest, then you should be a:

A) computer programmer.

B) systems analyst.

C) data entry operator.

D) systems librarian.

11) A program that includes the opportunity for programmers to modify or enhance its code is called:

A) custom software.

B) open source.

C) public domain.

D) freeware.

12) Which version of Microsoft Windows is solely a GUI interface for interacting with MS-DOS?

A) Windows 3.1

B) Windows NT

C) Windows XP

D) Windows 95

13) Which of the following is a measure of the performance of a computer system?

A) Time slice

B) Interrupt time

C) Response time

D) Performance time

14) Which of the following types of software would not be considered to be system software?

A) operating system

B) program language translators

C) utility programs

D) spreadsheet software

15) If there are several programs on a single-CPU system, which is the most likely allocation decision that the operating system will make?

A) The program whose time slice has just expired will get the CPU.

B) The program whose read operation has just been completed will get the CPU.

C) All programs will get the CPU.

D) The program that has been waiting the longest in the queue will get the CPU.

16) The term used to describe the steps of fetching, decoding, executing, and storing the results of program instructions is:

A) instruction setting.

B) I-time.

C) processing.

D) machine cycle.

17) The following are all advantages of Unicode over ASCII except:

A) higher representational capacity.

B) space savings.

C) multilanguage support.

D) ability to handle all the world's alphabets.

18) Which of the following must the control unit refer to when decoding an instruction?

A) the instruction cache

B) the system clock

C) the address register

D) the instruction set

19) Which of the following is a volatile form of memory?

A) flash RAM

B) semiconductor RAM

C) RISC

D) programmable ROM

20) Which of the following is a nonimpact printer?

A) Active matrix printer

B) Dot-matrix printer

C) Ink-jet printer

D) Line printer

21) Which of the following pointing devices is located on the keyboard?

A) Pointing stick

B) Mouse

C) Trackball

D) Electronic pen

22) Which of the following includes a ball for helping position the arrow on the screen?

A) Joystick

B) Mechanical mouse

C) Optical mouse

D) Touchpad

23) Which of the following is the correct largest-to-smallest sequence of storage units?

A) Character  record  field  database  file

B) Field  character  record  file  database

C) Character  field  record  file  database

D) Field  character  record  database  file

24) Which action involves positioning a read/write head over a track?

A) Head switch

B) Rotational delay

C) Seek

D) Data transfer

25) A coating of magnetic __________ enables disks to represent data in magnetic form.

A) Mylar

B) film

C) oxide

D) sulphur

26) A communications signal in the form of a continuous wave is:

A) modulation.

B) amplitude.

C) analog.

D) digital.

27) Which of the following types of modems use coaxial communications lines?

A) cellular

B) ISDN

C) DSL

D) cable

28) Altering the frequency of a carrier wave in an analog signal is often done for the purpose of:

A) nothing, analog signal frequencies cannot be altered.

B) demodulating the signal.

C) duplexing the carrier wave.

D) representing different bit values.

29) You will use Usenet to:

A) remotely log into a host computer via the Internet.

B) post and read newsgroup messages via the Internet.

C) upload or download files over the Internet.

D) send email attachments to other users over the Internet.

30) A Uniform Resource Locator is a(n):

A) software tool for locating hardware and software resources on the Internet.

B) method for locating computers via a search engine.

C) address of a particular host computer and perhaps a Web page.

D) address of the computer that contains the browser software.

31) Which of the following is a correct association between hardware device and action?

A) scanner - processing

B) keyboard - connectivity

C) CPU - data manipulation

D) CD-ROM - output

32) Which of the following is not a secondary storage device?

A) central processing unit

B) hard disk

C) CD-ROM

D) DVD-ROM

33) The person who writes a newsletter via a desktop publishing program in order to distribute it to all others in the organization is working in the role of a:

A) data entry operator.

B) computer programmer.

C) systems analyst.

D) end user.

34) A site license is a typical means of purchasing software for use by:

A) a small business owner.

B) a college student.

C) a large organization.

D) a home computer user.

35) Batch programs are most likely to run in the:

A) page table.

B) foreground.

C) background.

D) queue.

36) Which is the first version of Microsoft Windows that is a fully self-contained operating system?

A) Windows 3.1

B) Windows NT

C) Windows XP

D) Windows 95

37) The acronym CPU stands for:

A) Central Processing Unit.

B) Computer Processing Unit.

C) Central Programming Unit.

D) Computing Program Usage.

38) An ergonomic keyboard helps to prevent:

A) wrist injuries.

B) system errors.

C) input errors.

D) cord clutter.

39) A collection of adjacent sectors that are treated as a unit of storage by the operating system is a:

A) sector.

B) cluster.

C) track.

D) cylinder.

40) Connections between networks sharing the same communications protocol are accomplished via a:

A) bridge.

B) NIC.

C) gateway.

D) base station.

For the questions below, consider the following:

:http://www.prenhall.com.

41) Based on the string "http," what can you assume about the URL?

A) It is pointing to a location that will contain files to be downloaded.

B) It is pointing to a Web site containing pages that may include hyperlinks.

C) It is pointing to a location of a company's host computer.

D) It was found by using a search engine.

42) The set of instructions that tell a computer what to do is called a:

A) programmer.

B) system.

C) program.

D) instruction set.

43) If you wanted to calculate your budget and play what-if games based on different assumptions of income and expenditures, you would be most likely to use:

A) database management software.

B) spreadsheet software.

C) graphics software.

D) communications software.

44) The merging of Internet Explorer as a component of the Windows operating system began with:

A) Windows 2000.

B) Windows Me.

C) Windows 95.

D) Windows 98.

45) The system bus width is normally the same as a CPU's:

A) cycle speed.

B) cache size.

C) word size.

D) instruction set size.

46) Speech synthesis systems:

A) are capable of understanding and recognizing a human voice.

B) are more difficult to program than speech recognition systems.

C) generate voice output understandable by human listeners.

D) use programming rules to assist speechwriters come up with ideas.

47) Which is the correct statement regarding zone recording and traditional sectoring?

A) With traditional sectoring, a sector in an outer track takes more space than a sector in an inner track.

B) With zone recording, a sector in an outer track contains more data than a sector in an inner track.

C) With zone recording, a sector in an outer track takes more space than a sector in an inner track.

D) With traditional sectoring, a sector in an outer track contains less data than a sector in an inner track.

48) With __________ transmission, a large block of characters is sent in a single stream.

A) asynchronous B) full-duplex C) synchronous D) block-oriented

49) The term bricks-and-clicks refers to:

A) companies that do business exclusively on the Internet.

B) construction companies doing business on the Internet.

C) companies that combine traditional retail stores with Internet sales.

D) mail-order retailers doing business on the Internet.

50) Which of the following is not necessary in order to attain computer literacy?

A) expertise in computer programming

B) ability to interact with a computer

C) awareness of the importance of computers

D) knowledge of the basics of how computers work

Office

Page 1

1. The Open command:

a. Opens a new, blank document on the screen

b. Brings an existing document from disk into memory

c. Brings a document from disk into memory, then erases the document on disk

d. Returns the document in memory to disk and erases it from the screen

2. Which of the following keys deletes text to the right of the insertion point?

a. Backspace

b. Delete

c. Both Backspace and Delete

d. Neither Backspace nor Delete

3. Which of the following statements about the Undo command is false?

a. You are limited to undoing the five most recent commands

b. Undoing the fourth command will not affect the preceding three commands

c. The Undo command is on the Tools menu

d. All of these answers are correct

4. A right tab with a dot leader is most useful for:

a. The page number included in a header

b. The page number in a table of contents

c. A column of numerical data

d. The first line indent in a paragraph

5. You have placed a Clip Art image in your document and want to size it differently. How would you do this while preserving the original proportions of the image?

a. Click and drag on the sizing handle on the top of the object

b. Click and drag on the sizing handle on the bottom of the object

c. Click and drag on the sizing handle at one of the corners of the object

d. It is not possible to size an object in a document

6. Which of the following menus would you use to enter an accented letter such as the š in ršsumš into a document?

a. Format

b. Tools

c. Insert

d. Edit

Page 2

7. This feature not only corrects mistakes as you type by substituting one character string for another, but it will also substitute symbols for typewritten equivalents. What is this feature called?

a. Autoformat feature

b. AutoCorrect feature

c. Grammar checker

d. Spelling checker

8. The Insert Footnote command:

a. Inserts a note into a document

b. Automatically assigns the next sequential number to the note

c. Positions you at the footnote or endnote where you enter the reference information

d. All of these answers are correct

9. Which part of the formula =B9/4+(C6*D7) is considered a constant?

a. B9

b. 4

c. C6

d. D7

10. Which of the following commands will save the current workbook so that it is readable in Excel 95?

a. File New

b. Save

c. Save As and change file type to Excel 95

d. Open

11. Which command enables you to change the margins and/or orientation for a printed worksheet?

a. Options

b. Page Setup

c. View

d. Edit

12. What happens if you press the Ctrl+ô key combination, given that the displayed values for each cell are shown in the worksheet?

a. The worksheet formulas are displayed

b. A new column is inserted in the worksheet

c. A new row is inserted in the worksheet

d. A duplicate worksheet is created in the workbook

Page 3

13. A worksheet currently displays the cell contents rather than the displayed (computed) values of each cell. Which keystroke combination will change the worksheet view from displaying the cell contents to the displayed values?

a. Ctrl+ô

b. Ctrl+F

c. Ctrl+DV

d. Alt+F

14. A cell at the intersection of the first row and third column has the cell reference:

a. A3

b. 3A

c. C1

d. 1C

15. In the formula =B5*B6+C3/D4^2, which expression will Excel evaluate first?

a. B5*B6

b. B6+C3

c. C3/D4

d. D4^2

16. Why is pointing preferable to typing the cell references into the cells?

a. It is more accurate

b. It is faster

c. It is faster and more accurate

d. Pointing is not preferable to typing the cell references

17. Which of the following will display a context-sensitive ("shortcut") menu?

a. Pointing to an object and clicking the right mouse button

b. Pointing to an object and clicking the left mouse button

c. Selecting Shortcut from the Tools menu

d. Selecting Shortcut from the View menu

18. What applies different formats to cells based on the value in the cell?

a. The Formatting toolbar

b. Conditional Formatting

c. The Format Painter

d. The Format Cells command

19. Which of the following is used to customize many aspects of Excel?

a. The Options command on the File menu

b. The Customize command on the Tools menu

c. The Options command on the Tools menu

d. The Customize command on the File menu

Page 4

20. Which is used to create a Web query?

a. The New Web query command

b. The Import External Data command

c. The Refresh Data command

d. The Insert Hyperlink command

21. Which of the following is used to insert a predefined computational task into a worksheet?

a. Copy and Paste Function commands

b. Insert Formula command

c. Insert Function command

d. Insert Hyperlink command

22. A worksheet template contains all of the following except:

a. Variable data

b. Row headings

c. Column headings

d. Formulas

23. What will be the contents of cell B7, given that cell B6 is copied to cell B7 and that cell B6 contains the function =PMT(A6/12, $C$2, -$C$1)?

a. =PMT(A7/12,$C$2, -$C$1)

b. =PMT(A6/12,$C$2, -$C$1)

c. =PMT(A7/12,C2, -C1)

d. All of these answers are correct

24. Columns A and B contain row headings, columns C through T contain the results of individual measurements you have taken, and columns U,V, and W contain summary and statistical information. What can you do to display and/or print only the row headings and the summary and statistical information?

a. Use the Hide Rows command

b. Use the Hide Columns command on rows C through T

c. Use the Hide Columns command on rows U,V, and W

d. It is not possible to do this

25. Which of the following options enables you to increase the number of columns that will be displayed on a printed worksheet?

a. Changing to landscape rather than portrait orientation

b. Increasing the horizontal margins

c. Freezing panes

d. All of these answers are correct

Page 5

26. An Access database you are working on contains a table, form, query, and report. How many files are needed to store these elements?

a. One

b. Two

c. Three

d. Four

27. Which of the following is an example of data validation?

a. Does not allow you to enter text in a date field

b. Does not allow you begin field names with a number

c. Automatically capitalizes the first letter of any words

d. Ensures that the numbers entered are within a predefined range

28. Which of the following is an advantage of a pivot table?

a. You can add or remove fields by dragging the field names on or off the table

b. You can switch the orientation (pivot the table) by dragging a field to or from the row, column, or filter area

c. You can change the means of calculation by changing the average value to sum, minimum, or maximum value

d. All of these are correct

29. Which of the following methods can you use to recreate an entire record you just deleted from an Access table?

a. Click the Undo button

b. Close the table without saving it and then reopen it; it will be in the same condition it was when you last opened it

c. Pull down the Edit menu and click Undo Current Field/Record

d. None of these are correct

30. Changes in the pivot table are:

a. Reflected automatically in the pivot chart

b. Not possible once you save the pivot table

c. Reflected in the underlying table automatically

d. All of these are correct