 1. A cell 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.

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

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

1. FORMULAS: 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.

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

1. RANGES: 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 A4:E4 includes the cell A4, B4, C4, D4 and E4. Any calculation performed in A4 will also be performed in others cells.

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

### MICROSOFT EXCEL PACKAGE.

Starting Worksheet (Using Microsoft Excel)

• Click Start button
• Click All Programs
• Click Microsoft Office
• Click Microsoft Office Excel

## GENERAL EVALUATION

2. What do you understand by an active cell?
3. What is row in database?
4. What is the relationship between row and column?
5. List THREE terminologies and explain briefly.
6. What is cell?

## WEEKEND ASSIGNMENT

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

## THEORY

2. What is a cell?

FORMS OF DATABASE

DATABASE

DIGITAL LITERCAY

DIGITAL LITERACY

SUBSCRIBE BELOW FOR A GIVEAWAY

We built School Portal NG to specially serve as an alternative means to provide free education for the less-privileged children or children born to low-income earners, adults who otherwise cannot afford to finance their way through school.

Building & maintaining an elearning portal is very expensive, but this portal is free. Help to keep this learning portal free by donating or supporting us. We accept donations, grants, sponsorships & support to help reach out to more children. Thank you so much. Click here to donate