Logo
search
menuicon
thubnail
Forest
Sequencing
High 11
Tech
Databases and spreadsheet
Christian Nits
46
Added Question (20/ 20)
Disallow incorrect answer
Hide answer
public quiz

# 1

Multiple 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.

# 2

Multiple Choice

Which of the following is a piece of software used to create databases?

  • Google Chrome
  • Microsoft Office PowerPoint
  • Microsoft Office Access

# 3

Multiple Choice

What term describes a personalised letter which can be sent to customers of a supermarket?

  • Mail merge
  • Report
  • Macro

# 4

Multiple 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.

# 5

Multiple 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.

# 6

Multiple Choice

Which of the following holds a single piece of data?

  • Table
  • Record
  • Field

# 7

Multiple Choice

Which field would be inappropriate in a database of countries?

  • First name
  • Population
  • Continents

# 8

Multiple 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.

# 9

Multiple Choice

What database feature checks to see if data meets certain rules when entered to a table?

  • Validation
  • Query
  • Table

# 10

Multiple 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

# 11

Multiple Choice

Which of the following is NOT capable of producing a spreadsheet?

  • Open Office Calc
  • Microsoft Office Excel
  • Microsoft Office Word

# 12

Multiple Choice

What word is used to describe re-organising the order of data?

  • Search
  • Sort
  • Fill

# 13

Multiple 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

# 14

Multiple Choice

Formulae must always start with which symbol?

  • Equals
  • Add
  • Brackets

# 15

Multiple 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

# 16

Multiple Choice

Which tool is best used to duplicate information from cell to cell?

  • Autosum
  • Fill handle
  • Filter

# 17

Multiple 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.

# 18

Multiple 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

# 19

Multiple Choice

The software can help guide us through the process of creating a chart. This is called a...?

  • Help
  • Wizard
  • Magician

# 20

Multiple Choice

What term describes changing the horizontal or vertical position of text?

  • Alignment
  • Font
  • Format
Share to Google Classroom