Spreadsheet Application

1
Spreadsheet Application

• An application program that mimics a physical
  spreadsheet (a sheet of paper) by showing data in
  rows and columns
• Electronic spreadsheet
• Columns are alphabetic Rows are numeric
• Cells hold data
• They are the intersection of rows columns

2
Spreadsheet Program

• Cell are labeled according to placement
• C10 A5, G20
• Cells designed to hold numeric or short text
  strings
• Cells may be referenced relative or absolute
• Data may be displayed graphically

3
Spreadsheet Program - Principles

• Several mathematical principles at work
• Commutative Law
• Result of an operation combining 2 quantities is
  independent of the order they take
• A B B A and A x B B x A
• and - are commutative

4
Spreadsheet Program - Principles

• Distributive Law
• One operation is independent of the other whether
  it comes before or after another operation
• X(Y Z) XY XZ
• x is distributive wrt addition and subtraction!

5
Spreadsheet Program

• Associative Law
• The value of an expression is independent of the
  groupings, symbols or terms in the expression
• Addition and multiplication are associative
• (x y) z (x z) y
• x(yz) (xy)z.

6
Spreadsheet Program

• Offers limited capabilities to label and
  structure data
• If numeric data is processed, it offers limited
  querying capability
• It is a lite database program