Spreadsheets

Kellie Roth

Spreadsheets

Spreadsheets are a great way to chart, format, enter, and manipulate data. Its a very good way to keep all of your information organized. You can also change the colors too!

Rows and Collumns

Rows are vertical pieces of information identified by letters. Columns are horizontal pieces of information identified by numbers. A range is a group or block of cells in a spreadsheet that have been selected or highlighted.

Cell and Active Cell

A cell is an intersection point of a column and row. An active cell is the cell with a blue boarder around it. The active cell is the one that is going to be affected next.

Cell Reference

A cell reference identifies the location a cell or group of cells in the spreadsheet. Sometimes referred to as a cell address, a cell reference consists of the column letter and row number that intersect at the cell's location.

Making a tittle

To make a tittle you put the tittle in the first cell on the fist row. Then highlight the cells you want effected, click merge, and then align text to center. This will make a tittle at the top of your spreadsheet.

Quick keys

In a spreadsheet, you can have it automatically solve math problems.

By doing =sum(range) it will create a total of the numbers in your range.

By doing =average(range) will figure the average of your numbers for you.

By doing=min(range) will find the smallest number in your data.

By doing =max(range) will find your largest number in your data.

These are just some keys that will help you out.

Also by going to the bottom right of an active cell, your mouse will become cross hairs, click down and when released will copy all of the active cell's data into those cells. Or it will find the totals, averages,etc.