1. _______________ is an electronic device that processes data.
2. ____________________ has logical processes embedded into it so that software programs can utilize them. It is like a brain in a human body.
3. A computer processes data as a series of one of two states, on or off. For human beings to be able to easily understand, the states are represented as either 0 for off or 1 for on. Each of these, 0 or 1, is called a ________________.
4. Which of the following is not true about a byte?
5. After the CPU processes data, the data are sent to other devices such as output devices or storage devices. In this sense, storage devices sometimes are considered output devices. Output devices are different from storage devices, however, because _____________________.
6. Permanent storage devices are _____________________.
7. Temporary storage devices are ____________________________________.
8. Random access memory is _____________________________________________.
9. A flash memory jump drive is ___________________.
10. When you turn on a computer, ________________________________.
11. Which of the following is not true about read-only memory (ROM)?
12. An operating system is ___________________________.
13. Which of the following is not true about a software driver?
14. If you need to handle text data as they are represented (i.e., code), which of the following is the best program?
15. Which of the following is not true about Notepad?
16. If you need to create clean Web pages, which of the following is the best choice?
17. If you need to create a text document with some graphics and format it for printing, which of the following is the best choice?
18. If you need to create fliers that includes graphics and text, which of the following would be the best choice?
19. Microsoft Access __________________________________.
20. Tables in Microsoft Access are ______________________________.
21. The programming tool to process data in a relational database management system is __________________.
22. You have created two tables in Microsoft Access (EMP and DEPT) and used queries to insert data into the tables. You also used another query to list all the data from the two tables, run the query to get a result set, and saved the query as Employees. You then exited the program after you had saved the Access file as test.accdb. What are included in the file, test.accdb?
23. In a table of Microsoft Access, ____________________ data are stored.
24. If you need to store large amount of data in storage devices, which of the following is the best choice?
25. Which of the following is not true about Microsoft Access?
26. A relation in a database management system is ______________________.
27. Structured query language is ________________________.
28. Microsoft PowerPoint is _______________________________.
29. If you need to create electronic slides for your presentation, which of the following is the best choice?
30. A Web browser such as Firefox is _______________________________.
31. Microsoft Excel is ____________________________.
32. Which of the following is not true about Microsoft Excel 2013?
33. What type of data does a cell in Microsoft Excel handle?
34. Which of the following is true about Microsoft Excel?
35. A cell in an electronic spreadsheet program is identified with its address. A cell in row 12 and column F is presented as _______________.
36. Which of the following data types is the most important in an electronic spreadsheet program?
37. Text data in an electronic spreadsheet program is used mostly for ___________________________.
38. What is the formula to calculate the sum of the numbers in the following cells of Microsoft Excel?
A B C D
1
2 12
3 33
4 53
5
6
7
8
39. Cell E23 of a worksheet in Microsoft Excel includes a formula, =B12*D2. Which of the following is true if you need to fix the column of D2 in the formula?
40. Which of the following is the best choice if you need to do complex calculations with large amount of numeric data?
41. In Microsoft Excel, when you copy a formula in a cell (A12) and paste it into another cell (F34), the other cell (F34) will have ___________.
42. Which of the following is the most important job of an electronic spreadsheet program?
43. In Microsoft Excel, which of the following is the best choice if you need to see the total amount (set a cell, F34, to 100000) based on a value in another cell (by changing a value of a cell, B30)?
44. The default file management program in Windows 7 is _______________________.
45. The default text-based command-driven communication channel to Windows 7 is __________________________.
46. A Web server is based on the UNIX operating system architecture, and thus file and directory (folder) names can include spaces.
47. ___________________ is a named unit of storage. It is usually stored in a permanent storage device and can be copied into memory to be used. A program can be stored in it. Data (text, graphic, audio, or video) can be stored in it.
48. A worksheet in an electronic spreadsheet program is like a big table with many cells, each of which is flexible to handle text or numeric data.
49. In a computer, files are organized hierarchically. If you have sub-directories (sub-folders, e.g., assignments directory under the cis211 directory under the root directory), your Windows operating system will follow the path, C:\cis211\assignments\, to access a file under the assignments directory.
50. Computer directories or folders are useful tools that can be used to group relevant files together. Technically, operating systems treat them as if they are files.