1. Which of the following IS NOT one of the four types of input?
1. data
2. programs
3. information
4. commands
2. A Dvorak keyboard ___________
1. is the standard keyboard used on almost all PCs
2. is also known as a QWERTY keyboard
3. has the most frequently used letters in the middle
4. is a wireless keyboard
3. An optical mouse __________.
1. has a rubber or metal ball on its underside
2. senses hand pressure through a soft, foam-rubber surface
3. uses devices that emit light to detect the mouse's movement
4. uses infrared or radio waves to communicate with a receiver
4. A cordless mouse __________.
1. has a rubber or metal ball on its underside
2. senses hand pressure through a soft, foam-rubber surface
3. uses devices that emit light to detect the mouse's movement
4. uses infrared or radio waves to communicate with a receiver
5. With a __________ scanner, the item to be scanned is placed on a glass surface under which the scanning mechanism passes.
1. flatbed
2. sheet-fed
3. drum
4. bitmap
6. To convert a scanned document into a text file that can be edited, it is necessary to have __________ software that works with the scanner.
1. optical character recognition (OCR)
2. optical mark recognition (OMR)
3. magnetic-ink character recognition (MICR)
4. image processing system recognition (IPSR)
7. __________ is used almost exclusively by the banking industry for check processing.
1. Optical character recognition (OCR)
2. Optical mark recognition (OMR)
3. Magnetic-ink character recognition (MICR)
4. Image processing system recognition (IPSR)
8. Which of the following IS NOT one of the four types of output?
1. text
2. data
3. graphics
4. video
9. The size of a monitor is measured __________.
1. vertically, from top to bottom
2. horizontally, from side to side
3. diagonally, from corner to corner
4. regionally, multiplying length by width
10. A screen with a 640 x 480 (pronounced 640 by 480) resolution can display __________.
1. 640 millimeters vertically and 480 millimeters horizontally
2. 640 columns and 480 rows of pixels
3. 480 millimeters vertically and 640 millimeters horizontally
4. 480 columns and 640 rows of pixels
11. A monitor with higher resolution displays a __________.
1. smaller number of pixels, which provides a rougher image
2. smaller number of pixels, which provides a smoother image
3. greater number of pixels, which provides a rougher image
4. greater number of pixels, which provides a smoother image
12. In a color monitor, three dots - __________ - are combined to make up each pixel.
1. one red, one yellow, and one blue
2. one red, one green, and one blue
3. one green, one blue, and one yellow
4. one yellow, one blue, and one green
13. All of the following typically are printed in landscape orientation except __________.
1. spreadsheets
2. slide shows
3. letters
4. graphics
14. The speed of a dot-matrix printer is measured by the number of __________ it can print.
1. characters per second (cps)
2. dots per inch (dpi)
3. pages per minute (ppm)
4. spots per centimeter (spc)
15. All of the following are types of nonimpact printers except __________ printers.
1. dot-matrix
2. ink-jet
3. laser
4. thermal
16. Because of their reasonable cost and letter-quality print, __________ printers have become the most popular type of color printers for use in the home.
1. dot-matrix
2. line
3. ink-jet
4. laser
17. Printer resolution is measured by the number of __________.
1. characters per second (cps)
2. dots per inch (dpi)
3. pages per minute (ppm)
4. spots per centimeter (spc)
18. To work with a saved file, the file must be removed from __________.
1. storage and placed in memory
2. memory and placed in storage
3. storage and placed in ROM
4. ROM and placed in storage
19. A typical floppy disk can store 1.44 __________ of data.
1. KB
2. MB
3. GB
4. TB
20. A typical hard disk can store 8 __________ of data.
1. KB
2. MB
3. GB
4. TB
21. The __________ is like a table of contents for a disk that contains a listing of all files, file types, and locations.
1. VHS
2. FAT
3. ATA
4. FDD
22. Because of the stacked arrangement of hard disk platters, the location of the read/write heads often is referred to by its __________ instead of its track.
1. sector
2. cluster
3. cylinder
4. partition
23. A compact disc stores items in __________ of the disc.
1. a single track that spirals from the center to the edge
2. multiple concentric tracks surrounding the center
3. evenly spaced, magnetic pits between the center and the edge
4. randomly spaced, magnetic pits between the center and the edge
24. A 16X CD-ROM drive has a data transfer rate of __________ KB per second.
1. 800 (16 x 50)
2. 1,600 (16 x 100)
3. 2,400 (16 x 150)
4. 3,200 (16 x 200)
25. __________ requires sequential access, which refers to reading or writing data consecutively.
1. Compact disc storage
2. Tape storage
3. Floppy disk storage
4. Hard disk storage
26. A __________ represents data as patterns of light reflecting off of a layer of yellow-green dyed material which cannot be erased and written on to again.
1. standard CD
2. Zip disk
3. CD-RW
4. CD-R
27. A __________ represents data as patterns of light reflecting off of "pits" and "lands" physically etched into the surface by the software manufacturer.
1. standard CD
2. Zip disk
3. CD-RW
4. CD-R
28. A __________ represents data as patterns of light reflecting off of a crystalline or "melted" crystalline surface.
1. standard CD
2. Zip disk
3. CD-RW
4. CD-R
29. The two types of system software are __________.
1. operating systems and utility programs
2. operating systems and application programs
3. information systems and utility programs
4. information systems and application programs
30. When working with a __________ operating system, such as Windows 95, it is not necessary to quit a word processing program to run a Web browser.
1. single user
2. multitasking
3. multiuser
4. multiprocessing
31. In the case of print spooling, the __________ holds the information waiting to print while the printer prints at its own rate.
1. buffer
2. kernel
3. driver
4. registry
32. A file manager performs all of the following file management functions except __________.
1. formatting and copying disks
2. displaying a list of files on a storage medium
3. checking the amount of used or free space on a storage medium
4. composing, editing, and formatting file contents
33. Because it is designed for use on smaller computing devices, __________ requires little memory.
1. Windows 3.0
2. Windows 3.11
3. Windows 98
4. Windows CE
34. The Mac OS is available only on computers manufactured by __________.
1. Apple
2. Microsoft
3. unix
4. IBM
35. Bell Labs licensed __________ for a low fee to numerous colleges and universities where it obtained a wide following and was implemented on many different types of computers.
1. DOS
2. UNIX
3. Linux
4. NetWare
36. Which is the correct order of operations for system startup?
1. power supply signal, BIOS POST test, OS kernel load, CMOS comparison
2. power supply signal, BIOS POST test, CMOS comparison, OS kernel load
3. power supply signal, OS kernel load, CMOS comparison, BIOS POST test
4. power supply signal, CMOS comparison, OS kernel load, BIOS POST test
37. The process of __________ - that is, organizing a disk so that files are stored in contiguous sectors - speeds up disk access.
1. destabilization
2. deconstruction
3. defragmentation
4. decentralization
38. The entire document created by using Excel 97 is called a(n)
1. worksheet.
2. notebook.
3. workbook.
4. Excel sheet.
39. In Excel 97 worksheets, rows are represented by
1. letters.
2. numbers.
3. windows.
4. cells.
40. In Excel 97 worksheets, columns are represented by
1. letters.
2. numbers.
3. windows.
4. cells.
41. The contents of an active cell is displayed in the
1. toolbar.
2. menu bar.
3. Name box.
4. formula bar.
42. The rectangular area where a column and a row intersect is called a(n)
1. cell.
2. cell range.
3. cell pointer.
4. active cell.
43. To move from one worksheet to another within an Excel workbook, click the
1. active cell.
2. scroll bar.
3. sheet tab.
4. tab button.
44. How does Excel automatically align text when displaying it in a cell?
1. It centers it.
2. It aligns it to the left.
3. It aligns it to the right.
4. It justifies it.
45. How does Excel automatically align values when displaying them in cells?
1. It centers it.
2. It left-aligns it.
3. It right-aligns it.
4. It justifies it.
46. Clicking the cell at the intersection of the third column and the fifth row activates which cell?
1. C6
2. A6
3. A5
4. C5
47. The formula used to multiply cell A1 by cell C1 is
1. =A1*C1.
2. C1*A1.
3. =A1/C1.
4. A1*C1.
48. When you enter a formula in a cell, where is the result of the formula displayed?
1. In the formula bar.
2. In the Name box.
3. In the cell.
4. In the worksheet window.
49. Cell references that change when copied are called __________ cell references.
1. automatic
2. absolute
3. resolute
4. relative
50. To create an absolute reference, insert a(n) __________ before the column and row of the cell reference.
1. number sign
2. equal sign
3. dollar sign
4. plus sign
51. If you copy a formula containing the relative reference C8 to another cell, the reference to C8
1. changes.
2. stays the same.
3. becomes absolute.
4. none of the above.
52. Which is the most commonly used function in Excel?
1. SUM
2. AVERAGE
3. MAX
4. MIN
53. The Excel function that calculates the arithmetic mean of a series of numbers is
1. SUM
2. AVERAGE
3. MIN
4. MAX
54. Which statistical function is used to find the smallest number in a series is
1. MIN
2. MAX
3. FIND
4. SUM
55. When you insert a new column into an Excel worksheet, where does it appear?
1. below the selected cell or range.
2. above the selected range
3. at the top of the worksheet
4. at the bottom of the worksheet
56. Typing &&[Tab] into a header will insert what information?
1. the filename
2. the date
3. the sheet name
4. a page number
57. Clicking the Formulas check box in the View tab of the Options dialog box allows you to
1. have Excel calculate formulas automatically.
2. edit your formulas.
3. view your formulas in the formula bar.
4. view formulas in cells rather than values.
58. Which tab in the Page Setup dialog box allows you to change the settings so that gridlines appear on a printout?
1. Sheet
2. Margins
3. Header/Footer
4. View Gridlines
59. To line up the currency symbols and decimal places within a column, which number format should you choose?
1. Accounting
2. Currency
3. Percentage
4. Number
60. To quickly copy formats from one cell or range to another, use the
1. Format Painter button.
2. Format Cells button.
3. Copy Format button.
4. Click and Drag button.
61. If the formula bar displays .1266, and you have selected the Number format with no decimal places, what appears in the active cell?
1. 0
2. 13%
3. 13
4. $13
62. Excel displays number symbols (#####) instead of data in a cell when
1. you perform an incorrect calculation.
2. the number is too long to fit within the cell's boundaries.
3. you have formatted your data incorrectly.
4. the height of the cell is not great enough to accommodate the data you've entered.
63. In Excel, lines, circles, and arrows are examples of
1. pictures.
2. icons
3. clip art.
4. graphic objects.
64. To move elements such as lines, circles, arrows, or boxes, you must first
1. select them.
2. edit them.
3. right-click them.
4. cut and paste them.
65. To print the date and page number on each page of a worksheet, select
1. the Page option from the Insert menu.
2. the Page tab in the Page Setup dialog box.
3. the Sheet tab in the Page Setup dialog box.
4. the Header/Footer tab in the page Setup dialog box.
66. Which type of Excel chart best shows the magnitude of change over a period of time?
1. Line chart
2. Pie chart
3. Column chart
4. Area chart
67. A group of related data points is known as a
1. data point series.
2. data series.
3. chart.
4. worksheet.
68. Data values are plotted along the vertical axis, known as the
1. X-axis.
2. Y-axis.
3. data axis.
4. axis.
69. Categories are generally plotted along the horizontal axis known as the
1. X-axis.
2. Y-axis.
3. data point axis.
4. axis.
70. The most effective type of chart for showing the proportion of parts to a whole is a
1. line chart.
2. pie chart.
3. proportion chart.
4. bar chart.
71. The first thing you do when creating an Excel chart is:
1. click the Chart Wizard button on the Standard toolbar.
2. select the cells that contain the data you want to appear in the chart.
3. specify what type of chart you want to create.
4. decide if you want to use a legend with your chart.
72. To move a chart to another location in a worksheet,
1. click File, then click Move Chart.
2. position the pointer over the chart, click, hold down the mouse pointer and drag the chart.
3. click the Move Chart button on the Standard toolbar.
4. click the Move button on the Chart toolbar.
73. If you change the data in a worksheet,
1. Excel automatically updates the chart created from that worksheet.
2. you must manually update the data in the chart.
3. you must use the Chart Wizard to update the data in the chart.
4. the change is reflected only in the chart, not in the worksheet.
74. A pie chart contains
1. only one data series.
2. only two data series.
3. three more data series.
4. at least four data series.
75. When you create a pie chart, Excel automatically
1. explodes the largest slice.
2. makes the pie chart 2-D.
3. makes the pie chart 3-D.
4. calculates the percentage for each slice.
76. A nonadjacent range is
1. data in a chart that is inconsistent with the data in the corresponding worksheet.
2. a group of cells or ranges that are not next to each other.
3. a slice of a pie chart that is out of proportion with the rest of the slices.
4. a range that cannot be converted to a chart.
77. Which key do you press in order to select nonadjacent ranges?
1. Home
2. Alt
3. Ctrl
4. F2
78. To create an exploded pie chart,
1. click the Explode Slice option from the Chart Type list arrow.
2. click the pie chart, click the slice you want to explode, then drag it away from the center of the chart.
3. double-click the slice you want to explode.
4. right-click the slice you want to explode.
79. Which of the following charts is most useful for comparing data by categories?
1. a pie chart
2. a line chart
3. a flow chart
4. a bar chart
80. Which type of chart is most useful if you have lengthy category labels?
1. pie chart
2. line chart
3. column chart
4. bar chart

ANSWER KEY 

1.  C
2.  C
3.  C
4.  D
5.  A
6.  A
7.  C
8.  B
9.  C
10. B
11. D
12. B
13. C
14. A
15. A
16. C
17. B
18. A
19. B
20. C
21. B
22. C
23. A
24. C
25. B
26. D
27. A
28. C
29. A
30. B
31. A
32. D
33. D
34. A
35. B
36. B
37. C
38. C
39. B
40. A
41. D
42. A
43. C
44. B
45. C
46. D
47. A
48. C
49. D
50. C
51. A
52. A
53. B
54. A
55. C
56. C
57. D
58. A
59. A
60. A
61. A
62. B
63. D
64. A
65. D
66. D
67. B
68. B
69. A
70. B
71. B
72. B
73. A
74. A
75. D
76. B
77. C
78. B
79. D
80. D