CS110 Final

  1. Auto Complete
    feather that assists in your typing by suggesting words of phrases or fills in the remaining characters for you.
  2. Font
    set of characters with the same design and shape
  3. Insertion point
    blinking vertical line that indicates where text or graphics will be inserted
  4. Office button
    large button to the left of the quick access toolbar that displays a list of commands that you can do with a workbook such as opening, saving, printing, and sharing.
  5. Selecting text
    highlighting text so that it can be formatted, deleted, copied, or moved.
  6. Title bar
    In the Word window, the location of the minimize, maximize, and close buttons.
  7. Wordwrap
    feature that moves text from the right edge of a paragraph to the beginning of the next line as necessary to fit within the margins.
  8. Absolute cell reference
    cell reference that regers to cells by their fixed position in a worksheet. an absolute cell reference remains the same when the formula is copied.
  9. Active cell
    the cell surrounded by the black border, ready to receive data or be affected by the next cell command.
  10. Auto fill
    An Excel feature that extends values into adjacent cells based on the values of selected cells.
  11. Auto correct
    feature that assists in your typing by automatically correcting and formatting some text as you type.
  12. Auto sum
    another term for the sum function.
  13. Cell
    small box formed by the intersection of a column and a row.
  14. Chart
    graphic representation of data in a worksheet
  15. Column
    vertical group of cells in a worksheet
  16. Fill handle
    small black square in the lower right corner of a selected cell
  17. Formula
    an equation that performs mathematical calculations on values in a worksheet
  18. Landscape orientation
    page orientation in which the printed page is wider than it is tall.
  19. Portrait orientation
    page orientation in which the printed page is taller than it is wide.
  20. Relative cell reference
    In a formula, the address of a cell based on the realtive position of the cell that contains the formula and the cell referred to.
  21. Spreadsheet
    Another name for a worksheet.
  22. Workbook
    An Excel file that contains one or more worksheets.
  23. Worksheet
    The primary document that you use in Excel to store and work with data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.
  24. AutoNumber
    An Access feature that sequentially numbers entered records creating a unique number for each record
  25. Database
    An organized collection of facts about people, events, things, or ideas related to a particular topic or purpose.
  26. Datasheet view
    The Access view that displays an object organized in a format of columns and rows similar to an Excel spreadsheet.
  27. DBMS
    An acronym for database management system.
  28. Design view
    The detailed sturctured view of a form or report, and the view in which some tasks must be performed, only the controls and not the data are visible in this view.
  29. Field
    A category that describes each piece of data stored in a table.
  30. Primary key
    The field that uniquely identifies a record in a table such as a student ID number.
  31. Query
    A database object that retrieves specific data from one or more tables and then displays the specified data in datasheet view.
  32. Record
    All of the categories of data pertaining to one person, place, thing, or idea.
  33. Report
    A database object that summarizes the fields and records from a table, or from a query, in an easy to read format suitable for printing and publication.
  34. Table
    The Access object that stores your data organized in an arrangement of columns and rows.
  35. Layout
    The placement and arrangement of text and graphics on a slide
  36. Notes pages
    Printouts that contain the slide image in the top half of the page and the speakers notes in the lower half of the page.
  37. Presentation graphics software
    A program used to effectively present information to an audience.
  38. Slide handouts
    Printed images of more than one slide on a sheet of paper.
  39. Slide sorter view
    A view useful for rearranging slides in which all of the slides in the presentation display as thumbnails.
  40. Show/Hide button
    button that represents the command to reveal non-printing characters.
  41. Formatting
    The process of setting the overall appearance of the text within the document.
  42. Quick Access Toolbar
    toolbar above the ribbon and to the right of the Office button that can be customized by adding frequently used buttons.
  43. Before text can be edited, changed, formatted, copied, or moved, it must first be ___________.
  44. Word processing program
    allows you to type, edit, move, and delete text or change the appearance of text.
  45. Ribbon
    user interface in Office 2007 that groups the commands for performing related tasks on tabs across the upper portion of the program window.
  46. View options
    Buttons on the right side of the status bar for viewing in Normal, Page Layout View, or Page Break Preview, also displays controls for zoom out and zoom in.
  47. Column headings
    The letters at the top of an Excel worksheet that disignate the columns.
  48. Range
    Two or more selected cells on a worksheet that are adjacent or non-adjacent, and treated by Excel as a single unit for the purpose of editing.
  49. Constant value
    Numbers, text, dates, or timeof day that you type into a cell.
  50. Relative cell reference
    In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.
  51. Microprocessor
    Chip that contains the CPU.
  52. Wi-Fi
    802.11 standard, wireless fidelity
  53. Hard Drive
    Holds all permanently stored programs and data and is located inside the system unit.
  54. Memory
    component inside the system unit that holds or stores instructions or data that the CPU processes.
  55. Storage devices
    devices such as hard disk drives, floppy drives and CD drives used for storing data and information.
  56. CPU
    part of the system unit that is responsible for data processing. The "brains" of the computer.
  57. ALU
    part of the CPU that performs all mathematical and logical calculations.
  58. Peripheral devices
    Devices such as monitors, printers, and keyboards that connect to the system unit through ports.
  59. Application software
    programs that allow the user to perform specific tasks such as word processing or playing games.
  60. Operating system
    System software that controls the way in which the computer system functions, including the management of hardware, peripherals, and software.
  61. System software
    set of programs that enables the a computers hardware and application software to work together. Includes operating system and utility programs.
  62. Hardware
    Any part of the computer you can physically touch.
  63. Motherboard
    computers main circuit board that contains the CPU, system memory, and expansion slots.
  64. USB port
    port to connect peripherals to the computer. Version 2.0 has a throughput of 480Mbps.
  65. DSL
    connects your computer to the internet using phone lines to provide high bandwidth throughput.
  66. MS-DOS
    single user, single task operating system created by Microsoft. First widely used operating system installed on personal computers.
  67. Microsoft Windows
    The most popular operating system for desktop computers.
  68. Anti-virus software
    designed to detect viruses and protect a computer and files from harm.
  69. Router
    Device that route packets of data between two or more networks.
  70. Cache memory
    small blocks of memory located on or next to the CPU that holds recently or frequently used instructions or data that the CPU accesses the most.
  71. Software
    set of computer programs or instructions that tells the computer what to do and enables it to perform different tasks.
  72. Byte
    8 binary digits or 8 bits
  73. Megabyte
    about a million bytes
  74. Kilobyte
    about a thousand bytes
  75. ROM
    set of memory chips on the motherboard that stores data and instructions that cannot be changed or erased. It holds all the instructions the computer needs to start up.
  76. RAM
    The computers temporary storage space or short-term memory. Located on the motherboard and capacity is measured in MBs or GBs.
  77. CD ROM
    portable, read only optical storage device.
  78. CD RW disc
    portable optical storage device that can be written and rewritten to many times.
  79. DVD disc
    optical storage device similar to a CD but the capacity is much greater.
  80. Modem card
    device that provides the computer with a connection to the internet using conventional phone lines.
  81. Network
    A group of two or more computers (or nodes) that are configured to share information or resources such as printers, files, and databases.
  82. Unix
    Operating system originally conceived in 1969 by Ken Thompson and Dennis Ritchie of AT&T's Bell Labs. Open source.
  83. Virus
    computer program that attaches itself to another program and attempts to spread itself to other computers when files are exchanged.
  84. Firewall
    Software or hardware designed to protect computers from unauthorized access by closing logical ports.
  85. Bus
    group of electrical pathways inside a computer that provide communications between various parts of the computer and CPU and main memory.
  86. Gigabyte
    about a billion bytes
  87. For what would you use a word processor at work?
    letters, memos, and documents
  88. For what would you use a word processor at home?
    Reports, papers, and letters.
  89. For what would you use an electronic spreadsheet at work?
    accounting, budgets, make charts
  90. For what would you use an electronic spreadsheet at home?
    lab reports, budgets, make charts
  91. For what would you use a presentation program at work?
    presentations for clients, co-workers, meetings
  92. For what would you use presentation programs at home?
    Presentations for class, club meetings, friends
  93. For what would you use a database management program at work?
  94. For what would you use a database management program at home?
    address book, christmas list, book list
Card Set
CS110 Final
CS110 Final