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