40 terms

Workbook

An Excel file that contains one or more worksheets.

Worksheet

The primary document that you use in Excel to store and work with data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.

Spreadsheet

Another name for a worksheet.

Active Cell

The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.

Cell reference

The identification of a specific cell by its intersecting column letter and row number.

Value

Data in a cell-text or numbers.

Text value

Data in a cell made up of text only.

Number value

Data in a cell made up of numbers only.

Label

Another name for a text value.

Name Box

An Excel window area that displays the address of a selected cell.

Text Wrap

A command with which you can display text on multiple lines within a cell.

Absolute cell reference

A cell reference that refers to a cell by its fixed position in a worksheet and that does not change when the formula is copied.

Number format

A specific way that Excel displays numbers.

General format

The default format that Excel applies to numbers-whatever you type in a cell will display, with the exception that trailing zeros to the right of decimal point will not display.

Accounting number format

The Excel number format that applies a comma separator where appropriate, inserts a fixed dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at both the right and left edges of the cell to accomodate parentheses for negative numbers.

Chart

A graphic representation of data in a worksheet that shows comparisons, patterns, and trends.

Category axis

The chart axis that is usually the horizontal axis and contains categories.

Value axis

The chart axis that is usually the vertical axis and contains data.

Explode

To pull out one or more slices of a 3-D pie chart to emphasize a specific slice or slices.

Theme

A set of design elements that provides a unified look for colors, fonts, and graphics.

Sheet tabs

The labels along the lower border of the workbook window that identify each worksheet.

Tab scrolling buttons

Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view.

Serial number

A sequential number assigned to a date.

Clipboard

A temporary storage area for text and graphics.

Drag and drop

A method of moving or copying the content of selected cells in which you point to the selection and then drag it to a new location.

Paste area

The target destination for data that has been cut or copied using the Clipboard.

Operator precedence

The mathematical rules for performing calculations within a formula.

Summary sheet

A worksheet that displays and summarizes totals from other worksheets in a workbook.

Detail sheet

A worksheet that contains the detailed information in a workbook.

Clustered bar chart

A chart type that is useful when you want to compare values across categories; categories are typically organized along the vertical axis, and the values along the horizontal axis.

Function

A prewritten formula that performs calculations by using specific values in a particular order or structure.

Calculated column

A column in an Excel table that uses a single formula that adjusts for each row.

Average

The Excel function that adds a group of values and then divides the result by the number of values in the group.

Arguments

In an Excel function, the values in parentheses used to perform calculations or operations.

Statistical functions

A type of function that summarizes a group of measurements.

NOW

The function that returns the serial number of the current date and time.

MIN

An Excel function the determines the smallest value in a selected range of values.

MAX

An Excel function that determines the largest value in a selected range of values.

Logical function

The type of function that tests for specific conditions and typically uses conditional tests to determine whether specified conditions are TRUE or FALSE.

Criteria

Conditions that you specify.