| A | B |
|---|
| spreadsheet | grid of rows/ columns containing numbers/ text/ formulas that are used to solve problems that involve numbers |
| columns | appear vertically; identified by letters at top of spreadsheet |
| rows | appear horizontally; identified by numbers at left of spreadsheet |
| cell | intersection of lettered column/ numbered row |
| CellAddress | name used to refer to a cell (C3) |
| CellReferenceBox | left of formula bar; identifies active cell |
| CellSelector | heavy black outline that surrounds the active cell |
| ActiveCell | current cell; default = A1 |
| FormulaBar | displays a formula when the cell contains a calculated value; appears below the toolbar to the right of cell address box |
| Text | aligned to left in cell |
| Numbers | aligned to the right in cell |
| value | numbers, dates, time |
| chart | graphical representation of data contained in spreadsheet |
| BarChart | rectangles of varying heights; shows relationships among categories of data |
| LineChart | points connected by a line; illustrates trends of data over time (3-D0 |
| PieChart | relationship of a part to a whole (1 category) |
| ScatterChart | relationship between two categories of data; "cloud" of unrelated data |
| FillHandle | copies contents of cell into adjacent cells; lower right corner of active cell |
| formula | calculates a value stored in cells |
| operators | addition, subtraction, multiplication, division |
| AutoSum | automatically totals a column/ row of values |
| FreezingTitles | keeps column titles on screen |
| function | built-in shortcut for entering a formula |
| GoTo | F5 |
| ProtectingCells | prevents anyone from inadvertently making changes |
| range | block of adjacent cells |
| RangeAddress | cell address for the upper-left cell, colon, cell address for the lower-right cell |
| workbook | spreadsheet file; name appears in title bar |
| worksheet | individual "pages" in a workbook |
| worksheet tab | displays name of worksheet; can be renamed |
