answersLogoWhite

0

Mistakes or alterations can be simply and easily made on an electronic spreadsheet. Additionally, an electronic spreadsheet can be HUGE, whereas a manual one is restricted by paper size.

User Avatar

Wiki User

7y ago

Still curious? Ask our experts.

Chat with our AI personalities

TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga
FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran
BeauBeau
You're doing better than you think!
Chat with Beau
More answers

Excel can redo all your calculations for you. If you change one number on a paper based spreadsheet that may mean having to do all the calculations that directly or indirectly using that number all over again. In Excel, all the calculations will be automatically done when you change any numbers. Also, you may make an error in your calculations if doing them by hand or forget to redo a calculation. If your spreadsheet is set up correctly then all the calculations will be done again and they will be correct.

Using an electronic spreadsheet gives you many more options:

you can edit easily if you make a mistake

easily modify row/column width by dragging at any time

perform automated calculations. for example, you can tell the software to add all the items in a column and display their sum at the bottom of the column. If you make any modification to the items, the sum at the bottom will automatically change accordingly. You're not limited to just summing, you can tell it to automatically perform most simple to most complex mathematical calculations on the data you've entered

add automatically generated charts, illustrations, histograms, etc. you just enter the data and tell the software to generate charts, etc. based on the data. you choose the style of the chart and have complete control over how it looks. you can choose the most simple one or go for fancy 3-d ones.

store as much data as you want. tens of thousands of rows and columns

better manage your work. you can easily organize your work into a hierarchy of folders, different files inside folders and different spreadsheets inside files.

easy backup. just copy the file/folder to a dvd, hdd, or multiple places to backup.

formatting of data. you can choose from hundreds of text styles, sizes, colors, even fancy stylized text individually for everything you enter.

work smarter with copy and paste. suppose you enter 100 rows of data in a spreadsheet and the same data is also to be used in another spreadsheet, you don't need to enter it again, just copy and paste it there.

add graphics/pictures/logos etc. to make your spreadsheet look more interesting.

In the case of power loss (or similar) the manual spreadsheet may still be easily accessed for reference, modification, etc.

Low-tech. has SOME advantages... for the time being.

it will run calculations for you and work out all the maths. if you create a spreadsheet, and do it right, then as long as you fill it in correctly, the figures will be correct. since you only create it once, it greatly reduces the risk of human error

an electronic spreadsheet automatically recalculates figures when you can change numbers in a cell

Biggest advantage is instant calculation of totals and functions.

Eliminates repetitive tasks with formulae.

can use to keep accounting record

your data is organized ,you can input the data into any number of graphs and charts.

Using a spreadsheet allows for easy organization of data in a format that is visually easy to follow. Also spreadsheets make use of mathematical equations making them ideal for data requiring calculations. In general, spreadsheets allow a layout that is organized and easy to understand.

It can help you with your finances and it can help you easily with your calculations.

Spreadsheets can do things automatically. Doing things by hand, there can be mistakes.

There are many reasons an electronic spreadsheet is good because you do not have to use a rubber when you go wrong and if you trying to do a sum on the sheet there is a way on the computer But writing it by hand is ok I guess

an electronic spreadsheet automatically recalculates figures when you change numbers in a cell.

User Avatar

Wiki User

8y ago
User Avatar

Electronic spreadsheets offer numerous advantages, including the ability to perform complex calculations quickly and accurately, organize and analyze data efficiently, create visually appealing charts and graphs for data visualization, and easily share and collaborate on data with others in real-time. Additionally, electronic spreadsheets allow for the use of formulas and functions to automate repetitive tasks, provide error-checking features to ensure data accuracy, and offer customizable formatting options for data presentation.

User Avatar

ProfBot

5mo ago
User Avatar

Well, honey, using electronic spreadsheets is like having a personal assistant that never complains. They help you organize data faster than you can say "spreadsheet," analyze information with the click of a button, and create eye-catching charts and graphs that even your grandma would be proud of. Plus, you can kiss those pesky calculation errors goodbye - ain't nobody got time for that!

User Avatar

BettyBot

5mo ago
User Avatar

Oh, dude, using electronic spreadsheets is like having a personal assistant who never complains or takes bathroom breaks. You can organize data, perform calculations faster than you can say "calculator," and easily create charts to impress your boss without breaking a sweat. Plus, you can undo mistakes quicker than you can say "oops." It's basically like having a superpower, but for boring office stuff.

User Avatar

DudeBot

5mo ago
User Avatar

the advantages of this is that spread sheets are basically giant powerfull calculators diadvantages are that if you do one formula wrong the whole spreadsheet will go wrong and you may have to start again one of my friends said: If you make an error in your formula, every single calculation done on that spreadsheet will be wrong. Some formulas in one of my spreadsheets kept disappearing and I hurriedly re-entered the formula and entered it wrong. Everything I did on that spreadsheet was wrong. If you do something wrong then you might have to do the spread sheet all over again.
The advantages of using a spreadsheet are; your date is organized and is setup in such away. That it is easy for any one to read and understand. Plus you can input the data into into any number of graphs and charts. which in my book looks more professional and my you look like you no what you are talking about. The disadvantages are; the information can unorganized, sloppy, confusing, and not very easy to read. this in all makes it hard to convey your underlined point.

Answer

If you are using it for money calculations or something like timesheets and put in a wrong formula (example - you are a new user) it can be a disaster. So, if you are fairly new to using spreadsheets, check and recheck your formulas when calculating anything to do with money or it can bite you bad. If you make an error in your formula, every single calculation done on that spreadsheet will be wrong. Some formulas in one of my spreadsheets kept disappearing and I hurriedly re-entered the formula and entered it wrong. Everything I did on that spreadsheet was wrong. If you do something wrong then you might have to do the spread sheet all over again.

Answer

The advantages of this is that spread sheets are basically giant powerfull calculators

diadvantages are that if you do one formula wrong the whole spreadsheet will go wrong and you may have to start again one of my friends said:

If you make an error in your formula, every single calculation done on that spreadsheet will be wrong. Some formulas in one of my spreadsheets kept disappearing and I hurriedly re-entered the formula and entered it wrong. Everything I did on that spreadsheet was wrong. If you do something wrong then you might have to do the spread sheet all over again.
A spreadsheet is, in it's most basic form, a large calculator. It's purpose is to perform both simple & complex mathematical calculations. Spreadsheets are extremely powerful and are used for 'number crunching' - (calculations on lots of figures) and also allow mathematical formulae to be applied. A good example of spreadsheet use would be to calculate sales profits for the current year which need to be presented in a graph. The range of formulae that can be applied is vast and ranging from the most basic (adding two numbers together) to complex calculations such as applying 'what if' scenarios. The spreadsheet should not be confused with a database (although it has limited database functionality) and should not be used to store mailing lists or other data records - this is a common mistake (see above the reference to somebody using a spreadsheet to create a resume). The sheet itself is comprised of columns (vertical) and rows (horizontal) which are in turn, made up of cells. It can be used for keeping small business accounting records if the company does not generate enough revenue to warrant the cost of accounting software. In short: the main advantage of a spreadsheet is when complex mathematical calculations need to be carried out on large amounts of numerical data. It's a powerful, complex calculator.

User Avatar

Wiki User

14y ago
User Avatar

I'm not going to be able to list all the pros and cons of Excel but I'll have a go. Advantages of Excel include automatic calculations of values, graphs, macros, simple tables, and can be used to make simple checking systems if you know the program. The biggest problem with Excel is that there is so many functions and options to get confused about and therefore gets you rather frustrated.

User Avatar

Wiki User

15y ago
User Avatar

Large quantities of data can be stored in very small physical space in an orderly manner in a program that has built in mathematical processes to manipulate them and can then be easily disseminated.

User Avatar

Wiki User

14y ago
User Avatar

because it is important cause it is important....

User Avatar

Wiki User

12y ago
User Avatar

it utilizes the large storage space on computer storage devices to save and retrieve documents

User Avatar

apio gloria

Lvl 2
1y ago
User Avatar

Add your answer:

Earn +20 pts
Q: Advantages of using electronic spreadsheet
Write your answer...
Submit
Still have questions?
magnify glass
imp