Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Transcript of Spreadsheets
Formulae calculations (adding, subtracting, totalling, multiplying, dividing, calculating percentages, ect) are carried out almost instantaneously.
Calculation are done with total accuracy.
Formulae are amended automatically when the spreadsheet is amended (eg another row of data added)
Text, number and formulae can be copied easily and quickly across rows or down columns.
Data can be organised easily and quickly by sorting of filtering.
Numeric data can be displayed as graphs or charts.
While fraud will always be a threat to spreadsheet systems, there is a more significant threat that should make you seriously consider getting rid of these outdated systems. And that is its extreme susceptibility to even trivial human errors. Missed negative signs and misaligned rows may sound harmless.
As an organization grows, data in spreadsheet-based systems get more distributed; subsequently compounding the issues outlined above. It is absolutely not advisable for a large organization to keep using spreadsheets.
Of all the spreadsheet disadvantages listed here, this is perhaps the most damaging. Fraudulent manipulations in company Excel files have already resulted in Billion-Dollar losses.
A Spreadsheet is a software application which is used to manage numbers and carry out calculations. It contains text, numders and formulae which are keyed in on a grid of cells – set out as horizontal rows (indicated by numbers) and vertical columns (indicated by letters). A cell is the point at which a column and row intersect.
By Reese tod
Adding Data means keying in data into empty cells. new rows and columns can be inserted between existing rows and columns to allow data to be added.
Deleting data means permanently removing data from a single cell, range of cells, a complete row or complete column.
Editing data means altering the data, eg the sales figures for a salesperson (adding or deleting data can also be looked upon as editing).
How are changes made to a spreadsheet?
Spreadsheet data can be formatted - this facility acts similar way to that used in a data base.
Formatting data in a spreadsheet
What is a Spreadsheet?