Spreadsheets Flashcards

1
Q

What are computer models used for?

A

To predict how devices behave in certain situations

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

What does a what if scenario tell us?

A

The results of different scenarios

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

Validation is

A

The checking of data by software to see if is reasonable/accurate

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

Verification

A

The checking of data by humans

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

Rows are numbered: True or False?

A

True

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

Columns are not lettered: True or False?

A

False

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

Spreadsheets can be used to

A

Display, store, calculate data

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

What is used to identify a cell?

A

Cell reference

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

What is the order in a cell reference?

A

Letter then number

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

What does a formula always start with?

A

Equals sign

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

Charts in a spreadsheet don’t have to be titled: True or False?

A

False

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

What symbol suggests an absolute cell reference?

A

$ the dollars sign

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

Can tabs be assigned colours in spreadsheets?

A

Yes

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

Sort means

A

Arranging data in order

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

What is a macro?

A

A small program that can be written by an user inside a spreadsheet

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

What is a cell?

A

A singular rectangular box in a spreadsheet