Terminologies Used In Spreadsheet

A spreadsheet is a digital grid or table used for organizing, analyzing, and manipulating data. It consists of rows and columns, where each intersection represents a cell.

Popular spreadsheet software includes Microsoft Excel, Google Sheets, and Zoho Sheet

Terminologies Used In Spreadsheet

1. Cell
   A Cell is intersection of a row and columns.
2. Active cell
   This is the current cell that is ready to accept data input from the user.
3. Row
   A horizontal collection of cells in an Excel sheet.
4. Column
   A vertical collection of cells.
5. Chart
   A graphical representation of data.
6. Sort
   Arranges data in ascending or descending order.
7. Filter
   Hides rows based on specific criteria.
8. A Work Book
   This is a collection of work sheets stored in the same file on a disk.
9. Work Sheet
   Is a tabular sheet organized in rows and columns on a computer on which problems are solved.
10. Range of cell
    A range is a group / block of cell in a work sheer that has been selected /highly lighted.
11. Cell Address
    This is the column and row address of a cell.
    In spread sheet we name cells by reading the position where a column letter intersects with a row number. Eg A1, B5, G4
12. Range of cell
    A range is a group / block of cell in a work sheer that has been selected /highly lighted.
13. Cell Address
    This is the column and row address of a cell.
    

    Trending

    Computer Laboratory

    In spread sheet we name cells by reading the position where a column letter intersects with a row number. Eg A1, B5, G4

14. Cell Reference
    There are basically three types of formula reference in spread sheet namely;
    • Relative Reference
      This is reference that changes when you copy a reference e.g. a formula =A2+A2 type in cell C2 will change when copied to cell C3 to be = A3+B3.
    • Absolute Reference
      This is a reference that does not change when you copy a formula.
      To make a cell reference absolute, type a dollar sign ($) before both column and row number E.g. ($A$7)
    • Mixed Reference
      A cell is mixed reference if a column does not change while the row does change or the column does not change while the row does not change when you copy the formula.

CELL CONTENT.

A cell can contain any of the following types of information

10. LABLE.

Provides descriptive information about entries in the spread sheet.

11. VALUE

Is an actual number entered in a cell to be used in calculations.

12. FORMULA

Is an instruction to a program to calculate a number or
An expression that calculates values based on cell references (e.g., =A1+B1).

13.FUNCTION

A predefined formula that performs specific calculations (e.g., SUM, AVERAGE).