Work Book, Spreadsheet, Worksheet and Cell

Work Book, Spreadsheet, Worksheet and Cell

A workbook is just like a large document with multiple topics related to each other. A workbook may contain multiple worksheets. Each workbook is given a name, which is generally known as file name. A worksheet is a part of workbook, which is combination of rows and columns (cells). This is the part of workbook where user is directly involved in writing his data, modifying or saving his data. A worksheet is also known as spreadsheet because it is a very large sheet (many times larger than manual sheets). Generally, a worksheet may have 256 columns and 65536 rows. Columns are vertical cut of a worksheet, which are given name with alphabets like A, B, C,…….., AA, AB, IV etc. A Row is vertical cut of a spreadsheet, which are given name with numbers like 1, 2, 3,………., 65536 etc. A cell is the smallest unit of a worksheet, in which we actually write data. Cross section of rows and columns is called cell. Each of the cells in a worksheet are identified with their cell address, which is composed up of writing the columns name first and then row numbers (e.g. A1,B5 etc).

   

data validation

In computer science, data validation is the process of ensuring that a program operates on clean, correct and useful data. It uses routines, often called "validation rules" or "check routines", that check for correctness, meaningfulness, and security of data that are input to the system. The rules may be implemented through the automated facilities of a data dictionary, or by the inclusion of explicit application program validation logic.

For business applications, data validation can be defined through declarative data integrity rules, or procedure-based business rules. Data that does not conform to these rules must negatively affect business process execution. Therefore, data validation should start with business process definition and set of business rules within this process. Rules can be collected through the requirements capture exercise.

The simplest data validation verifies that the characters provided come from a valid set. For example, telephone numbers should include the digits and possibly the characters +, -, (, and) (plus, minus, and parentheses). A more sophisticated data validation routine would check to see the user had entered a valid country code, i.e., that the number of digits entered matched the convention for the country or area specified.

Incorrect data validation can lead to data corruption or security vulnerability. Data validation checks that data are valid, sensible, reasonable, and secure before they are processed.

Data Filter

It is one of the facilities available in database package and is borrowed by spreadsheet package. We can see/filter only those rows/records, which match the given criteria. After the filter is on, each of the column/ fields will have a separate combo list. Whatever the condition we select from the List, the rows that match the given criteria will be displayed and others are hidden. It can be done by selecting the option ‘Data > Filter > >Auto Filter’ from menu.