Font size
WorksheetsUnit 2, 3.5 Data analysis tools
Total questions: 20
Worksheet time: 10mins
Which of the following is a common database program?
Access
Excel
SQL
Publisher
What causes most errors in a database?
SQL
Humans
Servers
Internet access
Which is the best example of a primary key?
Driving License Number
Home Runs Hit
Price
First and Last Name
A column name in a database is known as a ______ .
Field
Table
Row
Record
Data _____ helps ensure that incorrect data is not entered.
Integrity
Checks
Accuracy
Validation
A quick way to find data in a database is to use _____.
Questions
Quandries
Queries
File folders
What must be common between two tables to create a relationship?
Names
Characters
Files
Fields
The front-end of a database is known as a _____.
Report
Query
Form
Website
SQL stands for _____.
Sustainable Query Language
Structured Query Language
Structured Question Language
Sustainable Question Language
A spreadsheet program is used to store data in:
A database
A text document
Rows and columns
Letters and numbers
Which of the following is an example of a cell reference?
Column C
=SUM
Row 1
A5
A ___________________ is a visual representation of data
Spreadsheet
Border
Chart
Table
Addition, subtraction, multiplication, division, and exponentiation are examples of what?
Formulas
Conditional formatting
Functions
Spreadsheet data
Which of these are not an example of how MS Excel can be used?
Budget
Research Paper
Track sales
Track Inventory
What is the purpose of spreadsheets?
To present information on different engaging slides
To deliver a speech to a crowd
To perform basic and complex math computations in an organized way
To excel your research papers and citations
I need a pie chart of sales for 5 leading trainers, what should I use?
Spreadsheet
Database
What should I use to store the stock and customers for an online shopping website?
Database
Spreadsheet
Which of the following would be used for trend and pattern identification?
Table
Report
Database
Line graph
Which of the following is an example of data cleaning?
Deleting data
Removing customers who have not made a purchase in 2 years
Optimising the servers
Removing customers who have purchased an item last month
Select 3 examples of a geographic information system or location mapping.
Tracking shipping containers
Google maps
Locating the phone of a criminal
Website
