WorksheetsFinGr5 T2 2021
Total questions: 20
Worksheet time: 10mins
How many cells are there in this table?
20
10
200
100
Which one is the correct cell address?
4D
D4
=D4
+D4
What is the cell address of Total quantity?
A5
B5
B1
B4
In Excel, Columns are labelled as ______
A, B, C, etc.
A1, A2, etc.
1,2,3 etc.
1A, 2A, etc.
To start a formula, we must put ... first
Number
Cell Address
Equal sign (=)
Addition sign (+)
What are Databases used?
To make a presentation
To store information in an organized way
To search information on the Internet
To create and edit a document
Which of the following is NOT an example of a database?
Telephone book
Customer list
Online library
DVD
What program do we use in class for Databases?
Look at the database below. The original price of the chosen car is:
1695
12500
2395
3995
What is a field?
The whole table of information
A little piece of information like Pupil Name or Hair Colour
A collection of information on one object, like a person or a movie
Big green thing
1. Look at the database below. The number of fields is …..
4
3
2
1
What is a RECORD?
A record is the place for information
A record is a collection of files
A record is a report of a database
A record is a set of data about one person or one thing
How many records are in this database?
8
9
543
28
A collection of fields and records is a ……
Form
Table
Query
Spreadsheet
….. is mostly used for data entry
Table
Form
Field
Record
In a database, Yes/No, Text and Date/Time are all examples of:
Data types
Fields
Tabs
Records
Which is not a data type?
Number
Text
Date/Time
Age
The best data type to choose for MemberID would be
Number
Date/Time
Currency
Text
The best data type to choose for date of birth would be
Number
Date/Time
Currency
Text
A data type that can only hold 2 values e.g. Yes/No or True/False.
Boolean
Number
Text
Date/Time
