Font size
WorksheetsHints practice final test Semester 1
Total questions: 35
Worksheet time: 30mins
Which element of a chart shows the meaning of each color or pattern used in the graph?
Axis
Legend
Data Label
Title
What is the purpose of the Y-axis in a bar chart?
Shows categories
Shows numerical values
Shows chart title
Shows trend line
Which of the following is NOT a type of graph commonly used in spreadsheets?
Pie chart
Bar chart
Line chart
Text chart
A line graph is most suitable for…
Comparing parts of a whole
Showing changes over time
Showing rankings
Showing one value only
Which chart type is best used to represent percentages that total 100%?
Pie chart
Line chart
Column chart
Scatter graph
Data labels in a chart are used to…
Change the color of the bars
Show exact values of data
Change the background
Remove axis titles
The X-axis in a column chart usually displays…
Values
Categories
Titles
Percentages
A scatter graph is used to show…
The relationship between two variables
Categories in separate bars
Total amounts
Ranking of items
The text “Student Name” on a horizontal axis is an example of…
Title
Axis label
Legend
Data series
Which chart is best for comparing quiz scores of different students?
Pie chart
Column chart
Radar chart
Scatter chart
A bar graph that uses horizontal bars instead of vertical bars is still considered a…
Column chart
Line chart
Bar chart
Dot chart
A chart element that displays the name of the chart is called…
Data Series
Chart Title
Axis Title
Legend
When a chart shows “Demi: 85”, this feature is called…
Legend
Data Label
Axis Marker
Gridline
Gridlines help the reader…
Add extra values
Remove the axis
Read values more accurately
Change chart colors
Which component of a chart displays the explanation of symbols or colors?
Chart Title
Legend
Axis Label
Data Table
A database is best described as…
A single value
A collection of related data
A diagram
A picture
A field in a database represents…
A row
A column
A chart
A file
A record is…
A complete set of fields
A list of queries
A table heading
A file name
A primary key must be…
Sometimes empty
Sometimes duplicated
Always unique
Optional
Which data type is used for storing “Yes/No”?
Text
Boolean
Numeric
Date/Time
A numeric field stores…
Numbers only
Only text
Images
Videos
A query in a database is used to…
Store files
Search and filter data
Add pictures
Print charts
“212-8890” is best stored as which data type?
Number
Text
Currency
Boolean
The person credited with creating the first database management system is…
Charles Babbage
Edgar F. Codd
Bill Gates
Alan Turing
Contiguous data means…
Data placed in separate locations
Data stored in random order
Data placed in a continuous block
Data stored on another device
Non-contiguous data means…
Data located next to each other
Data separated by rows or columns
Data that is always numeric
Data that cannot be selected
A file in a database refers to…
A raw piece of data
A collection of records
A single value
A data type
A “Date/Time” field is used to store…
Names only
Calendar dates and clock times
Boolean values
Currency
Raw, unorganized facts in a database are called…
Data
Information
Knowledge
Result
Which of the following is an example of a unique value?
Student score
A person’s name
Student ID number
City name
Explain the difference between a chart and a graph, and give one example of each.
Describe how data labels help users understand charts more clearly.
Define a Primary Key and explain why it is important in a database table.
Explain the difference between contiguous and non-contiguous data
Describe what a query is and explain how it is used to find information in a database.
