##### Spreadsheets

Spreadsheet/Workbook

A grid of rows and columns containing numbers, text, formulas, and calculations

Microsoft Excel

Application program used to create spreadsheets

Row

Horizontal cells up and down a spreadsheet- represented by numbers (1,2,3)

Column

Vertical cells across a spreadsheet- represented by letters (A,B,C)

Cell

Where a row and column intersect (A1,C3,D10)

Active Cell

The cell your cursor is in

Sheet

One page in a workbook

Range

A section of the spreadsheet identified by beginning cell and ending cell (C1:G10)

AutoFit

Adjusts the size of rows or columns to fit the data within those rows or columns

Auto Fill

Click and drag the AutoFill button to automatically copy from one cell to several others

Mathematical Operators (+-*/)

Used to create formulas and calculations

Formula

Use cell addresses and mathematical operators to create a formula - starts with =

Functions

A special formula Excel has craeted for you

SUM: Adds numbers in a range

AVERAGE: Averages numbers in a range

MAX: Finds the highest(max) number in a range

MIN: Finds the lowest(minimum) number in a range

COUNT: Counts the number of cells in a range that contain a number

Relative Address

Cell references (addresses) change as the formula is copied (A4 or C)

Absolute Address

Cell references (addresses) do not change as he formaula is copied. Use the $ in front of a cell, row, and/or column address to make it absolute ($A$4 or $A4 or A$A)

Sort

Changing the order of information

Ascending- from A to Z, 0 to 1, or low to high

Descending- from Z to A, 9 to 1, or high to low

Chart or Graph

A visual representation of data

X-Axis

Usually the horizontal axis, usually left to right-shows the topics of the values

Y-Axis

Usually the vertical axis, usually top to bottom- shows the range of values

Legend

Key for interpreting the chart's colors, patterns, etc.