71 terms

Excel Key Terms (Lessons 1, 2, 3, 5)

STUDY
PLAY
Active cell
The cell in the worksheet in which you can type data. (EX 6)
Active worksheet
The worksheet that is displayed in the work area. (EX 10)
Adjacent range
All cells touch each other and form a rectangle. (EX 10)
Cell
The intersection of a row and a column. (EX 6)
Cell reference
Identifies the cell, and is formed by combining the cell's column letter and row number. (EX 6)
Column
Appears vertically and is identified by letters at the top of the worksheet window. (EX 6)
Formula
An equation that calculates a new value from values currently in a worksheet. (EX 6)
Formula Bar
Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value. (EX 6)
Landscape orientation
A page turned so that its longer side is at top. (EX 18)
Microsoft Excel 2010 (Excel)
The spreadsheet program in Microsoft Office 2010. (EX 4)
Name Box
Cell reference area located below the Ribbon, displays the cell reference of the active cell. (EX 6)
Nonadjacent range
Includes two or more adjacent ranges and selected cells. (EX 11)
Portrait orientation
A page turned so that its shorter side is at top. (EX 18)
Range
A group of selected cells. (EX 10)
Range reference
How the range is identified; made up of the cell in its upper-left corner and the cell in its lower-left corner, separated by a colon. (EX 10)
Row
Appears horizontally and is identified by numbers on the left side of the worksheet window. (EX 6)
Sheet tab
Tab at the bottom of the worksheet window that displays the name of the worksheet. (EX 6)
Spreadsheet
A grid of rows and columns in which you enter text, numbers, and the results of calculations. (EX 4)
Workbook
The file used to store worksheets. (EX 4)
Worksheet
A computerized spreadsheet. (EX 4)
Align
You can align the contents of a cell horizontally and vertically within the cell. (EX 29)
Auto Fit
Determines the best width for a column or the best height for a row, based on its contents. (EX 27)
Border
A line around a cell's edges. (EX 37)
Cell style
A collection of formatting characteristics you apply to a cell or range of data. (EX 42)
Clear
Removes formatting applied to a cell or a range of cells. (EX 43)
Column heading
The column letter. (EX 26)
Fill
Background color. (EX 36)
Font
The design of text. (EX 33)
Font size
Determines the height of characters as measured in points. (EX 33)
Font style
Using effects such as bold, italic, and underlining to add emphasis to a font. (EX 34)
Format Painter
Enables you to copy formatting from one worksheet cell to another without copying the cell's contents. (EX 40)
Indent
Shifted to the right. (EX 30)
Live Preview
Shows the results of the different formatting options you can choose. (EX 33)
Merge
Combine into one cell. (EX 30)
Number format
Change the way data looks in a cell. (EX 39)
Orientation
Changing the angle at which the data is displayed. (EX 31)
Points
A unit of measurement for font height. (EX 33)
Row heading
The row number. (EX 27)
Style
Combination of formatting characteristics such as alignment, font color, and borders. (EX 42)
Theme
Preset collection of design elements. (EX 33)
Truncate
Hidden from view. (EX 32)
Wrap text
When the row height adjusts automatically to include additional lines until all the text is visible. (EX 32)
Automatic page break
Excel inserts this whenever it runs out of room on a page. (EX 67)
Copy
Duplicates the cell's contents without affecting the original cell. (EX 54)
Cut
The selected cell contents are placed as an item on the Clipboard and are removed from their original location. (EX 54)
Fill handle
Appears in the lower-right corner of the active cell or range, and is used to fill cells. (EX 57)
Filling
Copies a cells contents and/or formatting into an adjacent cell or range. (EX 57)
Footer
Text that prints in the bottom margin of each page. (EX 70)
Freeze pane
You select rows and/or columns to remain visible on the screen as the rest of the worksheet scrolls. (EX 61)
Header
Text that prints in the top margin of each page. (EX 70)
Manual page break
Insert this manually to start a new page. (EX 67)
Margins
Blank spaces around the top, bottom, and sides of a page. (EX 66)
Normal view
View used when entering and formatting data in a worksheet. (EX 66)
Office Clipboard (Clipboard)
A temporary storage area for up to 24 selections you copy or cut. (EX 54)
Page Break Preview
Shows you the location of page breaks and allows you to change them easily. (EX 68)
Page Layout view
View that is helpful when you prepare a worksheet for printing. (EX 66)
Paste
Places the last item from the Clipboard into the cell or range selected in the worksheet. (EX 54)
Print area
Consists of the cells and ranges designated for printing. (EX 67)
Print title
Designated rows and/or columns in a worksheet that print on each page. (EX 69)
Scale
Enables you to resize a worksheet to print on a specific number of pages. (EX 68)
Split
Divides the worksheet window into two or four panes that you can scroll independently. (EX 62)
Argument
The value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand. (EX 100)
Date and time functions
Functions that are used to insert dates and times in a worksheet. (EX 112)
Financial functions
Functions used to analyze loans and investments. (EX 107)
Formula Auto Complete
As you begin to type a function name, this feature shows a list of functions below the active cell. (EX 102)
Function
Shorthand way to write an equation that performs a calculation. (EX 100)
Logical functions
Functions that display text or values if certain conditions exist. (EX 110)
Mathematical functions
Functions, such as the square root and rounding functions that manipulate quantitative data in a worksheet. (EX 103)
Statistical functions
Functions used to describe large quantities of data. (EX 105)
Text functions
Functions that are used to format and work with cell contents. (EX 113)
Trigonometric functions
Functions, such as the natural logarithm, that manipulate quantitative data in a worksheet. (EX 103)