Advantages and Disadvantages in Spreadsheet/Excel

Advantages and Disadvantages in Spreadsheet/Excel

Short Introduction of spreadsheet

A worksheet also called a spreadsheet, is an electronic sheet made up of rows and columns. It is used for planning a project or checking financial position of an organization.



Advantages of Spreadsheet



The advantages of using spreadsheets are as follows :

  • In excel 2007 , many built in function do the complex calculations easily.
  • Large volume of data can be handled easily.
  • A graphical representation of data is possible . With the help of graph and charts data can be interpreted easily.
  • Useful information can be imported or exported from/to other software packages , such as Word and PowerPoint .
  • If entries are changed , then formulas automatically calculate the new results.


Disadvantages of Spreadsheet



The Disadvantages of using spreadsheet are as follows :

  • It requires very large memory of a computer to perform complicated calculation and to plot graphs.
  • It has limited number of rows and columns in one worksheet. If user has more data to enter then he has to shift data in another worksheet that may create confusion.
  • It requires skilled user because small mistake in formula will give absurd results.

Comments

Follow me :-     Twitter             Youtube