| A | B |
|---|
| active cell | the cell into which you can enter data |
| AutoCalculate area | to easily obtain a total, an average, or other information about the number in a range using this area |
| AutoCorrect feature | works behind the scenes, correcting common mistakes when you complete a text entry in a cell |
| Cancel box | click to cancel an entry |
| cell | the intersection of each column and row. The basic unit of a worksheet into which you enter data |
| cell reference | the coordinates of the intersection of a column and a row |
| column heading | the column letter above the grid, identifies each column |
| copy area | the same as source areas, the cell being copied |
| destination area | the range of cells receiving the copy |
| Dialog Box Launcher | when clicked displays a dialog box or a task pane |
| Edit mode | Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell |
| embedded chart | a chart drawn on the same worksheet as the data |
| Enter | Excel is in the process of accepting data through the keyboard into the active cell |
| Enter box | click to complete an entry |
| Excel Help | you can find answers to questions and display information about various topics |
| file | a saved workbook |
| file name | the name assigned to a file when it is saved |
| fill handle | the small black square located in the lower-right corner of the heavy boarder around the active cell |
| folder | a specific location on a storage medium |
| font size | specifies the size of the characters on the screen |
| Font style | indicates how the characters are emphasized |
| font type | or font face, defines the appearance and shape of the letters, numbers, and special characters |
| format | a worksheet to emphasize certain entries and make the worksheet easier to read and understand |
| formula bar | Excel displays the entry here as you type |
| gridlines | the horizontal and vertical lines on the worksheet itself |
| hard copy | a printed version of the worksheet |
| in-cell editing | you can edit the contents directly in the cell |
| in-Ribbon | a gallery that shows common gallery choices on the Ribbon rather than in a dropdown list |
| Insert mode | Excel inserts the character and moves all characters to the right of the typed character one position to the right |
| insertion point | a blinking vertical line that indicates where the next typed character will appear |
| Keyboard indicators | shows which toggle keys are engaged |
| Left-aligned | the cell entry is positioned at the far left in the cell |
| legend | identifies the colors assigned to each bar in the chart |
| merging cells | involves creating a single cell by combining two or more selected cells |
| Microsoft Office Excel 2007 | a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites |
| Mini toolbar | appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet |
| Mode indicators | appear on the status bar and specify the current mode of Excel |
| Name box | Excel also displays the active cell reference here |
| normal view | the default (preset) view |
| number | can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e |
| Office Button | a central location for managing and sharing workbooks |
| Overtype mode | Excel overtypes, or replaces, the character to the right of the insertion point |
| paste area | the same as destination area, the range of cells receiving the copy |
| printout | another name for hardcopy, a printed version of the worksheet |
| Quick Access Toolbar | provides easy access to frequently used commands |
| Ready | Excel is ready to accept the next command or data entry |
| relative reference | when you copy cell references, Excel automatically adjusts them for each new position, resulting in the SUM function entries; the adjusted cell reference |
| requirements document | includes a needs statement, source of data, summary of calculations, and any other special requirements for the worksheet, such as charting and Web support |
| Ribbon | located near the top of the Excel window, is the control center in Excel; provides easy, central access to the tasks you perform while creating a worksheet |
| row heading | the row number on the left side of the grid, identifies each row |
| scroll bars, arrows, and boxes | used to move the worksheet window around to view different parts of the active worksheet |
| sheet tab | where the name of the worksheet is displayed, at the bottom of the workbook |
| shortcut menu | appears when you right-click an object, a list of frequently used commands that relate to the right-clicked object |
| snaps | align the edge of the chart area to the worksheet gridlines |
| source area | the cell being copied |
| splitting a merged cell | the opposite of merging cells |
| status bar | presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel |
| tab split box | used to increase or decrease the view of the sheet tabs |
| text | any set of characters containing a letter, hyphen (as in a telephone number), or space |
| Theme | a collection of cell styles and other styles that have common characteristics, such as a color scheme and font type |
| to select a cell | to make the cell active |
| workbook | a collection of worksheets; like a notebook, inside are sheets, each called a worksheet |
| worksheet | allows users to enter, calculate, manipulate, and analyze data such as numbers and text; found inside a workbook. Excel opens a new workbook with three worksheets |
| worksheet window | the portion of the worksheet displayed on the screen |
| y-axis or value axis | the vertical axis |
