Module 3: Go! Excel 2010 Introductory Chapter 5

Find

A command that finds & 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 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.

Freeze Panes

A command that sets the column & row titles so that they remain on the screen while you scroll.

HTML (Hypertext Markup Language)

A language Web browsers can interpret when you save a worksheet as a Web page.

Split

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

command that tiles all open program windows on the screen.

Subtotal command

command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells.

And comparison operator

comparison operator that requires each & every one of the comparison criteria to be true.

.xlsx file name extension

default file format used by Excel 2010 to save an Excel workbook.

Cell styles

defined set of formatting characteristics, such as fonts, font sizes, number formats, cell borders, & cell shading.

Additive

describes the behavior of a filter when each additional filter that you apply is based on the current filter, & which further reduces the number of records displayed.

AutoFilter menu

drop-down menu from which you can filter a column by a list of values, by a format, or by criteria.

Tab delimited text file

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

file type in which the cells in each row are separated by commas; also referred to as a comma delimited file.

XPS (XML Paper Specification)

file type, developed by Microsoft, that provides an accurate visual representation of a document across applications & platforms.

Advanced Filter

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

filter that uses more than one condition—and one that uses comparison operators.

Custom Filter

filter with which you can apply complex criteria to a single column.

Scaling

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.

Extract area

location to which you copy records when extracting filtered rows.

Wildcard

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.

Compound criteria

use of two or more criteria on the same row—all conditions must be met for the records to be included in the results.

Criteria range

area on your worksheet where you define the criteria for the filter, and which indicates how the displayed records are filtered.

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.

Comma delimited file

A file type that saves the contents of the cells by placing commas between them & an end-of-paragraph mark at the end of each row; also referred to as a CSV (comma separated values) file.

PDF (Portable Document Format)

A file type, developed by Adobe Systems, that gives an accurate visual representation of a document across applications and platforms.

Panes

A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars.

Filtering

A process in which only the rows that meet the criteria display; rows that do not meet the criteria are hidden.

List

A series of rows that contains related data that you can group by adding subtotals.

Field

A single piece of information that is stored in a record.

Major sort

A term sometimes used to refer to the first sort level in the Sort dialog box.

Record

All the categories of data pertaining to one person, place, thing, event, or idea.

Criteria

Conditions that you specify for sorting & filtering data.

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 intranet.

Descending

That refers to the arrangement of text that is sorted alphabetically from Z to A, numbers sorted from highest to lowest, or dates & times sorted from latest to earliest.

Or comparison operator

The comparison operator that requires only one of the two comparison criteria that you specify to be true.

Sort

The process of organizing data in a particular order; for example, alphabetizing a list of names.

Query

The process used to ask a question of the data in a database.

Comparison operators

operators such as Equals (=), Greater Than (>), or Less Than (<) used to compare two values; the result is a logical value that is either true or false.

Database

organized collection of facts related to a specific topic.

Theme

predesigned set of colors, fonts, lines, & fill effects that look good together and that can be applied to your entire Office 2010 file or to specific items.

Extract

process of pulling out multiple sets of data for comparison purposes.

Ascending

refers to the arrangement of text that is sorted alphabetically from A to Z, numbers sorted from lowest to highest, or dates & times sorted from earliest to latest.

Custom list

sort order that you can define.

Detail data

subtotaled rows that are totaled & summarized; typically adjacent to and either above or to the left of the summary data.