Spreadsheet:-
A spreadsheet is a computer program that can capture, display and manipulate data arranged in rows and columns.Spreadsheets are one of the most popular tools available with personal computers.
Spreadsheet features:
Cell formatting
Formulas
Pivot tables
Spreadsheet controls:-
Spreadsheet controls are measures a business's accounting team uses to safeguard the integrity and accuracy of its bookkeeping practices and of financial records. It is an ongoing effort to rapidly detect and resolve errors and maintain the security of all data. Thorough training is important to the success of spreadsheet control programs.
Features of a spreadsheet control program should include:-
Up-to-date list of authorized users
Outgoing data accuracy checks
Incoming data accuracy checks
Storage provisions offsite
Backup/archiving redundancy, use of multiple media types
Data recovery procedures in place
Ease of use and flexibility
Strong encryption
Prevention of data loss/corruption through cross-referencing checksum processes
Scheduled archiving/incremental backup
Access control (usernames, passwords, biometrics)
Common spreadsheet applications:-
Lotus 1-2-3 surpassed VisiCalc to became the program that cemented the IBM PC as the preeminent personal computer in business during the 1980s and 1990s. IBM acquired Lotus in 1995 and continued selling Lotus 1-2-3 through 2013, when it discontinued the spreadsheet application, which had fallen behind Microsoft Excel in the '90s and never recovered.
