**SPREADSHET TERMINOLOGIES**

is a space in a worksheet formed by the intersection of a row and a column. An active cell is the cell that is currently worked upon. E.g cell G7 is the active cell the above diagram.__A cell__

: is defined as the horizontal space that is going across the window. Numbers are used to designate each ROW’s location.__ROW__

: is defined as the vertical space that is going up and down the window. Letters are used to designate each COLUMN’s location.__COLUMN__

: formulas allow the spreadsheet users to do calculations with figures. The inclusion of formula has made the application unique. Formulas are group of characters we enter that serve as instruction for the spreadsheet package to perform calculations on the data is a spreadsheet.__FORMULAS__

Example, **C4= A4+F5 ** would calculate and display the sum of cell **A4** and cell **F5** into cell **C4**.

: spreadsheet packages have another important feature called ranges. A range is simply a block cells. Formulas can act on a single cell or be directed to act on a range of cells. For example__RANGES__**A4:E4**includes the cell**A4, B4, C4, D4**and**E4**. Any calculation performed in**A4**will also be performed in others cells.

: functions are actually used as shortcuts when perfoeming mathematical calculations. They are pre-programmed formula that give power and flexibility to spreadsheet calculations. Example__FUNCTIONS__**AVERAGE, SUM, MAX, MIN**etc.

__ __

**LOADING SPREADSHEET PACKAGES**

### MICROSOFT EXCEL PACKAGE.

** **

**Starting Worksheet (Using Microsoft Excel)**

Loading is the act of opening a program in order to use it. So to load Microsoft Excel, we follow these steps

- Click
**Start**button - Click
**All Programs** - Click
**Microsoft Office** - Click
**Microsoft Office Excel**

** **

**GENERAL EVALUATION**

- Highlight the procedures for loading Microsoft Excel program
- What do you understand by an active cell?
- What is row in database?
- What is the relationship between row and column?
- List THREE terminologies and explain briefly.
- What is cell?

**WEEKEND ASSIGNMENT**

- …………….. is simply a block cells. A. Formula B. Range C. Function D. None
- ……………… are actually used as shortcuts when performing mathematical calculations. A. Formula B. Range C. Function D. None
- …………… allows the spreadsheet users to do calculations with figures. . A. Formula B. Range C. Function D. None
- All except one is not an example of spreadsheet programs. A. Lotus 1-2-3 B. Supercal C. Visicalc D. Ms Word.
- Analysis is made with which of these applications. A. Ms word B. Ms access B. spreadsheet programs. D. All

** **

**THEORY**

- Highlight the procedures for loading Microsoft Excel program
- What is a cell?

**See also**