Logo
숲 속
quiz thumbnail
Sequencing
High 11
Tech

Databases and spreadsheet

Christian Nits

46

20 questions

Disallow incorrect answer

Hide answer

public quiz

# 1Multiple Choice
Which of the following is NOT true of databases?
You can store large amounts of data.
You have to use a computer.
You can search the data.
# 2Multiple Choice
Which of the following is a piece of software used to create databases?
Google Chrome
Microsoft Office PowerPoint
Microsoft Office Access
# 3Multiple Choice
What term describes a personalised letter which can be sent to customers of a supermarket?
Mail merge
Report
Macro
# 4Multiple Choice
Which of the following is an advantage of paper-based databases?
It is easy to add or amend records.
Data can be sorted and re-sorted easily.
You do not need any training on how to use the database.
# 5Multiple Choice
Thinking of data, information and knowledge - which of the following is an example of information?
The average men's shoe size is nine.
9
If you are to open a shoe shop, you must stock plenty of size nine shoes.
# 6Multiple Choice
Which of the following holds a single piece of data?
Table
Record
Field
# 7Multiple Choice
Which field would be inappropriate in a database of countries?
First name
Population
Continents
# 8Multiple Choice
What is the correct definition of primary key?
The first field in a table.
A field that contains unique data in each record.
The field which we will use to search with.
# 9Multiple Choice
What database feature checks to see if data meets certain rules when entered to a table?
Validation
Query
Table
# 10Multiple Choice
Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?
List check
Presence check
Range Check
# 11Multiple Choice
Which of the following is NOT capable of producing a spreadsheet?
Open Office Calc
Microsoft Office Excel
Microsoft Office Word
# 12Multiple Choice
What word is used to describe re-organising the order of data?
Search
Sort
Fill
# 13Multiple Choice
In a cell reference, for example A1, what does the letter refer to?
The row the cell is in
The column the cell is in
The worksheet the cell is in
# 14Multiple Choice
Formulae must always start with which symbol?
Equals
Add
Brackets
# 15Multiple Choice
Which of the following tasks would a spreadsheet be best used for?
Present information about a new television channel
Manage the details of members at a gym
Keep track of money raised at a charity event
# 16Multiple Choice
Which tool is best used to duplicate information from cell to cell?
Autosum
Fill handle
Filter
# 17Multiple Choice
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Because primary school children can use bar charts.
Because they don't require you to enter any formula.
Because the data is presented in a more visual way.
# 18Multiple Choice
Wrap text is an option which can be applied to cells in order to do what?
Put a border around a cell containing text
Put a background on a cell containing text
Resize a cell to fit the text inside
# 19Multiple Choice
The software can help guide us through the process of creating a chart. This is called a...?
Help
Wizard
Magician
# 20Multiple Choice
What term describes changing the horizontal or vertical position of text?
Alignment
Font
Format
Share to Google Classroom

You can't enter this quiz right now. Please ask the quiz creator to reactivate their plan or edit the quiz.