LIS 505 - Spreadsheets and graphs
Recalculation of the values of all (dependent) cell values
whenever a value changes.
A way of using a spreadsheet to make predictions
by changing certain items of data
and seeing how other items are affected.
Boxes into which data can be entered,
each representing the intersection of a row and a column.
The cell into which data can currently be entered.
Descriptive texts placed in cells.
Expressions in cells
that define how they relate to other cells.
Named sets of instructions
each of which returns a value
function references are used in constructing formulas.
Sets of one or more contiguous cells
forming a rectangular shape.
Charts that highlight trends by drawing lines between data points.
Intersecting reference lines in a coordinate system,
used to plot numbers on a chart.
The horizontal axis is the x axis
and the vertical axis is the y axis.
Charts in which different values are represented by rectangular bars.
Also called bar graphs.
Charts in which proportions are represented
by different sized slices of a circle.
Pie charts in which one or more of the component slices
are shown slightly separated from the rest.
Last updated October 29, 2002.
This page maintained by
Prof. Tim Craven
E-mail (text/plain only): email@example.com
Faculty of Information and Media Studies
University of Western
Canada, N6A 5B7