What are the main features of a spreadsheet like MS-excel ? Explain with examples !!!?

Question

this is a question from ICAI ET of information technology (India)

Answer 1

http://office.microsoft.com/en-us/FX010858001033.aspx <

Answer 2

A spreadsheet software is designed to accomplish regular computation projects utilising spatial relationships extremely than time through fact the accepted organizing thought. Many courses designed to accomplish regular computation use timing, the ordering of computational steps, as their accepted thank you to establish a software. A nicely defined get admission to element is was once certain the 1st instructions, and all different instructions might desire to be handy from that element. In a spreadsheet, although, a collection of cells is defined, with a spatial relation to a minimum of one yet another. interior the earliest spreadsheets, those preparations have been an basic 2-dimensional grid. over the years, the variety has been prolonged to incorporate a 0.33 length, and each so often a chain of named grids. the main stepped forward examples enable inversion and rotation operations which could slice and challenge the information set in different strategies. The cells are functionally resembling variables in a sequential programming variety. Cells frequently have a formula, a collection of instructions which will nicely be utilized to compute the cost of a cellular. formula can use the contents of alternative cells or exterior variables such through fact the present date and time. it rather is as a rule handy to think of of a spreadsheet as a mathematical graph, the place the nodes are spreadsheet cells, and the sides are references to different cells laid out in formula. it rather is as a rule referred to as the dependency graph of the spreadsheet. References between cells can income from spatial innovations inclusive of relative place and absolute place, to boot as named places, to make the spreadsheet formula much less complicated to appreciate and take care of. Spreadsheets often attempt to directly replace cells whilst the cells on which they matter have been replaced. The earliest spreadsheets used trouble-free methods like comparing cells in a definite order, yet present day spreadsheets compute a minimum recomputation order from the dependency graph. Later spreadsheets additionally incorporate a limited potential to propagate values in opposite, changing source values so as that a definite answer is reached in a definite cellular. through fact spreadsheet cells formula at the instant are not frequently invertable, nevertheless, this technique is of particularly limited value. many of the innovations common to sequential programming fashions have analogues interior the spreadsheet worldwide. for occasion, the sequential variety of the listed loop is often represented as a table of cells, with comparable formula.

Answer 3

The only thing I have used it for is to add up cells in the spreadsheet with a formula or autosum. Simple math where you can change a cell's value and the whole spreadsheet changes as values are recalculated.

Answer 4

It's potential is ENOURMOUS!!!! You must go to some form of Tutorial and it will at least give you the basics. Video Professor will help but I'm sure you can find others. The program itself I believe does have one. Definately go there. Good Luck!!!!

Answer 5

Here are some good resources to help you :)

http://en.wikipedia.org/wiki/Spreadsheet
http://j-walk.com/ss/

Answer 6

Do the research yourself - that's why it's been assigned.