SPREADSHEET Archives | School Portal NG

SPREADSHET TERMINOLOGIES 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. ROW: is defined as the horizontal space that is going across the window. Numbers are used to designate each ROW’s location. COLUMN: is defined as the vertical space that is going up and down the window. Letters are used to designate each COLUMN’s location. 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. 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. 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. 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 SPREADSHEET FORMS OF DATABASE DATABASE DIGITAL LITERCAY DIGITAL LITERACY