40 terms

Matching Section on Excel

An Excel file that contains one or more worksheets.
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.
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.
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.
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.
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.
To pull out one or more slices of a 3-D pie chart to emphasize a specific slice or slices.
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.
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.
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.
The Excel function that adds a group of values and then divides the result by the number of values in the group.
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.
The function that returns the serial number of the current date and time.
An Excel function the determines the smallest value in a selected range of values.
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.
Conditions that you specify.