Chapter 5
Wildcard
a character, for example, 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.
Freeze panes
a command that enables you to select one more rows or columns and freezes (lock) them into place so that they remain on the screen while you scroll; the locked rows and columns become separate panes.
Find
a command that finds and selects specific text or formatting.
Criteria
conditions that you specify in a logical function or filter.
Hyperlink
text or graphics that, when clicked take you to another location in the worksheet, to another file, or to a webpage on the internet or on your organization's intranet.
And comparison operator
the comparison operator that requires each and every one of the comparison criteria be true.
Or comparison operator
the comparison operator that requires only one of the two comparison criteria that you specify to be true.
.xlsx file name extension
the default file format used by Excel 2013 to save an Excel workbook.
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.
Extract
the process of pulling out multiple sets of data for comparison purposes.
Field
a specific type of data such as a name, employed number, or social security number that is stored in columns.
Major sort
a term sometimes used to refer to the first sort level in the sort dialog box.
Record
all the categories of data pertainng to the one person, place , or thing, even or idea.
Criteria range
an area on your worksheet where you define the criteria for the filter, and that indicates how the displayed records are filtered.
Database
an organized collection of facts related to a specific topic.
Split
that command that enables you to view separate panes of the same worksheet on your screen; splits the window into multiple resizable panes to view distant parts of the worksheet at one time.
Arrange all
the command that tiles all open program windows on the screen.
Subtotal command
the command that totals several rows of related data together by automatically inserting subtotals for the selected cells.
Extract area
the location to which you copy records when extracting filtered rows.
Detail data
the subtotaled rows that are totaled and summarized ; typically adjacent to and either above or to the left of the summary data.
Additive
the term that describes the behavior of a filter when each additional filter that you apply is based on the current film, and that further reduces the number of records displayed.
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 earliest.
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.
XPS (XML paper specification)
a file type, developed by Microsoft, which creates a representation of electronic paper that displays your data on the screen as it would look when printed.
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, or specify computed criteria.
Compound filter
a filter that uses more than one condition-and one that uses comparison operators.
Custom filter
a filter with which you can apply criteria to a single column.
HTML ( hypertext markup language)
a language web browsers can interpret.
Pane
a portion of a worksheet window bounded by and separated from other portions by vertical and horizontal bars.
Theme
a predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied your entire document specific items.
Filtering
a process in which only the rows that meet the criteria display; rows that do not meet the criteria are hidden.
Query
a process of restricting records through the use of criteria conditions that will display records that will answer a question about the data.
List
a series of rows that contains related data that you can group by adding subtotals.
Custom list
a sort order that you can define.
Ascending
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.
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.
Go to
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.
Go to Special
a command that moves to specific cells or range of cells that your specifiy.
Cell style
a defined set of formatting characteristics, such as font size, font color, cell borders, and cell shading.
Sort dialog box
a dialog box in which you can sort data based on several criteria at once, and that enables a sort by more than one column or row.
Autofilter menu
a drop down menu from which you can filter a column by a list of values, by a format, or by criteria.
PDF (portable document format)
a file format developed by Adobe systems that creates a representation of electronic paper that displays your data on the screen as it would look when printed, but that cannot be easily changed.
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.
CSV ( comma separated values) file
a file type in which the cells in each row are separated by commas and an end-of-paragraph mark at the end of each row; also referred to as a comma delimited file.
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 CSV (comma seperated file) file.