Font size
WorksheetsCPA_2024
Total questions: 34
Worksheet time: 26mins
Which of the following is an output device?
Byte
Printer
Scanner
Thumb drive
Which of the following is an example of a troubleshooting technique?
Backing up
Printing
Rebooting
Storing
A local area network (LAN) is
always in a single room
never connected to the internet
usually in a single building
usually in multiple buildings
A benefit of file compression is
a larger file size
a smaller file size
an increase in the number of files
making file transfer more difficult
For which of the following acts would you need to ask for permission?
Distributing copyrighted software
Installing a program you wrote yourself
Installing free ware
Using a sound file that has a Creative Commons license
Vector graphics are composed of
dots and nodes
nodes and paths
paths and pixels
pixels and dots
Which of the following is an operation on a video clip?
Fill
Plan
Trim
Union
Video with a lower frame rate
appear smother
have more colours
have poorer quality
take up more space
Line spacing in a document can be set as
advanced
double
left
right
The text above has a
bold typeface
italic typeface
sans-serif typeface
serif typeface
The orientation of a page can be set to
horizontal
landscape
left
vertical
Which function is used to find the largest number in a range of cells in a spreadsheet?
LEN
MAX
MIN
SUM
Which function rounds to the nearest whole number?
RANDBETWEEN
ROUND
ROUNDDOWN
ROUNDUP
Input data is validated to make sure that
the input value is acceptable
the input value is accurate
the input data is not copyrighted
there are no calculation errors
Which of the following is an example of interactive multimedia communication?
Document
Slide presentation
Spreadsheet
Storyboard
The purpose of a slide master is to
add external hyperlinks
create a consistent style and layout
enhance contrast with media elements
insert media elements into a presentation
Which of the following is usually used for navigation between slides?
Background
Button
Storyboard
Video
Which of the following Scratch blocks produces a number?
When flag clicked
Set My Variable to 0
Change My Variable by 5
Set Your Variable to 5
Change My Variable by 5
If My Variable > Your Variable
Say My Variable for 2 seconds
Else
Say Your Variable for 2 seconds
0
5
10
15
In scratch the area where an animation or game takes place is called the
script
sprite
stage
variable
Give three examples of input devices.
(a)
A computer uses application software.
State what is meant by application software.
(a)
Give two examples of application software.
(a)
Malware is malicious software.
Give three examples of types of malware.
(a)
Web pages are frequently used to communicate information.
Describe two advantages of using web pages as a form communication.
(a)
Match the following to connect each network device with the most appropriate purpose.
To allow wireless devices to access a network
To form a network by connecting multiple wired devices
To convert data from one form to another
to allow network access by being installed in a computer
State two different file formats for raster graphics
(a)
State the number of rows and columns in this table.
Rows :___
Columns : ___
(a)
This formula contains absolute and relative cell references.
= D27*$A$5
Identify the absolute cell reference and the relative cell reference in this formula.
Absolute cell reference : __________
Relative cell reference : __________
(a)
State one advantage of using cell referencing in formulas.
(a)
State one difference between how absolute and relative cell referencing are used.
(a)
A slide presentation is developed to show a school's sports competition and the results.
Identify two different types of media elements that can be used.
(a)
When flag is clicked
Set Sum to 0
Set Counter to 1
repeat until Counter > 3
ask Please enter a number and wait
set Sum to Sum + answer
Set Counter to Counter + 1
Say Sum for 5 seconds
stop all
(a)
When flag is clicked
Set Sum to 0
Set Counter to 1
repeat until Counter > 3
ask Please enter a number and wait
set Sum to Sum + answer
Set Counter to Counter + 1
Say Sum for 5 seconds
stop all
(a)
