A workbook is a collection of worksheets. A worksheet is composed of cells arranged in columns and rows. Values and formulas can be entered in cells, allowing calculations an references to other cells in the same worksheet or in worksheets in another workbooks. A cell can be referenced by its address, composed of row and column notation or by a defined name. A cell range is a group of cells.
There can be multiple workbooks opened at the same time. Each workbook corresponds to a file opened with the Spreadsheet Editor. Cell data, formulas, formatting and specific information such as printing and calculation attributes are saved in each workbook file.
The main function performed by workbooks is entering, ordering, and calculating data processing information stored in worksheet cells. Using formulas and built-in functions, data can be evaluated and calculated obtaining fast and accurate results.
|