what is Features of spreadsheet software - Basic Programming Knowledge

what is Features of spreadsheet software

February 14, 2019

Features of spreadsheet software
There is some features

                             

  • ·         Calculation
  • ·         Recalculation
  • ·         Chart
  • ·         Auto Fill
  • ·         Sorting
  • ·         Filter
  • ·         Auditing
  • ·         Printing
  • ·         Auto Complete in spreadsheet


Calculation
Spreadsheet software provides the facility to perform different types of
calculations using formulas and functions.
Recalculation
Recalculation is an important and powerful feature of spreadsheet
software. The results are automatically recalculated when there is any
change in the worksheet data.
Chart
 Charts are the graphical representation of data. Spreadsheet software
provides different types of charts. The data in can be viewed and
understood by the users easily.
 Auto Fill
Auto Fill is used to automatically fill cell with a series of numbers and dates etc.
Sorting
Sorting is the process of arranging your data in a particular order. You can
sort the data in your worksheet in ascending or descending order.
Filter
Filter allows to display the required data in a worksheet by giving a
criteria. Remaining data is hidden temporarily. For example, you can
display the records of passed student.
Auditing
This feature allows the user to find the cells used in a formula. Spreadsheet
software display arrows to all cells, which are used in that formula.
Printing
Spreadsheet software provides printing facility. The user can print the
documents to get a hard copy. Printing can be of whole document or of
any range.
Auto Complete
This feature is used to complete data automatically. If you are typing a
word in a cell that has already been used in another cell, it can be
completed automatically.