Databases and spreadsheet

Question 1

Which of the following is NOT true of databases?

Accepted Answer

1

Question 2

Which of the following is a piece of software used to create databases?

Accepted Answer

2

Question 3

What term describes a personalised letter which can be sent to customers of a supermarket?

Accepted Answer

0

Question 4

Which of the following is an advantage of paper-based databases?

Accepted Answer

2

Question 5

Thinking of data, information and knowledge - which of the following is an example of information?

Accepted Answer

0

Question 6

Which of the following holds a single piece of data?

Accepted Answer

2

Question 7

Which field would be inappropriate in a database of countries?

Accepted Answer

0

Question 8

What is the correct definition of primary key?

Accepted Answer

1

Question 9

What database feature checks to see if data meets certain rules when entered to a table?

Accepted Answer

0

Question 10

Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?

Accepted Answer

0

Question 11

Which of the following is NOT capable of producing a spreadsheet?

Accepted Answer

2

Question 12

What word is used to describe re-organising the order of data?

Accepted Answer

1

Question 13

In a cell reference, for example A1, what does the letter refer to?

Accepted Answer

1

Question 14

Formulae must always start with which symbol?

Accepted Answer

0

Question 15

Which of the following tasks would a spreadsheet be best used for?

Accepted Answer

2

Question 16

Which tool is best used to duplicate information from cell to cell?

Accepted Answer

1

Question 17

Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?

Accepted Answer

2

Question 18

Wrap text is an option which can be applied to cells in order to do what?

Accepted Answer

2

Question 19

The software can help guide us through the process of creating a chart. This is called a...?

Accepted Answer

1

Question 20

What term describes changing the horizontal or vertical position of text?

Accepted Answer

0