Spreadsheet Applications

• Enter, manipulate, calculate, and chart data on worksheets.
• Workbook is a collection of worksheets.
• Rows run horizontally and are represented by numbers.
• Columns run vertically and are represented by letters.
• A cell is the intersection of a row and column.
• Use formulas and functions to perform calculations.

Spreadsheet programs have a wide range of uses. Every day, teachers, doctors, designers, and people in just about every profession use spreadsheet programs to enter, calculate, and chart data. A worksheet is an electronic version of an accountant's ledger and is the place you enter data. A workbook is the collection of all the worksheets in a file. Worksheets are made up of rows and columns—rows are designated by numbers and columns are designated by letters. A cell is the intersection of a row and a column. A cell address uses the column and row position of the cell as a name. Formulas and functions allow you to perform complex calculations on your data.