Fall Final: Excel Terms
Terms in this set (79)
The cell in the worksheet in which you can type data.
The worksheet that is displayed in the work area.
All cells touch each other and form a rectangle.
The intersection of a row and a column.
Identifies the cell, and is formed by combining the cell's column letter and row number.
Appears vertically and is identified by letters at the top of the worksheet window.
An equation that calculates a new value from values currently in a worksheet.
Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.
A page turned so that its longer side is at top.
Microsoft Excel 2010 (Excel)
The spreadsheet program in Microsoft Office 2010.
Cell reference area located below the Ribbon, displays the cell reference of the active cell.
Includes two or more adjacent ranges and selected cells
A page turned so that its shorter side is at top.
A group of selected cells.
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.
Appears horizontally and is identified by numbers on the left-side of the worksheet window.
Tab at the bottom of the worksheet window that displays the name of the worksheet.
A grid of rows of rows and columns in which you enter text, numbers, and the results of calculations.
The file used to worksheets
A computerized spreadsheets
You can align the contents of a cell horizontally and vertically within the cell.
Determines the best width for a column or the best height for a row, based on its contents.
A line around a cell's edges.
A collection of formatting characteristics you apply to a cell or range of data.
Removes formatting applied to a cell or range of cells
The column letter
The design of the text
Determines the height of characters as measured in points.
Using effects such as bold, italic, and underlining to add emphasis to a font.
Enables you to copy formatting from one worksheet cell to another without copying the cell's contents.
Shifted to the right.
Shows the results of the different formatting options you can choose
Combine into one cell
Change the way the data looks in a cell.
Changing the angle at which the data is displayed.
A unit of measurement for font height.
The row number.
Combination of formatting characteristics such as alignment, font color, and borders.
Preset collection of design elements.
Hidden from view.
When the row height adjusts automatically to include additional lines until all the text is visible.
Automatic Page Break
Excel inserts this whenever it runs out of room on a page.
Duplicates the cell's contents without affecting the original cell.
The selected cell contents are placed as an item on the clipboard and are removed from their original location.`
Appears in the lower-right corner of the active cell or range, and is used to fill cells.
Copies a cells contents and/or formatting into an adjacent cell or range.
Text that prints in the bottom margin of each page.
You select rows and/or columns to remain visible on the screen as the rest of the worksheet scrolls.
Text that prints in the top margin of each page.
Manual Page Breaks
Insert this manually to start a new page.
Blank spaces around the top, bottom, and sides of a page.
View used when entering and formatting data in a worksheet.
Office Clipboard (Clipboard)
A temporary storage area for up to 24 selections you copy or cut.
Page Break Preview
Shows you the location of page breaks and allows you to change them easily.
Places the last item from the clipboard into the cell or range selected in the worksheet.
Consists of the cells and ranges designated for printing.
Designated rows and/or columns in a worksheet that print on each page.
Enables you to resize a worksheet to print on a specific number of pages.
Divides the worksheet window into tow or four pages that you can scroll independently.
The value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.
Date and Time Functions
Functions that are used to insert dates and times in a worksheet.
Functions used to analyze loans and investments.
As you begin to type a function name, this feature shows a list of functions below the active cell.
Shorthand way to write an equation that performs a calculation.
Functions that display text or values if certain conditions exist.
Functions, such as the square root and rounding functions that manipulate quantitative data in a worksheet.
Functions used to describe large quantities of data.
Functions that are used to format and work with cell contents.
Functions, such as the natural logarithm, that manipulate quantitative data in a worksheet.
Absolute Cell Reference
Does not change when copied or moved to a new cell.
Lets you determine when Excel calculates the formulas.
Mixed Cell Reference
Cell references that contain both relative and absolute references.
A constant (text or number) or cell reference used in a formula.
A symbol that indicates the type of calculation to perform on operands.
Order of Evaluation
The sequence used to calculate the value of a formula.
Allows you to point and click each cell in a formula rather than typing cell references.
Relative Cell Reference
Adjusts to its new location when copied or moved.
Makes adding long columns or rows of numbers simple to do.