Term | Definition |
Excel 2010 | The spreadsheet program in Microsoft Office 2010 |
spreadsheet | A grid of rows and columns in which you enter text, numbers, and the results of calculations |
Worksheet | A computerized spreadsheet in Excel |
Workbook | The file used to store worksheets; usually a collection of related worksheets |
Active Worksheet | The worksheet that is displayed in the work area |
Row | The horizontal placement of cells in a table or worksheet |
Column | A vertical stack of cells in a table or worksheet |
Cell | The intersection of a column and a row in a table or worksheet |
Active Cell | The cell in the worksheet in which you can type data |
Name Box | The cell reference area located below the Ribbon, which displays the cell reference of the active cell |
Cell Reference | A unique identifier for a cell, which is formed by combining the cell’s column letter and row number |
Range | A group of selected cells |
Range Reference | The unique identifier for a range, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a colon |
Formula | An equation that calculates a new value from values currently in a worksheet |
Formula Bar | The box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value (or the results of a formula) |
Column Heading | column letter displayed at the top of the Excel window |
Row Heading | row number displayed at the left of the Excel window |
Autofit | determines the best width for a column or the best height for a row, based on its contents |
Alignment | specifies where data is lined up within a cell |
Indent | changes the space between the cell border and its content, moving text several places to the right or left |
Orientation | rotates cell contents to an angle or vertically |
Wrap Text | moves data to a new line when the cell is not wide enough to display all the contents |
Merge | combines multiple cells into one cell |
Merge and Center | combines several cells into one cell and centers the data in the merged cell |
Font | the design of text |
Font Size | determines the height of characters |
Font Styles | features that can add emphasis to text |
Font Color | the color of the text |
Fill Color | the background cell color behind the text |
Cell borders | lines around the edges of a cell |
Cell Style | a combination of formatting characteristics which can be applied simultaneously to the contents of a cell, saving you time |
Filling | copies a cell’s contents and/or formatting into an adjacent cell or range |
Fill Handle | appears in the lower-right corner of the active cell and can be used to fill adjacent cells |
Print Area | the portion of the worksheet selected to be printed |
Scaling | allows you to resize the worksheet to print on a specific number of pages |