Introduction to Spreadsheet

Spreadsheet is one type of computer applications which is mainly used for number processing. Other uses include graphics display and list creation. There are many fields that use spreadsheet so intensively, such as finance, accounting, statistics, physics or even electronics (such as converting color bands to resistor value and vice versa)

Historically, two of the first spreadsheet applications ever available are VisiCalc (1979) and Lotus 1-2-3 (1983). Today, there are numerous spreadsheet applications being used, but the most familiar, yet prominent one is Microsoft Excel.

Spreadsheet differs from word processing in a way that it doesn’t use pages to store data, but tabular form, which consisted of rows, columns and cells.
Column is an individual vertical line spreading from top to bottom and is marked by a letter header (“A”,”B”,”C” and so on). So for an example in Figure 1, as indicated by blue arrows, there are three columns (“A” through “C”).
Row is an individual horizontal line spreading from left to right and is marked by a number header (“1″,”2″,”3″, and so on). Looking back at Figure 1, as pinpointed by red arrows, there are four rows (“1″ through “4″).
Cell is an intersection or “junction” between a column and a row and is referenced by an address, which is a combination of the designated column and row header. So for an active cell (the highlighted one) in Figure 1, its address is B3. The cell is located on the second column (“B”) and third row (“3″).

Column, Row and Cell

Figure 1. Column, row and cell

 

 

 

 

 

That tabular form itself is called a worksheet and is actually a part of the file, or a workbook. A workbook may contain one or more worksheets. See Figure 2.

Worksheet and Workbook

Figure 2. Three worksheets in a workbook

3 thoughts on “Introduction to Spreadsheet”

  1. i wanted to thank you for this great read!! i am definitely enjoying every little bit of it i have you bookmarked to check out new stuff you post. thanks for all.

Leave a Reply