LIS 505 - Spreadsheets and graphs

spreadsheets

automatic recalculation

Recalculation of the values of all (dependent) cell values whenever a value changes.

what if

A way of using a spreadsheet to make predictions by changing certain items of data and seeing how other items are affected. ComputerUser

cells

Boxes into which data can be entered, each representing the intersection of a row and a column.

active cell

The cell into which data can currently be entered.

labels

Descriptive texts placed in cells.

formulas

Expressions in cells that define how they relate to other cells.

functions

Named sets of instructions each of which returns a value . In spreadsheets, function references are used in constructing formulas.

ranges

Sets of one or more contiguous cells forming a rectangular shape.

presentation graphics

line graphs

Charts that highlight trends by drawing lines between data points.

axes

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. ComputerUser

bar charts

Charts in which different values are represented by rectangular bars. Also called bar graphs.

pie charts

Charts in which proportions are represented by different sized slices of a circle.

exploded pie charts

Pie charts in which one or more of the component slices are shown slightly separated from the rest.
Home

Last updated October 29, 2002.
This page maintained by Prof. Tim Craven
E-mail (text/plain only): craven@uwo.ca
Faculty of Information and Media Studies
University of Western Ontario,
London, Ontario
Canada, N6A 5B7