click below
click below
Normal Size Small Size show me how
Excel Lesson 1 & 2
Lesson 1 & 2
| 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 |