Working with Spreadsheets

Spreadsheets help you organize and calculate information, particularly numeric information. For example, you can use a spreadsheet to keep track of personal finances, do a cost-benefit analysis on a new purchase, lay out a schedule, or create a simple inventory.

The spreadsheet’s workspace is a large grid of rows and columns in which you enter data, formulas, and other information. Numbered rows and lettered columns define cells, which are the intersection of a particular row and column (such as cell A1, the top left cell in the spreadsheet). You can have over 16,000 rows and 700 columns in a gobeProductive spreadsheet, for a total of approximately 11,500,866 cells.

This topic describes:

• Spreadsheet Concepts

• Spreadsheet Tools

• Setting the Worksheet Size

• Spreadsheet Navigation and Selection

• Formatting Cells, Rows, and Columns

• Using Formulas and Functions

• Performing Calculations

• Changing Display Options