CIS111E Chapter 4 Data Sets and Tables

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

  1. Freezing (p. 267)
    Freezing is the process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.
  2. Page Break (p. 268)
    Indicating where data will start on another printed page.
  3. Print Area (P. 269)
    The range of cells withing a worksheet that will print.
  4. Print Order (p. 270)
    The sequence in which the pages are printed.
  5. Table (P. 275)
    A structure that organizes data in a series of records (rows), with each record made up of a number of fields (columns)
  6. Field (p. 275)
    The smallest data element contained in a table, such as first name, last name, address, and phone number
  7. Record (p. 275)
    A group of related fields representing one entity, such as data for one person, place, event, or concept.
  8. Table Style (p. 279)
    The rules that control the fill color of the header row, columns, and records in a table.
  9. Sorting (p. 286)
    The process of listing records or text in a specific sequence, such as alphabetically by last name.
  10. Filtering (p. 288)
    The process of specifying conditions to display only those records that meet those conditions
  11. Structured Reference (p. 297)
    A tag or use of a table element, such as a field label, as a reference in a formula.  Field labels are enclosed in square brackets, such as [Amount] within the formula.
  12. Total Row (p. 298)
    A table row that appears below the last row of records in an Excel table and displays summary or aggregate statistics, such as a sum or an average.
  13. SUBTOTAL function (p. 298)
    A predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a database.
  14. Conditional Formatting (p. 304)
    A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications.
  15. Data Bars (p. 307)
    A conditional format that displays horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.
  16. Color scales (p. 308)
    A conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells.
  17. Icon Sets (p. 308)
    A conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
Card Set:
CIS111E Chapter 4 Data Sets and Tables
2015-10-04 17:13:06

Data Sets and Tables
Show Answers: