Spreadsheets Flashcards

1
Q

Benefits of using spreadsheets are…x4

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Costs of using spreadsheets are…x3

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Named cells allow…

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Absolute replication…

A

Safe guards cells and used when multiplying the same cell repeatedly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Wrap text makes…

A

Longer headings and titles neater

How well did you know this?
1
Not at all
2
3
4
5
Perfectly