##### 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

column

Vertical cells across a spreadsheet represented by letters

Cell

Where a row and column intersect

Active cell

The cell your cursor is in

Sheet

one page in a work book

Range

A section of the spreadsheet identified by beginning cell and ending cell

Auto Fit

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

Mathematical operations

used to create formulas and calculations

Formula

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

Functions

SUM

AVERAGE

MAX

MIN

COUNT

A special formula Excel has created for you

Adds number in a range

finds the highest number in the range

finds the lowest number in the range

Counts the number of cells in a range

Relative Address

Cell references change as the formula is coppied

Absolute Adress

Cell references 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

Ascending

Descending

Changing the order of information

From A to Z , 0 to 1 , or low to high

From Z to A , 9-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 show the range of the values

Legend

Key for interpreting the charts colors, patterns, etc,