wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 9 - Revision Quiz

Total questions: 112

Worksheet time: 1hrs 4mins

Name
Class
Date
1.

What is a Database?

4 lines
2.

Do you need a computer to create a database?

a)

Yes

b)

No

3.

Mention personal uses of databases (e.g. of databases that you might have access for)

4 lines
4.

Mention 3 examples of workplaces that make use of databases and mention also what type of information do they store.

4 lines
5.

Why is it more appropriate to store databases electronically (on a computer system)?

4 lines
6.

Mention some practical examples of databases which can be accessed online.

4 lines
7.

How is a database organized? A database is mainly composed of….

4 lines
8.

In databases column headers are given a specific name. What is it?

(a)  

9.

In databases rows are given a specific name. What is it?

(a)  

10.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
11.
A column in a database.
a)
Field
b)
Record
c)
Entity
d)
Validation
12.
A group of related records.
a)
Entity
b)
Validation
c)
Field
d)
Filter
13.
A rule to make sure that only reasonable and sensible data is entered.
a)
Filter
b)
Query
c)
Validation
d)
Verification
14.
Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
15.
A method of only displaying records in a table that match specific criteria...
a)
Filter
b)
Validation
c)
Sort
d)
Verification
16.
A method for checking data entered e.g. Proof Reading or Double Entry.
a)
Verification
b)
Filter
c)
Data Types
d)
Query
17.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
18.
A data type used for storing numbers with a fractional part e.g. 3.142
a)
Integer
b)
Boolean
c)
Real / Float
d)
String
19.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
20.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
21.
Which of these is not a type of validation?
a)
Proof Reading
b)
Range
c)
Limit
d)
Presence
22.

This is...

a)

Information

b)

Data

23.

What is data?

a)

A formula for converting information.

b)

Raw facts and figures before they have been processed.

c)

Information in context.

d)

Processed information.

24.

Which are the correct data types?

a)

Text.

b)

Currency.

c)

Division.

d)

Fraction.

e)

Single letter.

25.

What are the main points of data?

a)

Data has no meaning

b)

Data is information open to the public

c)

Data is raw facts and figures before they have been processed

d)

Data can be made up of letters, numbers, symbols, graphics and sound

26.

True or False belongs to which data type?

a)

Alphanumeric

b)

Text

c)

Boolean

d)

Limited choice

27.

What is information?

a)

Information when processed creates data

b)

Information is nothing without data

28.

What type of data is this?


01825-764844

a)

Number

b)

Text

c)

Alphanumeric

d)

Raw

29.

What type of data restricts the choice by a user often example is a drop-down list or radio button or tick list

a)

Object

b)

Limited choice

c)

Boolean/logical

d)

Integer

30.

What type of data is the following "1960"

a)

Integer

b)

Alphanumeric

c)

Currency

d)

Real

31.

Which value is an Integer?

a)

64

b)

"cat"

c)

True

d)

0.5

32.
What data type would be best used to record the number of people at a party?
a)
Integer
b)
Real
c)
String
d)
Boolean
33.
What data type would be best to record the exact length of a piece of string in meters?
a)
Real
b)
Boolean
c)
Decimal
d)
Integer
34.

What are numbers, pictures or words without context known as?

a)

Data

b)

Information

c)

Knowledge

35.

What does putting data into a framework or structure provide?

a)

More information

b)

Rules

c)

Context

36.

What is the ability to understand information and to then form judgements, opinions, make predictions and decisions based on that understanding also known as?

a)

Data

b)

Infomation

c)

Knowledge

37.

Which of the following is NOT an example of data?

a)

301062

b)

Blue

c)

32, Primrose Hill

38.

'The petrol gauge was showing almost empty. I decided to look out for the next petrol station'. What is the statement 'I decided to look out for the next petrol station' an example of?

a)

Data

b)

Information

c)

Knowledge

39.

What is a cell in Excel?

a)

A formula

b)

An individual space

c)

A group of data values

d)

A graph

40.

What is a function in Excel?

a)

A formula

b)

An individual space

c)

A group of data values

d)

A graph

41.

What is a range in Excel?

a)

An individual space

b)

A group of cells

c)

A graph

d)

A formula

42.

What symbol comes first when using a function?

a)

:

b)

*

c)

(

d)

=

43.

How are cells named?

a)

By row (number) and column (letter)

b)

By column (letter) and row (number)

c)

By the contents of the cell

d)

Names are randomly assigned

44.

To add the contents of cells C1, C2, C3, C4, and C5, how would the function be written?

a)

=SUM(C1-C5)

b)

=SUM(C1,C5)

c)

=SUM(C1:C5)

d)

=SUM(C1*C5)

45.

What function finds the mean of a data set?

a)

There is no function to calculate mean

b)

MEAN

c)

MEDIAN

d)

AVERAGE

46.

What is a histogram?

a)

Another name for a bar graph

b)

A line graph of a function

c)

A graph showing the frequency of values in a data set

d)

A calculation

47.

Worksheets are made up of ___________

a)

bars and lines.

b)

tables and charts.

c)

rows and columns.

48.

__________ run from left to right and are identified by numbers.

a)

left align text

b)

rows

c)

tables

49.

You can format text in Excel by making it bold, italic, etc.

a)

True

b)

False

50.

Each workbook when open has ___ worksheet(s)

a)

5

b)

1

c)

3

51.

Excel files are called __________.

a)

spreadsheets

b)

excel documents

c)

workbook

52.

An Excel file format extension is

a)

jpg.

b)

xls

c)

dox.

53.

What is the name given to the intersection of a row and a column in a spreadsheet?

a)

cell

b)

cell range

c)

active cell

54.

Letters of the alphabet going across the top of the spreadsheet are know as

a)

columns

b)

column labels

c)

status bars

55.

Numbers down the left side of the spreadsheet are referred to as?

a)

formula column

b)

formula bar

c)

row labels

56.

What icon do you choose to align the text at the top, middle, or bottom of a cell?

a)
b)
c)
57.

What symbol must be at the beginning of every formula you write in a spreadsheet?

(a)  

58.

=SUM(A1,A3,A4)

What is the purpose of this formula?

a)

To add up the values referenced inside the brackets.

b)

To multiply the values referenced inside the brackets

c)

To compare the values referenced inside the brackets.

d)

To find a value in the cells referenced inside the brackets.

59.

=ROUND(AVERAGE(B2:B7), 0)

Select all statements that apply.

[Maximum: 3]

a)

This formula includes cell referencing

b)

This formula will find the mean number in the range selected.

c)

This formula will round the answer to 2 decimal places.

d)

The formula will produce a whole number as an answer. 

60.

Which formulas below will count the number of items with a cost above £1.50?

a)

=COUNT(IF(B2>1.5))

b)

COUNTIF(B2-B7, >1.5)

c)

=COUNTIF(B2:B7, ">1.5")

d)

COUNTIF(B2:B7, ">1.5")

61.

=ROUND(A1*$C$3, 2)

Select all that apply.

[Maximum: 2]

a)

This formula includes absolute referencing

b)

This formula will add the values in the two cells.

c)

This formula will round the answer to 2 decimal places.

d)

The formula will produce a whole number as an answer. 

62.

Write a formula to find calculate the total stock level in the bakery for all of its products combined.

Your formula MUST include cell references.

(a)  

63.

Which mathematical function does the symbol below represent?

*

a)

To the Power of

b)

Multiplication

c)

Division

64.

Which mathematical function does the symbol below represent?

/

a)

To the Power of

b)

Multiplication

c)

Division

65.

Which mathematical function does the symbol below represent?

^

a)

To the Power of

b)

Multiplication

c)

Division

66.

Which of the formula's would correctly output Yes/No in column D.

a)

=IF(D2 < 10) "Yes", "No"

b)

=IF(D2 < 10, "Yes", "No")

c)

=IF(D2 > 10, "Yes", "No")

d)

IF(D2 > 10, "Yes", "No")

67.

Which of the formula's would output the price of the cheapest item in the bakery?

a)

=MIN(B2:B7)

b)

=LOW(B2:B7)

c)

=SML(B2:B7)

d)

=BOTTOM(B2:B7)

68.

A teacher is creating a formula to calculate the value to convert the scores from a recent test to percentage to look like the image.

Select all options that apply.

a)

=(B2/35*100)

b)

=(Results[@[Score]]/$D$2)

c)

Change number format to Percentage

69.

Select all statements that apply to a cell.

[Maximum: 2]

a)

A single block in a table/spreadsheet where we enter data.

b)

Can be referenced in a formula by using the column and row id (e.g. A2)

c)

Does not allow text to be entered.

d)

Can be used to trigger macros.

70.

Which of the formula's would output the price of the cheapest item in the bakery?

a)

=MAX(B2:B7)

b)

=HIGH(B2:B7)

c)

=LRG(B2:B7)

d)

=TOP(B2:B7)

71.

Which of the formulas below are conditional formulas.

Select all that apply. [Maximum: 2]

a)

=SUM()

b)

=IF()

c)

=COUNTIF()

d)

=AVERAGE()

72.
What does HTML stand for?
a)
Hypertext Making Language
b)
Hyper Transfer Markup Language
c)
Hypertext Markup Language
d)
Hyper Transfer Making Language
73.
HTML Language uses
a)
Tabs
b)
Tags
c)
Punctuation
d)
Quotations
74.
A <tag>
a)
Is used to divide sections
b)
Is not needed in HTML
c)
Tells the browser how to format our content
d)
Is part of the title line in HTML
75.
<h> is
a)
Header Tag
b)
Headline Tag
c)
Half of a tag
d)
Closing header tag
76.
</h> is
a)
Header Tag
b)
Headline Tag
c)
Half of a tag
d)
Closing header tag
77.
New heading tags can be added by using;
a)
Letters (ie: ha; hb)
b)
Numbers (i.e: h1; h2)
c)
Quotations (ie: h'; h")
d)
You can't do this
78.
<p> is
a)
punctuation tag
b)
closing paragraph tag
c)
closing punctuation tag
d)
paragraph tag
79.
</p> is
a)
punctuation tag
b)
closing paragraph tag
c)
closing punctuation tag
d)
paragraph tag
80.
An attribute is a; 
a)
Applies changes to everything
b)
Different options for each tab
c)
Allows for no changes to the site
d)
Gives structure and text
81.
Style tags are used to;
a)
Apply style to one line
b)
Not used in HTML
c)
Used at the top of the page to apply a style to the entire document
d)
Used sparingly
82.
<style>
a)
Found at top of styling options
b)
Allows a heading to be written
c)
Allows the body to be written
d)
Allows attributes to be included
83.
</style>
a)
Found at the bottom of styling options
b)
Allows a heading to be written
c)
Allows the body to be written
d)
Allows attributes to be included
84.
Body tags are used;
a)
Used for only the header
b)
Used only for the paragraph
c)
element that wraps everything that is visible on the page.
d)
Not used in HTML
85.
<body>
a)
Body tag
b)
Paragraph tag
c)
Closing body tag
d)
Header tag
86.
</body>
a)
Body tag
b)
Paragraph tag
c)
Closing body tag
d)
Header tag
87.
A Header;
a)
Must include your name
b)
First Line of your code
c)
Found at bottom of your code
d)
Not needed in HTML
88.
<html>
a)
Gives you structure and text
b)
Not needed when creating HTML sites
c)
Goes after the <h1>
d)
Goes after the <body>
89.
</html>
a)
Found after </h1>
b)
Found after </style>
c)
Found after </body>
d)
Found at bottom of written code
90.
[Square brackets are used to define];
a)
An input attribute
b)
An export attribute
c)
A Function
d)
A Variable
91.
<img> tag finds;
a)
finds the image located at the a URL and the src attribute and then displays it.
b)
finds the image located at the SRC in the URL attribute and then displays it.
c)
Adds a cool picture
d)
Does not work in HTML coding
92.

You should save HTML files with which file extension?

a)

.htm1

b)

.index

c)

.webpage

d)

.html

93.
HTML uses
a)
Tabs
b)
Tags
c)
Labels
d)
Quotes
94.
What is the correct HTML for creating a hyperlink?
a)
<a href="http://www.w3schools.com">W3Schools</a>
b)
<a url="http://www.w3schools.com">W3Schools.com</a>
c)
<a>http://www.w3schools.com</a>
d)
<a name="http://www.w3schools.com">W3Schools.com</a>
95.
In HTML, a color can be specified by using what?
a)
Colour name
b)
RGB value
c)
HEX value
d)
All of these
96.
HTML5 incorporates three kinds of code: HTML, CSS and Javascript. Which of these provides the structure to a webpage?
a)
Javascript
b)
HTML
c)
CSS
d)
None
97.

The action attribute of a form

a)

tells how the information should be sent to the server.

b)

tells what web page or script will process the form.

c)

lets the user select from a set of options

d)

is a button command that processes the form

98.

The select field in a form

a)

is used inside an input element.

b)

provides users with a set of options to choose from.

c)

auto-completes as the user types data.

d)

cannot have a default option setting.

99.

An Email address field in a form

a)

<input type="email" id="email">

b)

<input type="text" id="email">

c)

<label for="email">

<email type="text" id="email">

d)

<input text="email" id="email">

100.

To submit a form for processing, use

a)

<input type="button" method="submit">

b)

<button type="submit"></button>

c)

<input type="submit">Submit</input>

d)

<input type="submit" value="Submit">

101.

What is the correct HTML for making a checkbox?

a)

<checkbox>

b)

<input type="checkbox">

c)

<check>

d)

<input type="check">

102.

What is the correct HTML for making a drop-down list?

a)

<list>

b)

<input type="dropdown">

c)

<input type="list">

d)

<select>

103.

In HTML, which attribute is used to specify that an input field must be filled out?

a)

required

b)

validate

c)

formvalidate

d)

placeholder

104.

Checkbox buttons let users select one or more of a particular set of choices

a)

True

b)

False

105.

The ______________ _______________ is used to send a form to a server

a)

File Input Box

b)

Radio Button

c)

Check Box

d)

Submit Button

106.

You can limit the characters a user may enter into the text field. For example date would be 4 numbers.

a)

Minimumlength

b)

Maxlength

c)

Limit

d)

Width

107.

Allows users to pick just one of a number of options

a)

Radio Button

b)

Check Box

c)

Drop Down List

d)

Password Input

108.

To put in a larger comment box you would use which tag?

a)

<input type="comment" id="comments"/>

b)

<input type="textarea" id="comments"/>

c)

<textarea id="comments"></textarea>

d)

<textarea id="comments" />

109.

___________ tag contains all the contents of an HTML document, such as text, hyperlinks, images, tables, lists, etc.

a)

<aside>

b)

<body>

c)

<footer>

d)

<header>

110.

In a table, which of the following tags are used to for the rows?

a)

<th>

b)

<td>

c)

<tr>

d)

<table>

111.

Which of the following are used to cell span over a row?

a)

Colspan

b)

Rowspan

c)

Tablespan

d)

Spanspan

112.

Where do users typically see forms?

a)

login screens

b)

social media sites

c)

banking sites

d)

all of the above

Similar Resources on Wayground

AP CSP Test Review 1

116 questions

AP CSP Test Review 1

quiz

Worksheet

•

9th - 12th Grade

ซ้อมแข่งตอบคำถามเทคโนโลยี 002

110 questions

ซ้อมแข่งตอบคำถามเทคโนโลยี 002

quiz

Worksheet

•

9th - 12th Grade

Quizz de culture générale du 30 Avril 2020

110 questions

Quizz de culture générale du 30 Avril 2020

quiz

Worksheet

•

5th Grade - University

Personal Finance Midterm PRACTICE

116 questions

Personal Finance Midterm PRACTICE

quiz

Worksheet

•

4th Grade - University

Kelas 9

117 questions

Kelas 9

quiz

Worksheet

•

9th - 12th Grade

WIX Y HERRAMIENTAS DE LA INTERFAZ

110 questions

WIX Y HERRAMIENTAS DE LA INTERFAZ

quiz

Worksheet

•

9th Grade

Логика

112 questions

Логика

quiz

Worksheet

•

7th - 10th Grade

AP CSP First Semester Final Exam Review 2021-22

108 questions

AP CSP First Semester Final Exam Review 2021-22

quiz

Worksheet

•

9th - 12th Grade