Font size
Worksheets100 Questions on CPA MCQ (St Gab, QSS, ZHSS, YYSS, JVSS)
Total questions: 100
Worksheet time: 1hrs 20mins
A keyboard is
a communication device.
an input device.
an output device.
a storage device.
Which of the following is not a storage device?
Flash drive
Hard disk
Printer
Random Access Memory (RAM)
Data in a wireless computer network is transmitted using
cables.
microwaves.
radio waves.
WiFi.
When your computer is connected to the internet, it is possible for other users to see what is stored on your hard disk. What type of software is used to prevent this from happening?
Anti-virus
Browser
Firewall
Plug-in
Which Singapore law deals with the criminal act of "collect, use or disclose personal data belonging to others without permission"?
Computer Misuse and Cybersecurity Act (CMCA) 2017
Copyright Act (CA) Revised 2006
Personal Data Protection Act (PDPA) Revised 2019
Protection from Harassment Act (POHA) 2014
Which raster graphic file format does not support transparency?
bmp
gif
png
tiff
An increase in saturation of an image makes it appear
clearer.
lighter.
more noticeable.
more vibrant.
Two audio clips can be combined by
copying.
inserting.
recording.
trimming.
Footnotes are used to
attract readers' attention.
display descriptive information.
locate information easily.
provide explanation for body text.
Identify the indentation used for the second paragraph.
First-line indent
Hanging indent
Left indent
Second-line indent
Which of the following is used to start a new line without starting a new paragraph?
Hard break
Page break
Section break
Soft break
Which function is used to find the first character of a sorted list in a spreadsheet?
AVERAGE
LEFT
LEN
MODE.SNGL
Which of the following formulas can be used to return the data which appears most frequently?
=DATA()
=MEDIAN()
=MODE.SNGL()
=SUM()
Which of the following is the best choice to compare the proportions of parts within a whole set of data?
Column chart
Combination chart
Line chart
Pie chart
Which of the following is not a hyperlink to an external resource?
Link to a friend's blog
Link to a website
Link to the bottom of the page
Link to the school's PLDP home page
The self-ordering kiosk at a fast-food outlet allows user to
browse for services available.
learn about a new product.
order and pay for items purchased.
perform cash withdrawals.
Which of the following is a media element?
Music
Sprite
Vector
Wave
The following script is run. What is the output value?
-3
3
7
10
Score in a game can be computed and stored in
an input.
a number.
an unknown.
a variable.
The process of finding and fixing errors in programs is
analysing.
broadcast.
debugging.
flowchart.
A headphone is
a communication device.
an input device.
an output device.
a storage device.
The size of secondary memory can be measured in
gigabytes.
gigahertz.
milliseconds.
nanoseconds.
Wireless communications transmit data using
cables.
fibre optics.
radio waves.
wires.
Which of the following is NOT file compression?
All the files can be zipped into one folder.
It makes transfer of files easier.
The file size of the compressed files decreases.
The file size of the compressed files remains the same.
Which of the following is used to prevent unauthorised access to a network?
Firewall
Cyberbullying
Modem
Virus
Vector graphics are composed of
fills and strokes.
nodes and paths.
outlines.
pixels.
Frame rate affects the
paper quality.
resolution quality.
screen quality.
video quality.
The output resolution of a monitor screen is measured in
clips per inch (cpi).
dots per inch (dpi).
frames per inch (fpi).
pixels per inch (ppi).
Footnote appears at the
bottom of a page.
bottom of every page.
top of a page.
top of every page.
The paragraph above has a
first-line indent.
hanging indent.
left indent.
right indent.
What is the reason for increasing the line spacing in a word processor?
To have more white space.
To improve readability.
To space out the text.
All the above.
The wrap text feature is applied to cell
A2.
B12.
B13.
C12.
What function is used in cell C12?
COUNT
COUNTA
COUNTIF
SUM
Hakim's gender has been keyed in incorrectly. What other cells will change when the gender in B9 is corrected?
C9
C12
C12 and C13
C13
Which of the following has been applied to a multimedia presentation for the logo to appear in the same position with the same size?
Navigation Button
Slide Master
Template
Transition
Which of the following is an external link for a multimedia presentation?
Link to a document.
Link to another slide.
Link to the next slide.
Link to the top of the slide.
Which of the following is used to plan the sequence and layout for websites or multimedia presentations?
Multi-Column
Multimedia Elements
Scanner
Storyboard
The following script is run. What is the output value for B -A?
15
20
25
30
Which of the following is an initialisation component for a game algorithm?
change 'guess' by +1
next costume
set 'timer' to 100
wait 1 second
Which of the following is a terminator symbol in a flowchart?
Which of the following describes RAM?
Contains program instructions to start up the computer.
Loses data when the computer is switched off.
Manages the input, process and output operations.
Stores programs and data that the computer is working on.
Which of the following is a primary storage media?
Central Processing Unit (CPU)
Hard Disk Drive (HDD)
Random Access Memory (RAM)
Solid State Drive (SSD)
Which of the following best describes an operating system?
Allows users to produce animations and games.
Allows users to write documents and create presentation slides.
Provides audio and video editing tools.
Provides the user interface and manages the computer's resources.
A path contains nodes and handles. The handles can be used to
change the shape of the path.
clone the path.
duplicate the path.
resize the thickness of the path.
The output resolution of raster graphics when printed is measured in
dots per frame.
dots per inch.
pixels per frame.
pixels per inch.
Which of the following is a communication device?
Router
ROM
Processor
Flash drive
What is the main characteristic of a Wide Area Network (WAN)?
Limited geographical area.
Limited number of users
Spanning across multiple cities or countries.
Usually managed by a single organisation.
Frame rate in video is measured in
frames per byte
frames per cm
frames per rate
frames per second
In page layout, section break is used to
add footnote, footers and headers.
create mail merge.
embed tables and charts.
separate areas of a document into different layouts.
Which of the following cannot be used to create a multi-column document?
Columns
Tables
Text boxes
Windows
What is the purpose of indentation in a document?
To align text vertically.
To control the space between a paragraph and the margins.
To create bullet points.
To separate paragraphs.
Henry is typing a confidential document for the law firm. To mark the document as confidential, it is best that he ……………………………. .
insert a hyperlink for the word confidential.
insert the word confidential as a watermark.
insert the word confidential in the footnote
insert the word confidential in the header.
In a menu-driven presentation, what is the menu used for?
allow interactivity for users
allow users to order food
control the timing of the animation
send message to other users
Which of the following is not a hyperlink to an external resource?
Link to an email address.
Link to the last slide of the presentation.
Link to another document.
Link to the school website.
Peter inputs a value "14.024" in a spreadsheet. He wishes to use a function to automatically change the value to "14.1". Which of the following is the function Peter should use?
=ROUNDDOWN(14.024,1)
=ROUNDDOWN(14.024,3)
=ROUNDUP(14.024,1)
=ROUNDUP(14.024,3)
Which function should be used in cell D11?
COUNTIF
MAX
SUM
VLOOKUP
The data in column B is displayed as "#############". What is a likely reason for this?
Affected by virus.
Data is corrupted.
Error due to data validation.
Length of the cell is too short.
Which of the following is used to repeat an action?
Loop
Conditional instructions
Variable
Mathematical Operator
In animation and game making, which of the following is not an example of initialisation?
Sets the starting position.
Sets the backdrop for the scene.
Sets the variables to the correct values.
Sets 'if on edge, bounce'.
What is the final value of the variable "input" after the script below is executed?
2
4
6
8
Which of the following is an output device?
Keyboard
Joystick
Monitor
Mouse
What does LAN stands for?
Local Access Network
Local Area Network
Local Around Network
Look Around Network
Which of the following is the largest data unit?
Gigabyte
Kilobyte
Megabyte
Terabyte
A word processing feature that allows text to be wrapped around graphics in different ways to lay out text and graphics together is called
text shift.
text wrap.
word transfer.
word wrap.
Which of the following describes the stage between input and output?
Instruction
Procedure
Process
Progress
Which of the following is NOT a media element?
Graphic
Hyperlink
Sound
Video
Which drawing tool is used to get the final shape?
Exclusion
Intersection
Skew
Union
Multi-column layout is commonly used in
essays.
brochure.
poster.
reports.
Resolution in graphic is measured in
dots per byte.
dots per cm.
dots per inch.
frames per second.
Which of the following is an example of operating software?
Firewall
Graphic Software
Spreadsheet Software
Windows
Which of the following tools in a graphics software can be used to place the text inside a shape as shown below?
Bending
Difference
Envelope deformation
Put text on path
Which alignment has been applied to the text below?
Left
Right
Center
Justify
Which of the following features can be used to achieve a consistent style and layout in a slide presentation?
Slide layout
Slide master
Slide show
Slide transition
Which range of cells shows the type of stationary?
A3:A8
A4:A8
4A:8A
A4:D8
Which formula would you use in cell D4 for the Sales?
= B4*C4
= B4+C4
= B4:C4
= B4/C4
If the value in C5 is changed, which cell(s) will be affected?
D5
D10
D4:D8
D5 and D10
Which of the following is the file extension of a video file?
DOC
XLS
MP4
PNG
Which of the following is used to store data such as numbers, text or dates?
Conditional instructions
Loop
Mathematical Operator
Variable
Which of the following is the symbol for 'terminator' in a flowchart?
What is the final value of SCORE after the X is pressed 5 times?
0
3
6
8
Which of the following is an input device?
Hard disk
Keyboard
Printer
ROM
Which of the following describes the speed of a processor in a computer?
2.5''
2.5 GB
2.5 GHz
2.5 pixels
An internet is
accessible by specific users.
a private network.
a public network.
limited to a number of users.
Materials protected by copyright can be
claimed as own work.
modified and distributed freely.
used by giving credits to the creator.
used with owner's permission.
Which of the following is a computer crime?
Blogging
Hacking
Inputting
Printing
Image A has been changed to become Image B. Which two graphic features have been used?
Flip and resize
Flip and rotate
Resize and skew
Rotate and resize
An increase in saturation of an image makes it appear
clearer.
lighter.
more noticeable.
more vibrant.
Which of the following is not a vector graphic effect?
Blend
Combine
Copy
Tranparency
Identify the tool used for this document.
Paragraph breaks
Soft breaks
Tab stops
WordArt
The 'find and replace' feature searches for a phrase and
adds the phrase.
changes it to another phrase.
identifies the number of occurrences.
locates the phrase.
Changing the cells in a table as shown below is called
center aligned.
merging and centralised.
shifting and justified.
trimming and justified.
Data in a spreadsheet can be sorted and filtered by specifying the values, except for
colour.
file size.
number.
text.
Which of the following cannot be the answer if the following formula is entered into a cell? =RANDBETWEEN (-10, 10)
-5
0
5
15
Age of the students can be easily found out from the student code. Which of the following formula is used to find the age for Peter?
= Left(A3, 2)
= Mid(C2, 2)
= If(B3, ''12'')
= Right(B3, 12)
What will be displayed in cell E2 if the following formula is placed in it? =IF(D2>160,"accept","reject")
accept
Jane
ok
reject
A logo will be repeated on every slide of a presentation. The logo should be placed
at the center of each slide.
in a different position of each slide.
on the top corner of each slide.
same position of each slide.
Identify the external link of a multimedia presentation.
first slide
next slide
previous slide
website
In an animation, instructions can be given to a stage using
arrow key.
mouse click.
script.
video.
Which of the following is a flowchart symbols?
The decision in a game making software is to
ask user to provide data.
end a programme.
initialise a game.
represent a conditional statement.
