CS 120 - Concepts of Computing Sample Final Exam - Part II: Applications Multiple Choice Questions: Select the best answer for each of the following. 1. Which program is used to link pages of information together? A. web publishing program B. presentation graphics C. database D. spreadsheet 2. Which program can be described as a mathematical modeling tool? A. word processor B. spreadsheet C. database D. none of these 3. Which program would be used to manage an inventory? A. spreadsheet B. word processor C. database D. web publishing program 4. Which program should be used to edit a photo? A. paint graphics B. draw graphics C. presentation graphics program D. all of these 5. Which program should be used to create a pie chart from a set of data? A. database B. paint graphics C. spreadsheet D. draw graphics 6. Which program should be used to combine several images into a single image? A. mail merge B. graphics C. presentation graphics program D. all of these 7. Which program should be used to create overhead transparencies for a business presentation? A. word processor B. spreadsheet C. presentation graphics program D. database 8. Which program would you use for statistical analysis? A. spreadsheet B. database C. mail merge D. graphics 9. Which program would you use to print address labels? A. web publishing program B. database C. mail merge D. graphics 10. Which program would you use to create a visual aid for an oral report? A. presentation graphics B. paint graphics C. spreadsheet D. mail merge 11. Which program would you use for sharing information with as many people as possible? A. presentation graphics B. web publishing C. word processing D. database 12. Which program uses tables? A. word processing B. database C. web publishing D. all of these 13. Access is a __________. A. spreadsheet B. database C. presentation graphics program D. web publishing program 14. PaintShop Pro is a __________. A. presentation graphics program B. paint only graphics program C. draw only graphics program D. paint and draw graphics program 15. Composer is a __________. A. web publishing program B. word processor C. spreadsheet D. database 16. __________ is a Corel product. A. PowerPoint B. Presentations C. Excel D. Composer 17. __________ is an Adobe product. A. Composer B. Dreamweaver C. PhotoShop D. PaintShop Pro 18. In a spreadsheet, a label is used to __________. A. identify the meaning of the numerical data. B. define a calculation. C. specify a constant value. D. none of these 19. In a spreadsheet, all formulas begin with a(n) __________ A. ^ symbol. B. = symbol. C. # symbol. D. & symbol. 20. Which of the following is a method for copying the contents of a spreadsheet cell into an non-adjacent cell? A. fill down B. fill right C. copy/paste D. all of these 21. Which of the following is a method for copying the contents of a spreadsheet cell into several adjacent cells? A. fill down B. fill right C. copy/paste D. all of these 22. Which of following is a spreadsheet numeric formatting command? A. currency B. bold C. center D. AutoSum 23. If a spreadsheet column is not wide enough for the contents of a cell containing a value, __________ will be displayed. A. @@@@@@@@ B. ######## C. ++++++++ D. &&&&&&&& 24. If a spreadsheet column is not wide enough for the contents of a cell containing a label and the next cell contains data, the label will __________. A. not be displayed. B. be replaced with ######## C. be truncated. D. will spill over into the next cell. 25. Which of the following produces the total of the contents of the cells in the given cell range? A. =B1:B9 B. =AutoSum(B1:B9) C. =total(B1:B9) D. =sum(B1:B9) 26. Which of the following uses a relative cell reference? A. =B5+17 B. =$B$5+17 C. =$B5+17 D. =B$5+17 27. Which kind of reference does not change when copied into another cell? A. relative B. absolute C. both of these D. neither of these 28. In a database, a category of data is called a __________. A. form B. query C. field D. record 29. In a database, the description of an object is called a __________. A. form B. query C. field D. record 30. The data of a database is contained in a __________. A. table B. form C. query D. report 31. For viewing, creating, and editing individual records in a database, a __________ should be used. A. table B. form C. query D. report 32. To select out records that satisfy a set of criteria, a __________ is used. A. table B. form C. query D. report 33. The primary tool for producing printouts in a database is a __________. A. table B. form C. query D. report 34. Which of the following could be a merge code in a mail merge document? A. B. (Name) C. <> D. ((Name)) 35. The data source of a mail merge can be __________. A. all or a portion of a spreadsheet. B. a database table. C. a database query. D. all of these 36. The resolution of a graphic is only used with __________ graphics. A. print B. displayed C. web D. projected 37. 8-bit images can use up to __________ colors. A. 16 B. 256 C. 32,767 D. 16.7 million 38. 4-bit images can use up to __________ colors. A. 16 B. 256 C. 32,768 D. 16.7 million 39. 24-bit images can use up to __________ colors. A. 16 B. 256 C. 32,767 D. 16.7 million 40. GIF files use __________ compression. A. lossless B. lossy C. lousy D. loosey 41. JPG files use __________ compression. A. lossless B. lossy C. lousy D. loosey 42. Graphic files processed as a series of dots are called __________ graphics. A. object-oriented B. vector C. raster D. none of these 43. Raster graphics are also known as __________ graphics. A. scanned B. object-oriented C. vector D. bit-mapped 44. Graphic files processed as a collection of objects are called __________ graphics. A. vector B. bit-mapped C. raster D. none of these 45. Which file format is considered to be a standard Macintosh graphic format? A. BMP B. PICT C. JPG D. GIF 46. Which file format is primarily designed for print graphics? A. TIFF B. WMF C. EPS D. JPG 47. Image editing programs work with __________ color(s) at a time. A. 1 B. 2 C. 256 D. 16.7 million 48. A presentation template will determine the default __________. A. color scheme. B. background graphics. C. both of these D. neither of these 49. The layout of a web page is determined by __________ tags. A. URL B. HTTP C. HTML D. FTP 50. Which of the following can be web page elements? A. paragraphs of text B. graphics C. rules D. all of these 51. The home page of a web site should use the filename __________. A. home.html B. index.html C. default.html D. start.html 52. An internal link on a web page will take the user to __________. A. San Francisco B. the living room C. a page on another web site D. a page on the same web site Matching Questions: Select the letter of the best match for each of the following. A. table B. cell C. splitting cells D. spreadsheet E. active cell F. formula bar G. label H. value I. AutoSum ____ 53. Making two or more cells of a table out of a single cell. ____ 54. A common standard spreadsheet function that calculates the total of the contents of two or more cells. ____ 55. Numbers or formulas placed into a spreadsheet cell. ____ 56. Text placed into a spreadsheet cell. ____ 57. The cell of a spreadsheet that will receive the next input. ____ 58. The line above a spreadsheet that displays the actual content of the active cell. A. fill right B. fill down C. numeric formatting D. cell range E. relative reference F. absolute reference G. legend H. bar or column chart I. line or area chart ____ 59. A specification that refers to a group of cells in a spreadsheet. ____ 60. Special formats (e.g.. currency, percent, comma, etc.) that can be applied to values in a spreadsheet. ____ 61. A spreadsheet chart that compares the data by representing values as rectangles of different lengths. ____ 62. A cell reference that is fixed (i.e. does not change when copied). ____ 63. A feature of a spreadsheet that copies the contents of a cell into one or more cells to the right. ____ 64. A key used in spreadsheet charts that specifies the meaning of the different colors and/or fill patterns of the chart elements. A. pie chart B. database C. field D. record E. database table F. database form G. database query H. QBE (Query By Example) I. mail merge ____ 65. A method of specifying queries in a database by using dialog boxes to determine specifications. ____ 66. A spreadsheet chart in which each piece of data is represented as a portion of the whole. ____ 67. A category of data. ____ 68. A specification that determines a layout that can be used for viewing individual records of a database. ____ 69. A container for the data in a database. ____ 70. A tool for managing, organizing, and accessing lists of descriptions of objects. A. secondary file B. merge code C. numeric-picture D. graphics E. resolution F. pixels G. compression H. lossy I. lossless ____ 71. A compression method that retains all of the information. ____ 72. Dots of color used to create an image. ____ 73. Tools for creating, editing, and manipulating images. ____ 74. The number of pixels per inch used in an image. ____ 75. Storing information in a file, such as an image, in a format that reduces the size of the file. ____ 76. A code that determines the format of a numerical value in a mail merge. A. vector B. JPG C. GIF D. BMP E. PICT F. paint G. draw H. crop I. color table ____ 77. The standard graphic file format for Macintosh computers. ____ 78. A format that describes an image as a collection of objects. ____ 79. The process of selecting a rectangular portion of an image and discarding the rest. ____ 80. Programs designed to edit vector images. ____ 81. A graphic file format that uses lossy compression and is good for photos and photo-realistic images. ____ 82. A table that determines the color palette of an image. A. stroke B. fill C. handle D. presentation graphics E. template F. slide layout G. slide master H. transition I. animation ____ 83. The visual affect used to move from one slide to the next in a computer controlled slide presentation. ____ 84. A predefined set of specifications that determine the default background, fonts, and color scheme of the slides of a presentation. ____ 85. A tool used to adjust the size of an object in a vector image. ____ 86. The organization of the elements of a slide of a presentation. ____ 87. A tool for the creation, editing, printing, and displaying of slides that may contain text, graphics, and other multimedia objects. ____ 88. Specifications that determine the default elements of a slide in a presentation. A. web publishing B. protocol C. IP number D. domain name E. web server F. hypertext G. HTTP H. HTML I. URL ____ 89. An address of a resource on the Internet. ____ 90. A name or mnemonic assigned to the IP number of a web server that can be used to access the server's resources. ____ 91. A unique number assigned to each computer on the Internet for identification purposes. ____ 92. A computer with special software that can provide resources (i.e. information) to other computers on the Internet. ____ 93. Tools used to create, edit, and manage web pages and web sites. ____ 94. The protocol of web pages. A. web page B. web site C. heading D. rule E. internal link F. external link G. site folder H. thumbnail I. unordered list ____ 95. A group of paragraphs, each of which are proceeded by a bullet. ____ 96. A reference on a web page (hypertext or a graphic) that when clicked on will take the user to another page on the same web site. ____ 97. A folder that contains all of the files that make up a web site. ____ 98. A horizontal line used on web pages as a separator. ____ 99. A reference on a web page (hypertext or a graphic) that when clicked on will take the user to another page on a different web site. ____ 100. A document that can be displayed by a web browser.