A | B |
Additive | The 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 Filter | A 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 Operator | The comparison opertaor that requires each and every one of the comparison criteria to be true. |
Arrange All | The command that tiles all open program windows on the screen. |
Ascending | The 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 Menu | A drop- down menu from which you can filter a column by a list of values, by a format, or by criteria. |
Cell Styles | A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading. |
Comma Delimited File | A 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 Operators | Symbols 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 Criteria | The 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 Filter | A filter that uses more than one condition- and one that uses comparison operators. |
Criteria | Conditions that you specify in a logical function. |
Criteria Range | An 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) File | A file type in which the cells in each row are separated by commas; also referred to as a comma delimited file. |
Custom Filter | A filter with which you can apply complex criteria to a single column. |
Custom List | A sort order that you can define. |
Database | An organized collection of facts related to a specific topic. |
Descending | The 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 Data | The subtotaled rows that are totaled and summarized; typically adjacent to and either above or to the left of the summary data. |
Extract | 1. 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 Area | The location to which you copy records when extracting filtered rows. |
Field | A single peice of information that is stored in a recored. |
Filtering | A process in which only the rows that meet the criteria dispay; rows that do not meet the criteria are hidden. |
Find | A command that finds and selects specific text or formatting. |
Freeze Panes | A 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 To | A command that moves to a specific cell or range of cells that you specify. |
Go To Special | A 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. |
Hyperlink | Text 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. |
List | 1. 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 Sort | A term sometimes used to refer to the first sort level in the Sort dialog box. |
Or Comparison Operator | The comparison operator that requires only one of the two comparison criteria that you specify to be true. |
Panes | A 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. |
Query | The process used to ask a question of the data in a database. |
Record | All the categories of data pertaining to one person, place, thing, event, or idea. |
Scaling | The 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. |
Sort | The process of arranging data in a specific order based on the value in each field. |
Sort Dialog Box | A 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. |
Split | The 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 Command | The command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells. |
Tab Delimited Text File | A file type in which cells are separated by tabs; this type of file can be readily exchanged with various database programs. |
Theme | A 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. |
Wildcard | A 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 Extention | The 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. |