Discuss the merits and demerits of excel spreadsheet
Answers
Answer:
Explanation:Advantages:
1. Sent through Emails
Excel can be sent through email and viewed by most
smartphones which makes more convenient .
2. Part of Microsoft Office
Excel is a part of the Microsoft office which comes with most
PC so there is no need to purchase or install it.
3. An All in One Program
Excel is an all in one programme and does not need the addition
of financial subsets.
4. Availability of Training Programs and Training Courses
There is training programs and even training courses to make
users more familiar with Excel.
5. Secure
Excel files can be password protected for extra security. A
user can create a password through Visual Basic programming or
directly within the Excel file.[1]
6. Easy connection to OLAP
Excel is capable of connecting directly to OLAP databases and
can be integrated in Pivot Tables.[2]
Disadvantages:
1. Viruses
Viruses can be attached to an Excel file through macros. Macros
are mini programs that are written into an Excel spread sheet.
[1]
2. Slow Execution
Using only one file can make the file size very big and as a
result the program might run slowly.
3. Loss of Data
So you might have to break it into smaller files, by doing so
there is an increased risk in Excel data being lost.
4. Hard to Use
Although there are training programs, it is still hard to use
and some users might not get the hang of it.
5. Space Limit
It limits the number of rows and columns you can use.