Java Games: Flashcards, matching, concentration, and word search.

Chapter 5

AB
AdditiveThe term that describes the behavior of a filter when each additional filter that you apply is based on the current filter, and which further reduces the number of records displayed.
Advanced FilterA filter that can specify three or more criteria for a particular column, apply complex criteria to two or more columns, or specify computed criteria.
And Comparison OperatorThe comparison opertaor that requires each and every one of the comparison criteria to be true.
Arrange AllThe command that tiles all open program windows on the screen.
AscendingThe term that refers to the arrangement of text that is sorted alphabetically from A to Z, numbers sorted from lowest to highest, or dates and times sorted from earliest to latest.
AutoFilter MenuA drop- down menu from which you can filter a column by a list of values, by a format, or by criteria.
Cell StylesA defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
Comma Delimited FileA file type that saves the contents of the cells by placing commas between them and an end-of-paragraph mark at the end of each row; also referred to as a CSV file.
Comparison OperatorsSymbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria.
Compound CriteriaThe use of two or more criteria on the same row- all conditions must be met for the records to be included in the results.
Compound FilterA filter that uses more than one condition- and one that uses comparison operators.
CriteriaConditions that you specify in a logical function.
Criteria RangeAn area on your worksheet where you define the criteria for the filter, and which indicates how the displayed records are filtered.
CSV (Comma Separated Values) FileA file type in which the cells in each row are separated by commas; also referred to as a comma delimited file.
Custom FilterA filter with which you can apply complex criteria to a single column.
Custom ListA sort order that you can define.
DatabaseAn organized collection of facts related to a specific topic.
DescendingThe term that refers to the arrangement of text that is sorted alphabetically from Z to A, numbers sorted from highest to lowest, or dates and times sorted from latest to ealiest.
Detail DataThe subtotaled rows that are totaled and summarized; typically adjacent to and either above or to the left of the summary data.
Extract1. To decompress, or pull out, files form a compressed form. 2. The location to which you copy the records is the Extract area, and is commonly placed below the table of data. Using this technique you can extract- pull out- multiply sets of data for comparison purposes.
Extract AreaThe location to which you copy records when extracting filtered rows.
FieldA single peice of information that is stored in a recored.
FilteringA process in which only the rows that meet the criteria dispay; rows that do not meet the criteria are hidden.
FindA command that finds and selects specific text or formatting.
Freeze PanesA command that enables you to select one or more rows or columns and freeze them into place; the locked rows and columns become separte pane.
Go ToA command that moves to a specific cell or range of cells that you specify.
Go To SpecialA command that moves to cells that have special characteristics, for example, to cells that are blank or to cells that contain constants, as opposed to formulas.
HTML (Hypertext Markup Language)A language Web browsers can interpret when you save a worksheet as a Web page.
HyperlinkText or graphics that, when clicked, take you to another location in the worksheet, to another file, or to a Web page on the Internet or on your organization's intracet.
List1. A series of rows that contains related data that you can group by adding subtotals. 2. A category of SmartArt graphics used to show nonsequential information.
Major SortA term sometimes used to refer to the first sort level in the Sort dialog box.
Or Comparison OperatorThe comparison operator that requires only one of the two comparison criteria that you specify to be true.
PanesA portion of a worksheet window bounded by and separated from other portions by vertical and horizontal bars.
PDF (Portable Document Format)A file format that creates an image that preserves the look of your file, but that cannot be easily changed; a popular format for sending documents electronically, because the document will display on most computers.
QueryThe process used to ask a question of the data in a database.
RecordAll the categories of data pertaining to one person, place, thing, event, or idea.
ScalingThe group of commands by which you can reduce the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify.
SortThe process of arranging data in a specific order based on the value in each field.
Sort Dialog BoxA dialog box in which you can sort data based on several criteria at once, and which enables a sort by more than one column or row.
SplitThe command that enables you to view separate parts of the same worksheet on your screen; splits the window into muliple resizable panes to view distant parts of teh worksheet at one time.
Subtotal CommandThe command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells.
Tab Delimited Text FileA file type in which cells are separated by tabs; this type of file can be readily exchanged with various database programs.
ThemeA predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied to your entire document or to specific items.
WildcardA character, for example the asterisk or question mark, used to search a field when you are uncertain of the exact value or when you want to widen the search to include more records.
.xlsx File Name ExtentionThe default format used by Excel 2010 to save an Excel workbook.
XPS ( XML Paper Specification)A file type, developed by Microsoft, that provides an accurate visual representation of a document across applications and platforms.


Computer Applications Instructor
Renton Technical College
Renton, WA

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities