Please enable JavaScript.
Coggle requires JavaScript to display documents.
spreadsheet (features (Visual Design
Spreadsheets allow you to lay…
spreadsheet
features
- Visual Design
- Spreadsheets allow you to lay figures out on a grid, calculating and manipulating them visually.
-Often, this may result in you being able to process the information more quickly.
2. Automatic Calculations
- Spreadsheet software gives you the ability to enter mathematical formulas ranging from simple arithmetic to complex statistics.
-This is often a much faster way to perform calculations with your data than a calculator would be.
**
3. Data Analysis**
-gives you the ability to analyze your data in ways other than simply looking at grids and lines.
-Most spreadsheet software can automatically create graphs and charts from your data, giving you different ways of comparing and analyzing information
-
-
-
Disadvantages
Easy to Fraud
The main underlying reason behind this spreadsheet vulnerability is the inherent lack of controls, which makes it so easy to alter either formulas, values, or dependencies without being detected.
-
-
Security
Spreadsheets are not that secure and therefore are at greater risk for data corruption or mismanagement of information. Since, there is no log access of users, users can easily alter the information without being noticed.
advantages
1.Efficiency
- You need only enter values, variables and formulas into a spreadsheet once to calculate results.
2.Formatting.
-The appearance of every part of the spreadsheet lies under your total control. You can specify the font style and size used for numbers and text, define the border width and cell size of tables, add images, and color everything with a
brilliant palette.3. Security.
-A spreadsheet can secure sensitive data from prying eyes by revealing a file only with a correct user code and password. It can hide individual cells, like those showing wholesale cost, depending on users, like customers. It can also lock numbers and formulas so they are not accidentally erased during data entry.
-
-
-