Logo
search
menuicon
thubnail
Forest
Sequencing
High School 11
Tech

Databases and spreadsheet

Christian Nits
41
0
Added Question (20/ 20)
Disallow incorrect answer
Hide answer
public quiz

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

Question 2

Multiple Choice

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

  • Google Chrome
  • Microsoft Office PowerPoint
  • Microsoft Office Access

Question 3

Multiple Choice

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

  • Mail merge
  • Report
  • Macro

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

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

Question 6

Multiple Choice

Which of the following holds a single piece of data?

  • Table
  • Record
  • Field

Question 7

Multiple Choice

Which field would be inappropriate in a database of countries?

  • First name
  • Population
  • Continents

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

Question 9

Multiple Choice

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

  • Validation
  • Query
  • Table

Question 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

Question 11

Multiple Choice

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

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

Question 12

Multiple Choice

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

  • Search
  • Sort
  • Fill

Question 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

Question 14

Multiple Choice

Formulae must always start with which symbol?

  • Equals
  • Add
  • Brackets

Question 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

Question 16

Multiple Choice

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

  • Autosum
  • Fill handle
  • Filter

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

Question 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

Question 19

Multiple Choice

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

  • Help
  • Wizard
  • Magician

Question 20

Multiple Choice

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

  • Alignment
  • Font
  • Format
Share to Google Classroom