wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

2023-2024 Year 9 CS spring 2 revision

Total questions: 81

Worksheet time: 51mins

Name
Class
Date
1.

What is you full name?

4 lines
2.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
3.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
4.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
5.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
6.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
7.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
8.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
9.

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)  

10.

Which mathematical function does the symbol below represent?

/

a)

To the Power of

b)

Multiplication

c)

Division

11.

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")

12.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
13.

Which is the correct formula for VLOOKUP?

a)

VLOOKUP(cell data to find, sub table, column to return, fuzzy match)

b)

=VLOOKUP(cell data to find, sub table, column to return, fuzzy match)

c)

=VLOOKUP(sub table, cell data to find, column to return, fuzzy match)

d)

=VLOOKUP(cell data to return, sub table, column to find, fuzzy match)

14.

The absolute cell reference uses which symbol:

a)

$

b)

%

c)

*

d)

&

15.

VLOOKUP formula to be used to get result in the highlighted cell

a)

=VLOOKUP(A2:B9,2,FALSE)

b)

=VLOOKUP(D3,A2:B9,FALSE)

c)

=VLOOKUP(D3,A2,2,FALSE)

d)

=VLOOKUP(D3,A2:B9,2,FALSE)

16.

What type of function is used to add the total hours for full-time employees?

a)

SUM

b)

SUMIF

c)

COUNTIF

d)

TOTALSUM

17.
To restrict the data that can be entered into a cell e.g. Gender = "M" or "F", is called?
a)
Validation
b)
Verification
c)
Filter
d)
Sort
18.
Changing the appearance of a cell based on a rule is called?
a)
Conditional Formatting
b)
Validation Formatting
c)
Filter Formatting
d)
Sort Formatting
19.
A chart ________________ identifies which data series each color represents.
a)
a. legend
b)
b. vertical axis
c)
c. title
d)
d. horizontal axis
20.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d.    Average
21.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
22.

User can remove conditional formatting for

a)

Selected cell

b)

Other document

c)

Whole document

d)

Entire sheet

23.
If you want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
Relative
24.
An absolute reference is designated in a formula by the addition of a _______ sign. 
a)
%
b)
$
c)
&
d)
#
25.

When a cell reference is locked so that it does not move with the formula it is known as?

a)

An absolute reference

b)

A relative reference

c)

A locked reference

d)

A non moving reference

26.

Formulas can be copied to adjacent cells with the ____________.

a)

Fill handle

b)

PgDn Key

c)

Function key F4

d)

None of the above

27.

Multiple arguments must be separated by a ______________.

a)

Space

b)

Comma

c)

= Sign

d)

!

28.

To use multiple worksheets as possible cell reference may state ________________.

a)

Sheet1!A1

b)

Sheet1$A1

c)

=Sheet$1A$1

29.

Which software program do we use to create a database

a)

Microsoft Excel

b)

Microsoft Word

c)

Microsoft Access

d)

Microsoft Publisher

30.

Who might use a database?

a)

School

b)

Police

c)

Employer

d)

All of the above

31.

What is an advanage of a database?

a)

You can input information

b)

Its different to Excel

c)

It saves files

d)

Can search through and find information quickly

32.

What is a unique identifying field called?

a)

Field

b)

Primary Key

c)

Record

d)

Query

33.

Short text, date, long text and number are all examples of what?

a)

Data types

b)

Headings

c)

Fields

d)

Records

34.

A column in a database is better known as a...

a)

Record

b)

Query

c)

Field

d)

Form

35.

A row in a database is better known as

a)

Record

b)

Query

c)

Field

d)

Form

36.

A query is used to

a)

Sort the database in alphabetical order

b)

Search the database

c)

Delete records

d)

Create a form

37.

If we are running a query and looking for all records with a date before 1999, we type what into the criteria?

a)

>1999

b)

>01/01/1999

c)

<01/01/1999

d)

<1999

38.
Client Name is an example of a:
a)
Field Name
b)
Record
39.
What is a Relationship in an MS Access Database?
a)
It makes the data easier to enter
b)
It prevents data from being entered incorrectly
c)
It makes you feel closer to the computer and it's capabilities 
d)
It connects two tables so that they can be used as one table
40.
To sort from the smallest to the largest (from A to Z and 0 to 9)
a)
Ascending
b)
Descending
c)
Auto Sort
d)
Advanced Sort/Filter
41.

The command for "not equal to" is...

a)

<>

b)

<=

c)

>=

d)

><

42.

It is the association between two tables through a common field also known as a key or primary key.

a)

Control

b)

Management

c)

Relationship

d)

Entity

43.
The swim coach is looking for swim team purchase orders  that are greater than $200. What criteria would give her this info?
a)
>200 OR swimming
b)
>=200 OR swimming
c)
>200 AND swimming
44.

The table in this picture, is shown in

a)

design view

b)

datasheet view

c)

access view

45.

The table in this picture, is shown in

a)

design view

b)

datasheet view

c)

access view

46.
A particular DBMS uses SQL for extracting data. The SQL command "WHERE" is usually followed by:
a)
a criteria
b)
a table name
c)
a user name
d)
a mathematical formula
47.

SELECT First_Name

FROM Employee

WHERE Title = "Programmer" AND Gender = "F"


Would return what?

a)

Yolanda

b)

Yolanda and Jennifer

c)

Jennifer

48.
What word is missing from the line below?
SELECT *
_______ CUSTOMER;
a)
FROM
b)
WHERE
c)
SELECT
d)
ORDER BY
49.
What does “SQL” stand for?
a)
Standard Query Language.
b)
Structured Query Language.
c)
Structured Quick-access Language.
d)
Standard Questioning Language.
50.

Less than or equal to?

a)

>=

b)

=>

c)

=<

d)

<=

51.

In order to extract the population of Tanzania from a database of world countries you would need the following SQL code:

​ ​ (a)   population​ (b)   World ​ (c)   Country =​ (d)  

Choose from the below words
SELECT
CHOOSE
EXTRACT
FROM
IN
WHERE
IF
"Tanzania"
Tanzania
"T%"
52.
Convert 00010001 to decimal
a)
17
b)
27
c)
37
d)
47
53.
Convert 01000100 to decimal
a)
58
b)
68
c)
78
d)
88
54.
Convert 37 to binary
a)
00100101
b)
00100011
c)
00100111
d)
01000101
55.

What is 010 + 010?

a)

110

b)

010

c)

100

d)

011

56.

Before von Neumann computers were built to perform just one job. What idea did von Neumann have which is still in use today?

a)

Memory on the CPU

b)

Stored program concept

c)

separate input and output devices

d)

registers on the CPU

57.

What is the missing label?

a)

storage

b)

bus

c)

output

d)

CPU

58.

What is the CPU?

a)

central processing unit

b)

central processor unit

c)

common processing unit

d)

central process utility

59.

Tick all options that happen in the FETCH CYCLE?

a)

PC is incremented

b)

The Instruction at the MAR address is read from RAM

c)

The PC value is copied to the MAR

d)

The instruction in the IR is decoded

e)

The value in the MDR is written to the address in the MAR.

60.

There are 3 buses in von Neumann architecture. The data bus, the control bus and ???

a)

address bus

b)

instruction bus

c)

processor bus

d)

arithmetic bus

61.
What is the purpose of the Memory Data Register (MDR)?
a)
Holds the location of where the data is to be stored / read from
b)
Holds memory
c)
Holds instructions
d)
It does nothing
62.
What is the purpose of the memory address register?
a)
It memorises everything
b)
It keeps track of the instructions
c)
It holds the instructions to be carried out by the CPU
d)
It allows you to input something
63.
What does MAR stand for?
a)
Main Address Register
b)
Memory Address Register
c)
Massive Address Register
d)
Minimal Age Readable
64.
The small high speed storage areas within the memory and processor are known as..?
a)
Registers
b)
Addresses
c)
Cache
d)
Buses
65.
Which of the following is not a register?
a)
CU
b)
MAR
c)
MDR
d)
PC
66.

The Program Counter

a)

Stores the address of the next instruction in memory

b)

Stores the address of where the next item will be fetched from

c)

Stores data fetched from memory, or waiting to be stored in memory

d)

Stores the result of arithmetic calculations

67.

Accumulator

a)

Stores the address of the next instruction in memory

b)

Stores the address of where the next item will be fetched from

c)

Stores data fetched from memory, or waiting to be stored in memory

d)

Stores the result of arithmetic calculations

68.
Look at this code, what shape will it make?
a)
Square
b)
Triangle
c)
Rectangle
d)
Hexagon 
69.
Look at this code, what is the variable? 
a)
0
b)
4
c)
for
d)
i
70.
What is a variable? 
a)
A value that can change
b)
A number
c)
A value that can never change
d)
A letter
71.
Look at this code, how many times will it loop?
a)
50
b)
90
c)
0
d)
4
72.
To make the turtle move forward, which command is used?
a)
turtle.penup()
b)
turtle.forward()
c)
turtle.left()
d)
turtle.backward()
73.
In order to move the turtle 120 forward without drawing on the screen, which order is correct?
a)
turtle.forward(120)
turtle.penup()
turtle.pendown()
b)
turtle.pendown()
turtle.forward(120)
turtle.penup()
c)
turtle.penup()
turtle.forward(120)
turtle.pendown()
74.
What will be the output from this code?
a)
A star with an orange outline
b)
A solid orange star
c)
A pentagon with an orange outline
d)
A solid orange pentagon
75.

What shape will be the output from this code?

a)

Square

b)

Triangle

c)

Circle

d)

Rectangle

76.

How do you tell that Python that you are going to use the turtle library?

a)

import_turtle

b)

turtle import

c)

import turtle

d)

from turtle import

77.

What is wrong with this piece of code

a)

Must use the American spelling of colour - "color"

b)

Remove the prefix "screen." on Line 3

c)

Don't write the name of the colour in quote marks

d)

Don't add a capital letter to "Screen"

78.
What symbol is used to make a comment? (A comment is a way to annotate your code to explain what it is doing) 
a)
*
b)
/
c)
()
d)
#
79.
What is syntax?
a)
Syntax is the word used to describe an error
b)
Syntax is the rules of the programming language
c)
It is used to read information
d)
It is used to output information 
80.

There is an error on this piece of code, what is wrong?

a)

Nothing

b)

No start_fill() set

c)

No colour set in the end fill e.g. end_fill("blue")

d)

No colour set in the start fill e.g. start_fill("blue")

81.

The .turn(x) command instructs the turtle to turn

a)

Clockwise if x is positive

b)

Anti-clockwise if x is positive

Similar Resources on Wayground

Week 10 - Loops & String Formatters

82 questions

Week 10 - Loops & String Formatters

quiz

Worksheet

•

9th - 12th Grade

7.2 Computer Systems Revision

86 questions

7.2 Computer Systems Revision

quiz

Worksheet

•

8th Grade

Informatica base

80 questions

Informatica base

quiz

Worksheet

•

7th Grade - University

Coding Unit 1

80 questions

Coding Unit 1

quiz

Worksheet

•

6th - 8th Grade

Microsoft Power Point

82 questions

Microsoft Power Point

quiz

Worksheet

•

9th - 12th Grade

Science Spring Term Revision Practice

86 questions

Science Spring Term Revision Practice

quiz

Worksheet

•

6th - 8th Grade

Day 5 Practice 1 CompTIA IT Fundamentals+ Certification Quiz

80 questions

Day 5 Practice 1 CompTIA IT Fundamentals+ Certification Quiz

quiz

Worksheet

•

8th Grade

Quiz di Sicurezza Informatica

76 questions

Quiz di Sicurezza Informatica

quiz

Worksheet

•

9th Grade - University