##### Spread Sheets ,

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 my #'s (1,2,3)

Colmn

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)

Auto Fit

Adjust 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 cell to several others

Mathematical Operators (+ - */)

Used to create formulas and calculations

Formula

Used cell addresses and mathematical operators to create a formula - start with =

Functions

A special formula Excel has created for you

SUM - Adds #'s in a range

AVERAGE - Averages #'s in a range

MAX - Finds highest (max) #'s in range

MIN - Finds lowest (minimum) #'s in a range

COUNT - Counts the # of cells in a range that contains a #

Relative Address

Cell reference change as the formula is copied (A4 or C6)

Absolute Address

Cell reference do not change as the formula is copied. Use the $ in front of a cell, row, and/or column address to make it absolute

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 - usually shows the topics of the values

Y-axis

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

Legend

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