This preview shows page 1. Sign up to view the full content.
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.
For creating and tracking personal budgets, loan payments, etc. by
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.
Column Range. It is used to include a set of adjacent cells...
View Full Document
This document was uploaded on 04/07/2014.
- Spring '14