Explain main features of an electronic spread sheet?
Answers
Answered by
0
1. Data management:
Efficient data management facilities may include features for data entry with data validation, rearranging data (sorting), finding and/or extracting a part of the data depending upon the requirement, cutting and pasting, classification of data in the form of frequency tables etc.
Most electronic spreadsheet packages offer facilities for performing the above operations with ease and without having to use complex commands/statements. Some of the commonly used facilities in this regard are as follows:
2. Cell definition:
Cell is the intersection of a row and a column in the spreadsheet. The contents of a cell may be defined with the help of a value (number), label (text), formula, date or time. In case of the need to enter a series of data, electronic spreadsheets facilitate automatic filling of a range of cells within the series. The user has to define the starting value, the incremental value, the terminal value and the range of cells that are to be filled with the series of values.
The electronic spreadsheets have facilities for Copying, Deleting, Moving, Erasing, and Inserting data. These facilities are available for all types of data including labels and formula and are similar to those available in word processors.
3. Display of data:
Most electronic spreadsheets maintain two layers of data. The first layer contains the data the way they were entered and modified. The other layer of data is for display of values. The display of data is done on the basis of the formatting specifications made by the user.
Once the data is ready, the predefined display format can be prescribed. For the purposes of computing values, the electronic spreadsheet uses the first layer.
For example, the values of sales for different branches of a company were specified to be displayed as rounded off to nearest thousands of rupees. However, while computing the sum of these sales values, the electronic spreadsheet shall use the values as they were originally entered.
Efficient data management facilities may include features for data entry with data validation, rearranging data (sorting), finding and/or extracting a part of the data depending upon the requirement, cutting and pasting, classification of data in the form of frequency tables etc.
Most electronic spreadsheet packages offer facilities for performing the above operations with ease and without having to use complex commands/statements. Some of the commonly used facilities in this regard are as follows:
2. Cell definition:
Cell is the intersection of a row and a column in the spreadsheet. The contents of a cell may be defined with the help of a value (number), label (text), formula, date or time. In case of the need to enter a series of data, electronic spreadsheets facilitate automatic filling of a range of cells within the series. The user has to define the starting value, the incremental value, the terminal value and the range of cells that are to be filled with the series of values.
The electronic spreadsheets have facilities for Copying, Deleting, Moving, Erasing, and Inserting data. These facilities are available for all types of data including labels and formula and are similar to those available in word processors.
3. Display of data:
Most electronic spreadsheets maintain two layers of data. The first layer contains the data the way they were entered and modified. The other layer of data is for display of values. The display of data is done on the basis of the formatting specifications made by the user.
Once the data is ready, the predefined display format can be prescribed. For the purposes of computing values, the electronic spreadsheet uses the first layer.
For example, the values of sales for different branches of a company were specified to be displayed as rounded off to nearest thousands of rupees. However, while computing the sum of these sales values, the electronic spreadsheet shall use the values as they were originally entered.
mridul2082:
mark brainliest
Answered by
1
a) Data management
b) Data analysis
c) Report generation and communication
Similar questions