Spreadsheets and Business Graphics
Facts and Figures
Electronic Spreadsheet
- A computerized version of a manual spreadsheet, consisting of columns and
rows of related numbers.
- Common uses: analysis, budgeting, and forecasting.
- First Microcomputer spreadsheet - VisiCalc on Apple II in
1979.
Cells and Cell Addresses
- A spreadsheet is divided into rows and columns, each labeled with a number
or a letter.
- The intersection of a row and a column forms a cell .
Contents of Cells
- A label provides a description of entries in the spreadsheet.
- A value is a number entered into a cell to be used
in calculations.
- A formula is an instruction to the program to perform
a calculation.
- A function is a preprogrammed formula.
Common Spreadsheet Features
- Copy or move the contents of one cell or a range of cells
into another location.
- Insert or delete a row or a column.
- Format the rows or columns to take a desired form.
- Print an entire spreadsheet or a part of a spreadsheet.
- Use windows to look at two parts of a big spreadsheet.
- Include functions that perform specialized operations.
- Perform a series of operations using macros.
Graphics
- Show words and numbers and data in ways that are meaningful and quickly
understood.
Line Graphs
- Useful for showing trends or cycles over the same period of
time.
- The horizontal line, or x-axis, normally represents units of time,
such as days, months, or years.
- The vertical line, or y-axis, usually shows measured values or amounts,
such as dollars, etc.
Bar Graphs
- Also useful for showing trends or cycles over the same period
of time.
Pie Charts
- Useful for showing how various values make up a whole.