Spreadsheets

Question 1

Benefits of using spreadsheets are…x4

Answer 1

Using formulas to complete calculations quickly
Using data to create charts which is good for comparison
Easy to share, collaboratively through email
Different formatting can be used- template

Question 2

Costs of using spreadsheets are…x3

Answer 2

Difficult to use- need to be trained to understand cells and formulas
Element of human error- means there could be mistakes e.g. deleted cells, formulas are incorrect
System crashes, corrupted systems from viruses

Question 3

Named cells allow…

Answer 3

Information to be used from a specific cells on another worksheets and placed on another

Question 4

Absolute replication…

Answer 4

Safe guards cells and used when multiplying the same cell repeatedly

Question 5

Wrap text makes…

Answer 5

Longer headings and titles neater