wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Test 2 Data Capture

Total questions: 25

Worksheet time: 50mins

Name
Class
Date
1.

What is the purpose of a form?

a)

Create a report

b)

Enter data one record at a time

c)

Preview data for query

d)

Create data types for a table

2.

Which of the following is not a data type used in the structure of creating a table?

a)

query

b)

date/time

c)

lookup wizard

d)

currency

3.

Which of the following is NOT a section included in a report design?

a)

Details

b)

Report Header

c)

Navigation Pane

d)

Page Footer

4.

What is the heading or a title to one piece of information called?

a)

formula

b)

record

c)

field name

d)

table

5.

What icon on the Database Tools ribbon does this represent?

a)

run macro

b)

compact and repair

c)

object dependencies

d)

SharePoint

6.

What icon on the Database Tools ribbon does this represent?

a)

object dependencies

b)

database documenter

c)

Sharepoint

d)

analyze table

7.

What icon on the Database Tools ribbon does this represent?

a)

database documenter

b)

relationships

c)

object dependencies

d)

access database

8.

What icon on the Database Tools ribbon does this represent?

a)

relationships

b)

access database

c)

analyze table

d)

add-ins

9.

What icon on the Database Tools ribbon does this represent?

a)

access database

b)

relationships

c)

compact and repair

d)

run macro

10.

What icon on the Database Tools ribbon does this represent?

a)

sharepoint

b)

analyze table

c)

access database

d)

relationships

11.

What icon on the Database Tools ribbon does this represent?

a)

add-ins

b)

relationships

c)

analyze table

d)

visual basic

12.
Which of the following data might a business learn from its customers: 
a)
Data about traveling expenses
b)
Financial data about competitors 
c)
Market share data
d)
Data about buying habits 
13.
Pauline has gathered so much data for her business’s marketing team that she’s having trouble organizing and storing them all. These data have become less useful to Pauline’s company because of 
a)
information overload
b)
Pauline’s lack of training.
c)
their irrelevance to the company. 
d)
trademarks and copyrights.
14.
If marketers do not have enough secondary data available to meet the company’s needs, they must
a)
conduct primary research. 
b)
find a new project.
c)
create data.
d)
wait until secondary data appear. 
15.
Write 'True' or 'False'
Data obtained in the original form is known as raw data
a)
TRUE
b)
FALSE
16.
How many people were surveyed?
a)
20
b)
10
c)
18
d)
8
17.
Which one of the following survey questions would generate numerical data?
a)
What is your favourite colour?
b)
What type of car does your family own?
c)
How long does it take for you to travel to school?
d)
What type of dog do you own?
18.
What is a census?
a)
A tool used to collect statistical data
b)
Statistics collected from an entire population
c)
The factual information collected from a survey or other source 
d)
A group chosen from a population
19.
What is a sample?
a)
A tool used to collect statistical data
b)
Statistics collected from an entire population
c)
The factual information collected from a survey or other source 
d)
A group chosen from a population
20.
What is a survey?
a)
A tool used to collect statistical data
b)
Statistics collected from an entire population
c)
An element or feature that can vary
d)
A group chosen from a population
21.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
22.
Cell C1 contains the formula =A1+B1. If you copy the formula in C1 to cell C2, which of the following formulas will appear in cell C2?
a)
=A1+B1
b)
=C1+C2
c)
=A2+B2
d)
=B2+B3
23.
Which keys would you press to paste worksheet data into the clipboard?
a)
Ctrl-V
b)
Ctrl-C
c)
Ctrl-A
d)
Ctrl-P
24.
What is the symbol to subtract in Excel?
a)
^
b)
/
c)
-
d)
=
25.
What is the to divide in Excel?
a)
/
b)
[
c)
-
d)
*