Font size
WorksheetsCPA 4NT Paper 1 Quiz 4 (AISS)
Total questions: 20
Worksheet time: 16mins
Which of the following are input devices?
Keyboard
Monitor
Scanner
Barcode Reader
Which of the following tools is most suitable in protecting your computer from online threats?
Windows Disk Cleaner
Windows Firewall
Windows Explorer
Windows Error Checking
Which of the following steps helps to protect a computer from physical damage?
Installing a firewall
Scanning the computer for viruses
Shutting down the computer properly
Using the correct power supply for the computer
Some program instructions are used to start up a computer. Why are these instructions not stored in the RAM (Random Access Memory)?
RAM is a secondary storage
RAM is unable to store data
RAM loses data when the computer has been shut down
Some computers do not have RAM
In a multimedia presentation, what are the hyperlinks that navigate between different slides also known as?
external links
internal links
merging links
special links
What is the purpose of including action buttons in a multimedia presentation?
To allow a user to contact the person in charge
To allow a user to edit the presentation
To allow a user to link to different slides within the presentation
To allow a user to save the presentation
In the use of computer graphics software (inkscape), what is a possible reason for not being able to fill an object with colour?
The object has been skewed
The object has no outline
The object is not a common shape
The object is not closed
The following drawing is produced by a computer graphics software.
What is the most likely transformation that was done?
Difference
Interpolate
Union
Intersection
Word wrap is a function used in word document to align text. Which of the following best describes how word wrap adjusts text?
Adjusting the font size of words so that the text fits into a single line
Adjusting the indentation of words so that text fits into a single line
Automatic movement of words to the next line when current line is filled.
Automatic movement of words to the next page when current line is filled
DropCap is a fanciful font that improves the look of a document.
Which kind of text is DropCap most commonly found?
Emails
Letters
Storybook for children
Composition
What is the main purpose of using mail merge in a word document?
To generate identical documents for different recipients
To generate letters with different content
To generate multiple documents for the same person
To generate multiple graphics from a folder
When using a word document, in which position is text repeated on every page?
Center of document
Left Margin
Footer
Right Align
Use the spreadsheet table above to answer the question.
It contains information about the nationality of students in a school
Column C indicates the School ID of the students. Which function can be used to obtain the 5th character in their School ID? E.g. extract letter ‘F’ or ‘L’.
Center
Left
Median
Mid
Use the spreadsheet table above to answer the question.
It contains information about the nationality of students in a school.
Which function will return a value 2017 from the cell B3?
=LEFT(B3, 4)
=RIGHT(B3, 4)
=YEAR(B3, 4)
=YEAR(B3)
Use the spreadsheet table above to answer the question.
It contains information about the nationality of students in a school.
Which of the following tool can be used to ensure that a student enters a School ID correctly into column C?
Conditional Formatting
Data Validation
Lookup Function
Spelling Checker
In a spreadsheet, when would the use of a
V/H lookup function be appropriate?
To control what the user enters into the spreadsheet.
To find things in a table by column or row.
To highlight certain words in the spreadsheet.
To replace words in the spreadsheet.
Which of the following formula will round 45.7 to a value of 45?
=ROUND(45.7, 0)
=ROUND(45.7, 3)
=ROUNDDOWN(45.7,0)
=ROUNDUP(45.4,0)
Which of the following best describes a combination chart?
It is a chart that shows 2 charts that overlapping
It is a pie chart combined with a line or column chart
It is always made up of 2 column charts
It is always made up of 2 line charts
Which of the following is represented by this symbol in a flowchart
Decision
Input / Output
Process
Start / End
1. QUICK is a variable used in a game. The following script is used within the game.
SET “ QUICK” TO 5
REPEAT UNTIL <QUICK=3>
IF <KEY “B” PRESSED?>
THEN CHANGE “QUICK” BY -1
LOOP AGAIN
When the game is run, the B key is pressed 5 times, followed by the SPACE key.
What is the final value for “QUICK”?
0
1
2
3
