Excel chapter 5 vocab
wild card
A character, for example the*or?, 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 or more rows or columns and freeze 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
Go to
A command that moves to a specific Cell or range of cells that you specify
Go to special
A command the moves to cells that have special characteristics, for example, to cells are blank or to cells that contains constants, or opposed to formulas
Cell style
A defined set of formatting characteristics such as font ,font size ,font color , cell borders and Cell shading
Sorts dialog box
A dialog box which you can sort data based on several criteria at once, and that enables as sorts buy more than one column or row
Auto filter menu
A drop-down menu from which you can filter a column by a list of values by a format or by criteria
Comma Delimited file
A file this 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 (separated values)file.
Tab delimited text file
A file type in which cells are separated by tabs; this type of file can be readily exchange 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
XPS( XML Paper Specification)
A file type, develop by Microsoft, which creates a representation on electronic paper that displays your data on the screen as it will look or 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 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 complex criteria to a single column
Scaling
A 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
HTML
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 pre-design set of colors, fonts, line, and fill the effect that looks good together and that can be applied to your entire document or to specific items
Filtering
A process in which only the rows 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 the will answer a question about the data
List
A series of rows that contain related data that you can group by adding subtitles
Custom list
A sort order that you can define
Field
A specific type of data such as name, employee number, or Social Security number that is stored in columns
Major sort
A term sometimes used to referred to the first sort of level in the sort dialogue box
Record
All the categories of data pertaining to one person,place,thing,events ,or idea
Database
And organized collection of facts related to a specific topic
Criteria
Conditions that you specify in the logical function or filter
. xlsx
Filename extension the default file format used but Excel 2013 to save an excel workbook
Criteria range
In area or your worksheet where you defined the criteria for the filter, and that indicates how the displayed records are filtered
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
Hyperlink
Text or graphics, when clicked, take you to another location in the worksheet, to another file, or to a webpage on the Internet or your organizations Intranet
Split
The command that enables you to view separate parts 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 programs windows on the screen
Subtotal command
The command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells
And comparison operator
The comparison operator that requires each and everyone of the comparison criteria to be true
Or comparison operator
The comparison operator that requires only one of the two comparison criteria that you specify to be true
Extract area
The location to which you copy records when extracting filtered rows
Sort
The process of arranging data in a specific order
Extract
The process of pulling out multiple sets of data for comparison purposes
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 filter and that further reduces the number of records displayed
Descending
The term that refers to the arrangement of text that is sort alphabetically from Z to a A, number Sorted from highest to lowest, or dates and times sorted from latest earliest
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 were sorted earliest to latest
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