NEW
Font size
S
M
L
XL
WorksheetsDatabases and Spreadsheets
Total questions: 21
Worksheet time: 11mins
Name
Class
Date
1.
The four main objects of a relational database consist of:
a)
form, table, query, report
b)
form, table, database, query, report
c)
form, sort, table, query
d)
form, column, row, report
2.
I control data entry. I am also used for data entry.
a)
table
b)
query
c)
form
d)
report
3.
I can perform an advanced search. I am very similar to asking a detailed question.
a)
report
b)
query
c)
table
d)
form
4.
Which of the following is NOT an example of a database?
a)
telephone book
b)
Real Estate listing
c)
Online library card catalog
d)
DVD
5.
Which of the following objects is considered the basic building block of a relational database?
a)
form
b)
query
c)
table
d)
report
6.
All of the information about 1 entry is know as...
a)
A Field
b)
A Record
c)
A Table
d)
A Field
7.
1 bit of information about all entries in the database is know as...
a)
A Row
b)
A Field
c)
A Table
d)
A Record
8.
Each item from this list is classified as...
Name
Birthdate
Street
City
Postcode
a)
table
b)
record
c)
field
d)
entry
9.
A Primary Key is something that...
a)
Uniquely Identifies a record in a database
b)
Identifies a record in the database
c)
Identifies a record in a database
d)
is the main key for a door
10.
Which is the best example of a primary key?
a)
Driver's License Number
b)
Home Runs Hit
c)
Price
d)
First and Last Name
11.
Data _____ helps ensure that an incorrect entry isn't made.
a)
validation
b)
checks
c)
accuracy
d)
Verification
12.
A range of cells which goes vertically down the worksheet is known as...
a)
Range
b)
Column
c)
Row
d)
Table
13.
An individual box within a worksheet is known as?
a)
square
b)
range
c)
refernce
d)
cell
14.
Which of the following would NOT be stored in a cell?
a)
Formula
b)
Text
c)
Number
d)
Chart
15.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
16.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
17.
To start a formula, you must start with...
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
18.
Putting cells into A-Z order is called?
a)
Sort Ascending
b)
Sort Descending
c)
Filter Ascending
d)
Filter Descending
19.
Which function is a correct example of division?
a)
=B3/B6
b)
B3/B6
c)
=SUM(B3/B6)
d)
B3*B6
20.
What does cell A1 contain?
a)
Sweet
b)
Mars
c)
A1
d)
Cost
21.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
Reset
