1
5050
15
1 Million
14
500,000
Who Wants to be a Millionaire?
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
2
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
3
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
All the houses in Church Row
9
16,000
8
8,000
7
4,000
B Have two bedrooms
6
2,000
5
1,000
4
500
3
300
2
200
5050
1
100
are the same price
A
B have two bedrooms
D were sold by Pinson Pinson
C were sold in November
4
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
5
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
To list this so that the cheapest appears first,
the user should
9
16,000
8
8,000
7
4,000
6
2,000
A ascending on Property Address
5
1,000
4
500
3
300
2
200
5050
1
100
A ascending on Property Address
B descending on Property Address
C descending on Price
D ascending on Price
6
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
7
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
The search criterion to find all properties over
200,000 is
9
16,000
8
8,000
7
4,000
6
2,000
B Pricegt200,000
5
1,000
4
500
3
300
2
200
5050
1
100
B Pricegt200,000
A Pricelt200,000
D Price200,000 and over
C Price200,000
8
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
9
15
1 Million

14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
To include telephone numbers in the database, the
user should
9
16,000
8
8,000
7
4,000
6
2,000
A add a new field
5
1,000
4
500
3
300
2
200
5050
1
100
A add a new field
B add a new record
C create a new database
D enter telephone numbers with the estate
agents names
10
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
11
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
To keep the data confidential the user should
9
16,000
8
8,000
7
4,000
6
2,000
B put a password on the file
5
1,000
4
500
3
300
2
200
5050
1
100
A back-up the file frequently
B put a password on the file
C print the file
D save the file
12
Congratulations!
Congratulations!
Congratulations!
Youve Reached
the 1,000
Milestone!
13
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
14
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
The search criterion to find the properties sold
by Denton is
9
16,000
8
8,000
7
4,000
6
2,000
A Estate AgentDenton
5
1,000
4
500
3
300
2
200
5050
1
100
B Property CodegtDenton
A Estate Agent Denton
D Pricelt183,000
C Date Soldgt01/10/02
15
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
16
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
To find all the properties in Church Row, the
user would need to use
8
8,000
7
4,000
6
2,000
DFindChurch Row
5
1,000
4
500
3
300
2
200
5050
1
100
A a wildcard
B a search engine
D FindChurch Row
C AgentDenton
17
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
18
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
The data type of the Property Address field is
8
8,000
7
4,000
6
2,000
A text
5
1,000
4
500
3
300
2
200
5050
1
100
A text
B date
C number
D currency
19
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
20
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
To show the number of seats NOT sold, the user
should
8
8,000
7
4,000
6
2,000
B Insert a column
5
1,000
4
500
3
300
2
200
5050
1
100
B Insert a column
A Insert a row
D Increase column width
C Increase row height
21
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
22
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
The criterion that would find all collectors
whose Last Name is Galpin is
8
8,000
7
4,000
6
2,000
B Last NameGalpin
5
1,000
4
500
3
300
2
200
5050
1
100
A First NameKaty
B Last NameGalpin
D Last NameHolly Galpin
C First NameGalpin
23
Congratulations!
Congratulations!
Congratulations!
Youve Reached
the 32,000
Milestone!
24
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
25
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
The amount collected by Katy Wilson is
9
16,000
8
8,000
7
4,000
6
2,000
A 424.16
5
1,000
4
500
3
300
2
200
5050
1
100
A 424.16
B 299.16
C 90.45
D 37.70
26
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
27
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
There is an error in Katy Wilsons next
collection date, this is an error in the cell
9
16,000
8
8,000
7
4,000
6
2,000
D content
5
1,000
4
500
3
300
2
200
5050
1
100
A format
B spelling
C formula
D content
28
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
29
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
To include collector addresses in the database
the user should
9
16,000
8
8,000
7
4,000
6
2,000
A add a field with data type text
5
1,000
4
500
3
300
2
200
5050
1
100
B add a field with data type number
A add a field with data type text
C put the address in with the Postcode
D delete Age column and insert Address
30
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
31
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
The search criterion to find those collectors who
have made more than 4 collections is
9
16,000
8
8,000
7
4,000
B Number of Collections gt4
6
2,000
5
1,000
4
500
3
300
2
200
5050
1
100
A Number of Collections 4
B Number of Collections gt4
C Number of Collections lt4
D Number of Collections 4, 13
32
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
9
16,000
8
8,000
7
4,000
6
2,000
5
1,000
4
500
3
300
2
200
1
100
33
15
1 Million
14
500,000
13
250,000
12
125,000
11
64,000
10
32,000
To list the database in A-Z order of Last Name,
the user should sort
9
16,000
8
8,000
7
4,000
6
A ascending on Last Name
2,000
5
1,000
4
500
3
300
2
200
5050
1
100
A ascending on Last Name
B ascending on First Name
C descending on Last Name
D descending on First Name
34
YOU WIN 1 MILLION POUNDS!