9 or to enter descriptive data or titles to make the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: sons by business analysts. 3. For recording grades of students and carrying out various types of analysis of the grades by educator 4. For analyzing experimental results by scientists and researchers. 5. For tracking stocks and keeping records of investor accounts by stockbrokers. 6. For creating and tracking personal budgets, loan payments, etc. by individuals. This list is by no means exhaustive and is given here only to give an idea of how flexible and versatile tool is spreadsheet package. Commonly Supported Features An example of a sample spreadsheet is shown in Figure 15.9. Some of the key features of spreadsheet package are explained below with the help of this example. Rows and Columns A spreadsheet is organized in a tabular form with rows and columns. The rows are identified by numbers, whereas the columns are identified by letters. Single letters are used to identify the first 26 columns and double letters are used for subsequent columns (A, B, ..., Z; AA, AB, ..., AZ; BA, BB, ..., BZ; ...). A large spreadsheet may have hundreds of rows and hundreds of columns. Cells The intersection of a row and a column is called a cell. A cell is identified by its address, which is a combination of its column letter and row number (such as F4, C18). Data are stored in cells. Range of Cells Many spreadsheet operations involve a range of cells instead of a single cell. For instance, in Figure 15.9, the contents of cell E5 is equal to the sum of the contents of cells B5, C5 and D5, which is a range of three cells in a row. A range of cells may involve many cells and entering every individual cell for an operation to be performed on them may be cumbersome and time taking. To take care of this problem, all spreadsheet packages allow the use of following types of cell ranges: 1. Row Range. It is used to include a set of adjacent cells in the same row. For example, the range B5..D5 refers to the cells B5, C5 and D5. 2. Column Range. It is used to include a set of adjacent cells...
View Full Document

This document was uploaded on 04/07/2014.

Ask a homework question - tutors are online