click below
click below
Normal Size Small Size show me how
tech app spreadsheet
Term | Definition |
---|---|
absolute cell reference | does not adjust to the new cell location when copied or moved |
active cell | the cell that is highlighted |
address | the location of a cell on a grid as identified by its coordinates |
cell | the intersection of a row and column in a spreadsheet |
column | the vertical divisions of a grid |
column chart | illustrates data using bars of varying height |
coordinate | the row and column designations that define a cell location on a grid |
data series | group of related info in a column or row of a worksheet that will be plotted on a chart |
forecast | to calculate the effect of change before the change takes place; to make financial predictions |
formula | a math equation using values from the spreadsheet, numbers, and/or symbols |
grid | a series of evenly spaced horizontal and vertical lines that intersect each other |
labels | data that appear in alphabetic numbers that cannot be manipulated mathematically |
line chart | illustrates relationships with a line that connects data points used to show trends over time |
pie chart | illustrates data in a circle that shows the relationships of part of a whole |
range | selected group of cells |
relative cell reference | adjusts to new location when copied or moved |
row | the horizontal divisions of a grid |
spreadsheet program | an app. program used in financial forecasting |
spreadsheet | a grid of rows and columns that can hold numbers, formulas, or text |
values | data that appear in the form of numbers that can be manipulated mathematically |