NEW
Font size
S
M
L
XL
WorksheetsFinal Exam Review (CA)
Total questions: 38
Worksheet time: 19mins
Name
Class
Date
1.
A tool used to organize, store, retrieve, and communicate groups of related information.
a)
Spreadsheet
b)
Word
c)
Presentations
d)
Database
2.
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
3.
I perform an advanced search. I am very similar to asking a detailed question.
a)
report
b)
query
c)
table
d)
form
4.
Spence plans to create a list of the topics that will be addressed during the conference call. Which document should he use?
a)
Agenda
b)
Business letter
c)
Minutes
d)
Personal business letter
5.
I store data in rows and columns. I am considered the basic building block of a relational database. I am used to organize information within a database.
a)
form
b)
table
c)
query
d)
report
6.
Arrange information in alphabetical/sequential order; Least to Greatest, 1-10.
a)
ascend
b)
descend
c)
data
d)
table
7.
Arrange information in reverse order; Greatest to Least, 10-1.
a)
greater than
b)
less than
c)
ascend
d)
descend
8.
Rows (database) are called...
a)
fields
b)
records
c)
table
d)
entry
9.
Columns (database) are called...
a)
rows
b)
fields
c)
table
d)
form
10.
Each item from this list is classified as...
Name
Birthdate
Social Security No.
Street
City
State
Zip
Name
Birthdate
Social Security No.
Street
City
State
Zip
a)
table
b)
record
c)
field
d)
entry
11.
Farmer Brown created a database to keep track of his dairy cows. Which of the following is an example of a database record?
a)
Cow = Elsie
b)
Cow, Age, Weight, Milk Production
c)
Elsie, 7, 800, 5
d)
800, 790, 250
12.
Which data type is the BEST choice for the Weight field?
a)
Text
b)
Number
c)
Date/Time
d)
Yes/No
13.
If the database shown below is sorted in ascending order by gallons of milk produced, which cow will appear close to the top of the page?
a)
Elsie
b)
Spot
c)
Bessie
d)
Flossie
14.
Results are returned IF the data specified in an equation meets conditions set by the formula; conditional operators.
a)
NOW
b)
Days 360
c)
IF Statement
d)
LookUp
15.
Returns the current date.
a)
NOW
b)
Days 360
c)
VLookUp
d)
List
16.
Used for two column vectors.
a)
Days 360
b)
IF Statements
c)
NOW
d)
LookUp
17.
Used to assist in organizing information.
a)
NOW
b)
Column Chart
c)
List
d)
Table
18.
Used when there is more than two columns in a table.
a)
VLookUp
b)
LookUp
c)
List
d)
NOW
19.
A chart in which the individual components are enhanced.
a)
Pie Chart
b)
Exploded Pie Chart
c)
Stacked Bar Chart
d)
XY Scatter Chart
20.
A chart used to represent the contribution of each component of one series of data to the whole, (percentages).
a)
Pie Chart
b)
Exploded Pie Chart
c)
Line Chart
d)
Column Chart
21.
A chart used to show trends or changes in data over time.
a)
Stacked Bar Chart
b)
Line Chart
c)
Pie Chart
d)
XY Scatter Chart
22.
A chart used to show the correlation of two or more sets of data sets.
a)
XY Scatter Chart
b)
Pie Chart
c)
Line Chart
d)
Stacked Bar Chart
23.
A chart used to represent the sum or more than one value and compare the contribution of individuals to the whole.
a)
Exploded Pie Chart
b)
Column Chart
c)
Line Chart
d)
Pie Chart
24.
A chart used to make comparisons and generalizations about groups of data.
a)
Line Chart
b)
Pie Chart
c)
Column Chart
d)
Stacked Bar Chart
25.
The left vertical side of the graph. It contains numerical data.
a)
Chart Title
b)
Y-Axis
c)
X-Axis
d)
Gridline
26.
The bottom horizontal side of the graph. It contains the category information.
a)
Y-Axis
b)
X-Axis
c)
Tick Mart
d)
Gridline
27.
The horizontal or vertical line that extends across the plot area of the graph for the purpose of adding clarification to the data.
a)
Chart Title
b)
Data Label
c)
Gridline
d)
Plot Area
28.
An object that explains the symbols, colors, or patterns used to differentiate the data.
a)
Legend
b)
Plot Area
c)
Gridline
d)
X-Axis Title
29.
The main heading, which describes the purpose and content.
a)
Chart Title
b)
Y-Axis Title
c)
X-Axis Title
d)
Data Label
30.
Which function will automatically add up a range of cells.
a)
AutoSum
b)
Average
c)
Freeze Pane
d)
Fill Handle
31.
Mrs. Bills wants to print an alphabetical list of all students who participated in the lollipops fundraiser. Which action should she take in order to print the list?
a)
create a query
b)
create a report
c)
create a table
d)
create a form
32.
What are the four objects in a relational database?
a)
tables, forms, queries, reports
b)
entries, forms, records, tables
c)
text, memo, time, lookup
d)
table, memo, form, time
33.
Mrs. Bills wants to view an alphabetical list of all students who participated in the lollipops fundraiser. Which action should she take
a)
sort in ascending order on student name
b)
sort in descending order on student name
c)
sort in ascending order on lollipops
d)
sort in descending order on lollipops
34.
Mrs. Bills need to get a list of students who have sold at least 100 lollipops. Which criterion is used?
a)
lillipops less than 100
b)
lollipops greater than 100
c)
lollipops greater than or equal to 100
d)
lollipops less than or equal to 100
35.
Farmer Brown created a database to keep track of his cows. How many records are in the database?
a)
1
b)
2
c)
4
d)
5
36.
If the database is sorted in descending order by weight, which cow will appear closest to the bottom of the page?
a)
Flossie
b)
Bessie
c)
Spot
d)
Elsie
37.
Which object would Farmer Brown create to find out which cows produced more than 5 gallons of milk per day?
a)
table
b)
form
c)
query
d)
report
38.
Farmer Brown created a database to keep track of his cows. Age is classified as a:
a)
field
b)
table
c)
query
d)
report
Reset
