SPREADSHEET

SPREADSHEET

A spreadsheet interactive computer application program for organization, analysis and storage of data in tabular form. A spreadsheet application is a computer program such as Excel, open office Cacl, or Google Docs spreadsheets. An electronic spreadsheet is a computer program that is used for storing, organizing and manipulating data.

 

A spreadsheet is a software package used for modeling data for the purposes of budgeting, planning, monitoring accurate record keeping, calculation, policy formulation, sensitivity analysis and decision making.

Examples of spreadsheet package

  1. Microsoft Office Excel
  2. Stat view spreadsheet
  3. Apple works spreadsheet
  4. Quattro pro
  5. Microsoft Works spreadsheet
  6. Easy office spreadsheet
  7. Lotus 123
  8. Plan maker spreadsheet
  9. Xoom office spreadsheet
  10. Visicalc

Uses of Spreadsheet

  1. Budgeting
  2. Inventory control
  3. Preparation of daily sales
  4. Examination results
  5. Lists
  6. Accounting
  7. Database use
  8. Profit and loss analysis
  9. Balance sheet preparation

Features and terminologies of spreadsheet

  1. Title Bar: It contains programs name and file name.
  2. Tool Bar: Groups of icons on bars that can perform common commands quickly.
  3. Work Area: Large white area in middle of window where work appears.
  4. Row: The horizontal (side by side) division in a spreadsheet. They are named with number 1 to 1,048,576
  5. Column: The vertical divisions in a spreadsheet. They are named with an alphabet letter A to Z and then continuing with AA, AB, AC, etc.
  6. Cells: The intersection of columns and rows that contain the data for each record.
  7. Database: A database is a collection of data which is organized in a manner that can be easily stored and retrieved.
  8. Tables: The view that displays the database as a combinations of rows (records) and column (fields)
  9. Field: Field is the smallest piece of data in a table. Fields are displaced in columns.
  10. Records: A collection of all fields relating to one person, place, or thing occupying a single row of a table.
  11. File: is a collection of related records in a table

 

Evaluation

  1. What is spreadsheet package
  2. Mention the uses of spreadsheet
  3. List the features of spreadsheet

 

You May also read

ICT Gadget

ICT as a transformational tool

Simple Basic Program

The Paint

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Get Fully Funded Scholarships

Free Visa, Free Scholarship Abroad

           Click Here to Apply

Acadlly