Intro to M.I.S. - Excel Spreadsheets (Day 1)

Today we learned that anything thing you need can be found free online suchas: Open Office,Google Docs, which are like Microsoft office.

Excel Spreadsheets - Microsoft Excel 2007

How to total columns:

Highlight Cell

Click Auto Sum

Click enter

We also learned how to use the fill handle.

To use the fill handle:

Click on the cell

In the corner click the black X

Drag to fill all of the columns totals

To generate totals:

Highlight cell

Drag down

Then click auto sum

To center & merge:

Drag cell all the way across spreadsheet

Click on merge & center under alignment

To add dollar signs & columns:

Click under numbers

Click down arrow

Go to accounting

To add a chart to spreadsheet:

Highlight what you want charted,

Click insert

Click columns

Note to self on spreadsheets: Columns = X-axis, Rows = Y-axis