Introduction

Spreadsheet is a piece of paper.spreadsheet consists of rows and columns, where one can enter data. An electronic spreadsheet is a software package that lets one enter data values, calculate, manipulate, and analyze set of data. It helps in organizing data, performing calculations and analyzing it and producing the result. Electronic spreadsheet is faster, more efficient and precise as compared to the manual worksheets.



 Various Spreadsheet Software                    

There are many spreadsheet packages available in the market. Some popular ones are lotus 1-2-3, Excel, Quattro Pro, Multiplan, PFS: Plan and VP Planner etc.



Feature of spreadsheet.                                 

Features are the fundamental things that make a spread sheet a good choice for financial modeling. Characteristics are the fine details of a particular spreadsheet package that make life easier for you. Here are some useful characteristics of a good spreadsheet. 

Can sort data:A spread- sheet can sort.  the data stored in it. It is good for making it easier to find individual data.                        

Absolute and relative referencing: It make setting  up formula easier. 


 User interface forms:  It is good to load input values into the model.                  

Macro  languages support

Automatic recalculation

Conditional formatting

Import/Export support

Searching and filtering

Pivot table

Replication

Database lookup

Worksheet supported

Graphing


No comments:

Powered by Blogger.