SPREADSHEET PACKAGE: DEFINITION, EXAMPLES, APPLICATION AREAS AND BASIC ARITHMETIC OPERATORS (SS2)

                         SPREADSHEET PACKAGE

DEFINITION, EXAMPLES, APPLICATION AREAS, FEATURES AND TERMINOLOGIES, AND BASIC  ARITHMETIC OPERATORS

DEFINITION OF SPREADSHEET PACKAGE

1. A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form.

2. Spreadsheet is a computer program or software which allows calculations to be carried out on several cells that have numbers.

 

                  EXAMPLES OF SPREADSHEET PACKAGE

Common examples of spreadsheet package are:

1. iWork Numbers – Apple Office Suite
2. Lotus 1-2-3
3. OpenOffice – Calc
4. Lotus Symphony – Spreadsheets
5. Microsoft Excel
6. VisiCalc
7.SeaTable
8. AirTable
9.SmartSheet
10. LibreOffice
11. Google Sheets
12. Quip
13. JotForm Table
14. Zoho
15.EtherCalc
16. Stackby

APPLICATION AREAS OF SPREADSHEET PACKAGE

1. financial accounting

2. budget forecasts

3. result preparation.

4. keeping database

5. graphical analyses

6. automatic generation of schedule sheets through macros.

7. Accounting.

8. Statistical calculations.

9. Preparation of student results.

10. Obtaining tax estimation

Features and Terminologies of Spreadsheet

1. Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry. 
2. Cell: A cell is a rectangular area formed by the intersection of a column and a row.
3. Cell Reference: A cell reference is the name of the cell that is found by combining the Column Letter with the Row Number. For example the cell in Column "C" in Row "3" would be cell C3.
4. Column: Columns run vertically on the spreadsheet screen. An Excel spreadsheet contains 256 columns that are labeled with the letters of the alphabet.
5. Data: Data refers to the type of information that can be stored in the cells of a spreadsheet. Spreadsheet data types include values (numbers), labels, formulas and functions.
6. Formula: A formula is a spreadsheet data type that will calculate a result and display it in the active cell. A formula is written using cell references and must begin with an equal sign "=" to distinguish it from a label.
7. Formula Bar: The formula bar appears directly above the column headings of a spreadsheet and will display what has been typed into the active cell. For example, if you click on a cell that contains the formula =A3+C3, the cell itself will show the result of the formula.
8. Function: Functions are built-in formulas that are used to enter either commonly used or very complex formulas.
9. Gridlines: Gridlines are the horizontal and vertical lines on the screen that separate cells in a spreadsheet. 
10. Labels: Labels refer to text that is typed into the cells of a spreadsheet. Labels have no numeric value and cannot be used in a formula or function.
11. Name Box: The name box appears to the left of the formula bar and displays the name of the current cell. Unless you define a cell or range of cells with a specific name, the name box will display the cell reference of the active cell.
12. Range: A range is a group of cells in a spreadsheet that have been selected.
13. Rows: Rows run horizontally on the spreadsheet screen. An Excel spreadsheet contains 16,384 rows which are labeled numerically.
14. Sheet Tabs: In Microsoft Excel, the sheet tabs appear below the worksheet grid area and allow you to switch from one worksheet to another in a workbook.
15. Values: Values are numeric data that is entered into a cell.
16. Workbook: A workbook is a collection of worksheets that are saved together in one file.
17. Worksheet: A worksheet is a single page in the workbook.

Class Activities

1. Define Spreadsheet Package and list six (6) examples of spreadsheet package.

2. State five (5) application areas of spreadsheet package.

3. Explain any four (4) spreadsheet package terminologies.