Because it gives much more room for people to create much larger spreadsheets that would take too much paper. That is one of the major advantages of an electronic spreadsheet. You can manipulate much larger amounts of data on an electronic spreadsheet. This makes them far more useful. There is so much that can be done on a large electronic spreadsheet that would be very difficult to do on a paper-based one.
beacause of the set out
There are two major advantages of using an electronic spreadsheet rather than a manual one: speed and accuracy. Using an electronic spreadsheet takes seconds to minutes to do what takes at least hours manually and the accuracy is not subject to human error provided the program is created accurately.When using an electonical spreed sheet you can type faster then writing.
Electronic spreadsheets are more convenient, because they are easier to edit. They also are easier to change cells and change information then paper based spreadsheets.
There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.
If the spreadsheet program is any good, the calculations based on the entries in the spreadsheet will always be correct. In manual spreadsheets, the calculation is only as accurate as the person performing the calculation and as accurate as that person is in transcribing the results of their calculation.Electronic spreadsheets do not occupy much space - just the space for the electronic storage media - thus you just need a decent hard drive to contain tens of thousands of spreadsheets instead of a room full of filing cabinets.Sending a copy of an electronic spreadsheet to someone else just requires an internet connection and can be done almost instantly compared to mailing or faxing a copy of a manual worksheetIt is fairly simple to link the contents of one (or more) spreadsheet to another to perform additional calculations compared to digging out all the manual worksheets that might be needed and transcribing the information repeatedly for each separate piece of information.
The whole basis of a spreadsheet's usefulness is its ability to recalculate all its formulas every time a change is made to any cell on the spreadsheet. This keeps the spreadsheet up to date when new values are put in. On a paper-based spreadsheet, one figure being changed requires that the user manually recalculates everything in their spreadsheet. An electronic spreadsheet will do it automatically, which is what is meant by automatic recalculation. There is an option to turn this off and have the spreadsheet only recalculate when the user hits a specified key, usually the F9 key. This enables the user to change a figure and then look at the existing figures before they are changed, to more easily note what changes occur when they recalculate. On an electronic spreadsheet manual calculation does not mean that the user has to do all the calculations themselves, as they would on paper, but just that they can tell the spreadsheet when to recalculate all formulas, rather than it being done every time they make a change to anything.
An electronic ledger is more specific than an electronic spreadsheet. With electronic ledgers and things like accountancy, payroll and stock control applications, they are all designed with a very specific task in mind. So a payroll package is no use for stock control for example. In each of them some of the work is already done for you and you tailor them to your needs. Things are automated so you can concentrate on the data more and leave a lot of the processing to the applications. An electronic ledger is limited to what it can do, as is a stock control, payroll and accounting package. An electronic spreadsheet starts off as being completely blank, leaving you a lot of work to do in order to get it doing what you want. However, you can use it to do a much wider range of tasks than any of the others, which is the big advantage. It would take a lot of work, but you can use an electronic spreadsheet to do things like ledgers, accounts, payroll and stock control.
It is because it is a electronic spreadsheet program. A spreadsheet in the traditional sense is a piece of paper with rows and columns that people use to write figures on and do calculations. In 1978 a business student named Dan Bricklin, thought that there should be a simpler way of doing them than on paper, as they were slow and tedious to use, especially when changes in the figures needed to be made. He got together with Bob Frankston who was a friend and a programmer. They created VisiCalc, the first electronic spreadsheet program. Many other spreadsheet programs were created by other people after that and Microsoft Excel is one of those.
Yes. The whole idea of an electronic spreadsheet is to be able to do things automatically by having formulas to work out calculations rather than you doing them manually.
10 advantage of using manual and electronic spreadsheet
Yes
They can be called fields, but that is more the case in a database than in a spreadsheet.