Spreadsheets Flashcards

1
Q

List five cell formats.

A
  1. Short date
  2. Time
  3. Text
  4. Numeric
  5. Currency
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

An absolute cell reference is a cell reference which…

A

does not change if the formula is copied down a column or across a row

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

An absolute cell reference is made by surrounding the column reference with…

A

dollar signs

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

An advantage of using a wizard to produce a graph is that it guides…

A

the user through the process, showing the result of each stage

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

An advantage of using a wizard to produce a graph is that it offers…

A

a number of options to the user in each step

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

It is important to test a spreadsheet to ensure that it meets…

A

user requirements

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

It is important to test a spreadsheet to ensure that formulas…

A

work

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

It is important to test a spreadsheet to ensure that data validation rules…

A

work correctly

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

It is important to test a spreadsheet to ensure that graphs produced appear…

A

as expected

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

It is important to test a spreadsheet to ensure that recalculations are…

A

automatic when a value in a cell is changed

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

List three aspects of a spreadsheet that should be tested.

A
  1. Formulas
  2. Data validation rules
  3. Graphs
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

It is important to evaluate a spreadsheet to consider how well the spreadsheet…

A

uses functions and formulas

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

It is important to evaluate a spreadsheet to consider whether graphs…

A

enhance the presentation of results

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

It is important to evaluate a spreadsheet to consider particular…

A

areas for improvement in the spreadsheet

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

To ensure results produced on a spreadsheet are accurate, the spreadsheet should be…

A

tested fully, worksheet by worksheet

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

To ensure results produced on a spreadsheet are accurate, appropriate use of … should be made

A

functions and formulas

17
Q

To ensure results produced on a spreadsheet are accurate, …. should be used

A

appropriate data validation rules