Excel Basics
Another name for a computerized spreadsheet.
worksheet
Determines the best width for a column or the best height for a row based on its contents.
AutoFit
Temporary storage area for up to 24 selections you copy or cut.
clipboard
Equation used to calculate values based on numbers entered in cells.
formula
Shorthand way to write an equation that performs a calculation.
function
Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.
Formula Bar
Moves data to a new line when the cell is not wide enough to display all the contents.
Wrap Text
Copies a cell's contents and/or formatting into an adjacent cell or range.
filling
A constant (text or number) or cell reference used in a formula.
operation
Used to describe quantities of data.
a. Statistical Functions
b. argument
c. Logical Functions
d. Financial Functions
a. statistical functions
A group of selected cells.
Cell range
A collection of formatting characteristics you apply to a cell or range of data.
cell style
Divides the worksheet window into two or four panes that you can scroll independently.
splitting
Sequence used to calculate the value of a formula.
order of evaluation
Used to analyze loans and investments.
a. Statistical Functions
b. argument
c. Logical Functions
d. Financial Functions
d. Financial Functions
The intersection of a row and column.
Cell
Combines several selected cells into one cell and places the data in the center of the merged cell.
Merge & Center
Consists of the cells and ranges designated for printing.
print area
Cells adjust to a new location when copied or moved to another cell.
relative cell reference
Displays text or values if certain conditions exist.
a. Statistical Functions
b. argument
c. Logical Functions
d. Financial Functions
c. Logical Functions
The combining of the cell's column letter and row number.
cell reference
A preset collection of design elements, including fonts, colors, and other effects.
Theme
Designated rows and/or columns in a worksheet that are printed on each page.
print titles
Do not change when copied or moved to anew cell.
absolute cell reference
Identifies the function to be performed.
a. Statistical Functions
b. argument
c. Logical Functions
d. Financial Functions
b. argument