1. In a spreadsheet program, a(n) __________ typically appears on the screen as a grid of numbered rows and alphabetically lettered columns. a. cell b. address c. location d. worksheet |
2. Which of the following is not a true statement? a. Every cell in a worksheet has a unique address made up of a row number and a column number. b. All cells are empty in a new worksheet. c. Each cell will contain either a numeric value or an alphabetic label. d. A worksheet typically appears on the screen as a grid of numbered rows and alphabetically lettered columns. |
3. The cell containing the cursor in a spreadsheet is called a(n): a. active cell b. console c. formula bar d. dialog box |
4. Formulas can be constructed with this type of reference so that they do not change when replicated in other locations. a. relative b. absolute c. nonpermanent d. mobile |
5. An "empty" or generic document that can be easily adapted to specific user needs is called a: a. form b. shell c. macro d. template |
6. Most spreadsheets will allow you to create __________ between worksheets, so when values change in one, the others are updated automatically. a. associations b. macros c. links d. None of the above is correct. |
7. GIGO stands for: a. garbage in, garbage out b. good input, good output c. good information, good outcomes d. None of the above is correct. |
8. A menu that appears when you click on a particular icon is called a(n): a. hidden menu b. dialog box c. pop-up menu d. option menu |
9. Pictures that are, to the computer, simple maps showing how the pixels on the screen should be represented are known as: a. vector graphics b. object-oriented graphics c. presentation graphics d. bit-mapped graphics |
10. The software that allows the user to manipulate photographs and other higher-resolution images is called: a. an analog camera b. CAD c. vector graphics software d. digital image processing software |
11. The type of graphics in which pictures are stored as collections of lines, shapes, and other objects is: a. object-oriented graphics b. bit-mapped graphics c. icon-based graphics d. raster graphics |
12. Object-oriented drawing and illustration programs are a better choice for: a. providing artists and photo editors unsurpassed control over textures, shading, and fine detail b. creating screen displays c. creating printed graphs, charts, and illustrations with clean lines and smooth shapes d. simulating natural paint media |
13. Which of the following is a true statement regarding CAD? a. CAD allows users to create three-dimensional "solid" models with physical characteristics. b. CAD tends to be more expensive than traditional design-by-hand techniques. c. CAD models are two-dimensional models. d. All of the above are correct. |
14. The illusion of movement created by a rapidly displayed sequence of still drawings is called: a. animation b. framing c. morphing d. virtual reality |
15. Video clips in which one image transforms into another are called: a. cartoons b. morphs c. digital videos d. live animation |
16. The advantages of CD audio do not include: a. high sound quality b. low storage costs c. CD-ROM is a read/write medium d. Both b and c are not correct |
17. It would be to your advantage to store several thousand phone numbers in a: a. word processing document b. spreadsheet document c. database d. template |
18. Information relating to one person, product, or event is called a: a. file b. record c. document d. folder |
19. Which of the following best defines a field? a. information relating to one person, product, or event b. a collection of related information c. a collection of information stored in an organized form in a computer d. a discrete chunk of information in a record |
20. Computed fields in a database can contain: a. text values only b. numeric values only c. formulas and numeric values d. formulas and text values |
21. When a user issues a command to find all the records that match a set of criteria, it is called a: a. scan b. search c. query d. sort |
22. Transmitting data to another program is called: a. exporting b. importing c. linking d. transferring |
23. Your company wants to send an advertising flyer to all Benton County residents with at least five acres of property. To select the appropriate records from the database, which selection rules should you use? a. county EQUALS Benton OR acreage GREATER THAN 5 b. county EQUALS Benton AND acreage GREATER THAN 5 c. county EQUALS Benton OR acreage GREATER THAN OR EQUAL TO 5 d. county EQUALS Benton AND acreage GREATER THAN OR EQUAL TO 5 |
24. A general-purpose program or system of programs that can manipulate data in a large collection of files is called a(n): a. database management system b. PIM c. file manager d. SQL |
25. The control structure used to make logical decisions is the: a. sequence control structure b. selection control structure c. repetition control structure d. logical control structure |
26. The process of writing a program from an algorithm is called: a. coding b. decoding c. encoding d. encrypting |
27. Programs need to be entered into the computer’s memory, saved as a disk file, and translated into the computer’s native machine language before they can be executed or run. To enter and save a program, you can use a(n): a. formatter b. CAD program c. text editor d. interpreter |
28. A compiler has what advantage(s) over an interpreter? a. you can try to run the program right after it is entered into the machine b. compilers run programs at a much higher speed c. any bugs found at run time usually can be pinpointed to a particular source code line easily d. Both a and c are correct. |
29. Assume you are testing a program with a series of incorrect guesses and the program should stop after ten incorrect guesses. However, the program fails to stop; this is an example of a(n): a. logic error b. syntax error c. translation error d. interpretation error |
30. A language that is logically equivalent to machine language but easier for people to read, write, and understand is called: a. a fourth-generation language b. assembly language c. Ada d. a high-level language |
31. The field of computer science devoted to making computers perceive, reason, and act in ways that have, until now, been reserved for human beings is called: a. expert systems b. natural intelligence c. artificial intelligence d. robotics |
32. Much early AI work focused on games like checkers and chess because: a. they are easy to represent in the computer’s digital memory b. they have clearly defined rules c. the goals of the game are unmistakable d. All of the above are correct. |
33. A heuristic is a(n): a. AI application b. speech synthesizer c. rule of thumb d. knowledge base |
34. The ability of a computer program to learn from experience is called: a. heuristics b. natural intelligence c. machine learning d. mimicking |
35. Which of the following was one of the first software programs to converse in a limited form of natural language? a. ELIZA b. George c. Pascal d. COBOL |
36. Semantics can be defined as: a. the underlying meaning of words and phrases b. a set of rules for constructing sentences from words c. information that incorporates the relationships between facts d. None of the above is correct. |
37. Some of the first successful expert systems were developed around medical knowledge bases because: a. physicians were overworked and needed assistance b. many physicians were not born in the U.S. and needed language assistance c. costs of medical operations were increasing drastically d. medical knowledge is usually orderly and well documented |
38. Optical character recognition is: a. the use of a special input device and software to read characters and convert them into electrical signals b. a software program designed to replicate the decision-making process of a human expert c. software that analyzes sentence structure and identifies parts of speech d. the ability of a computer program to learn from experience |
39. Which of the following is not a true statement? a. A neural network uses a network of a few thousand simpler processors called neurons. b. A neural network learns patterns by trial and error. c. Neural networks are programmed in the usual way. d. When a neural network makes a decision, you have no way to ask why. |
40. The fear of technology is called: a. technophobia b. arachnophobia c. cyberphobia d. hydrophobia |
41. Experts suggest that most of the jobs that: a. exist today require only a high school education b. workers perform today can be considered lifelong c. will exist in ten years do not exist today d. exist today will change less drastically than in the past |
42. Computers in classrooms: a. improve memorization skills, but provide no help with learning analytical skills b. decrease school budgets by replacing teachers c. allow students to work at their own pace d. improve student analytical skills, but provide no help with creative work |
43. Which of the following is not a CAI advantage? a. group learning b. motivation c. individualized learning d. confidence |
44. Which of the following is a true statement about turtle graphics? a. Turtle graphics is a short, animated movie about turtles. b. With turtle graphics a child uses LOGO commands to make a "turtle" move, dragging a "pen" to draw lines as it moves. c. Turtle graphics is the newest form of multimedia educational tool to hit the market. d. None of the above is correct. |
45. Which of the following is not a true statement? a. It is easy to prove the effectiveness of simulation games because they generally are designed to teach simple, measurable facts. b. Simulations allow students to have experiences that would not be possible otherwise. c. With a simulation, the students are in control of the learning environment. d. Educational simulations are metaphors designed to focus student attention on the most important concepts. |
46. What is a major problem of using computers in education? a. the students can’t work at their own pace b. creativity is eliminated by computers c. the lack of teacher training d. the students must work without a teacher |