CIS111E Chapter 9 Multiple-Sheet Workbook Management

The flashcards below were created by user davecowman on FreezingBlue Flashcards.

  1. Grouping (p. 506)
    The process of selecting worksheets to perform the same action at the same time
  2. Ungrouping (p. 506)
    The process of deselecting worksheets that were grouped
  3. Splitting (p. 510)
    The process of dividing a worksheet window.
  4. Split bars (p. 510)
    A vertical or horizontal line that frames panes in a worksheet and enables the user to resize the panes.
  5. Hyperlink (p. 511)
    An electronic marker to another location in a worksheet, workbook, file, Web Page, or email.
  6. 3-D reference (p. 519)
    Is a pointer to a cell in another worksheet.
  7. 3-D Formula (p. 520)
    A formula or function that refers to the same range in multiple worksheets
  8. Linking (p. 521)
    The process of connecting cells between worksheets.
  9. Source file (p. 521)
    A file that contains original data.
  10. Destination file (p. 521)
    A file that contains a pointer to the source file.
  11. Syntax error (p. 528)
    Occurs when formula construction rules are violated.
  12. Logic errors (p. 528)
    Occurs when a formula adheres to syntax rules but produces inaccurate results.
  13. Formula auditing (p. 529)
    Tools that enable you to detect and correct errors in formulas by identifying relationships among cells.
  14. Precedent Cells (p. 529)
    A cell that is referenced by a formula in another cell.
  15. Dependent cells (p. 529)
    A cell containing a formula that is dependent on other cells to obtain its value.
  16. Tracer arrows (p. 529)
    A colored line that indicates relationships between precedent and dependent cells.
  17. IFERROR function (p. 531)

    Checks a value and returns the result if possible or an error message.
  18. Watch Window (p. 531)
    Enables you to create a small window so you can conveniently inspect, audit, or confirm formula calculations involving cells not immediately visible on the screen.
  19. Data validation (p. 532)
    Requires that rules be followed in order to allow data to be entered in a cell.
  20. Validation criteria (p. 532)
    Rules that dictate the data to enter in  a cell.
  21. Input message (p. 533)
    A description or instructions for data entry
  22. Error alert (p. 533)
    A message that appears when the user enters invalid data in a cell containing a validation rule.
Card Set:
CIS111E Chapter 9 Multiple-Sheet Workbook Management
2015-11-06 16:43:26

Multiple-Sheet Workbook Management
Show Answers: