Transcript Short Course Revision - Burton Borough School

Short Course Revision
Spreadsheets,
Modelling and
Databases
Spreadsheets
Information going down in a
spreadsheet is called a _____?
a) Column
b) Cell
c) Field
d) Row
Information going across in a
spreadsheet is called a _____?
a) Record
b) Cell
c) Field
d) Row
The arrow is pointing to the
______________?
?
a) Chart wizard
b) Graph wizard
c) Chart maker
d) Autosum
What does a formula ALWAYS
begin with?
a) /
b) *
c) SUM
d) =
Which function would you use
to add a range of numbers?
a) ADD
b) MAX
c) SUM
d) MIN
Which would you use to
indicate a range of numbers?
a) -
b) :
c) ;
d) ?
Which formula would be used to
calculate how much the pencils
cost?
a) 4*0.5
b) =(b2*c2)
c) (b2*c2)
d) =sum(b2+c2)
To add together b2, b3, b4, b5 you
would use which FUNCTION?
a) b2+b3+b4+b5
b) =SUM(B2:B5)
c) =(b2+b3+b4+b5)
d) =ADD(B2:B5)
Cells can be formatted to
show….
a) number
b) currency
c) percentage
d) All of the above
Modelling
When we model data we….
a) copy
b) show
c) simulate
d) formulate
Modelling allows us to ask….
a) What if?
b) How come?
c) Where?
d) How much?
An advantage of modelling
data is that is often…..
a) cheaper
b) More accurate
c) predictable
d) Varied
Databases
When data is proof-read this is
known as_______?
a) validation
b) verification
c) checking
d) Data entry checks
When information has to be
entered twice this is known
as_________?
a) validation
b) verification
c) checking
d) Data entry checks
The columns going down in a
database are called?
a) fields
b) records
c) cells
d) tables
The rows going across in a
database are called?
a) fields
b) records
c) cells
d) tables
To search for specific data you
would use a_________?
a) search
b) query
c) question
d) sort
To put data in order you would
use?
a) sort
b) records
c) queries
d) tables
The validation rule to ensure that
information is not duplicated
a) Presence check
b) Primary key
c) Range check
d) Digit Check
The validation rule to ensure
that data is entered
a) Presence check
b) Primary key
c) Range check
d) Digit Check
The validation rule that would
ensure a price is less than £5000?
a) Presence check
b) Primary key
c) Range check
d) Digit Check