NEW
Font size
WorksheetsRevision Quiz 3
Total questions: 30
Worksheet time: 30mins
When the hen is ready to lay her eggs, then and only then will the hen find a secluded spot to lay them.
When using the Find and Replace editing feature in a word processing program, without using the ‘whole words only’ option, how many occurrences of “hen” would be found in the sentence above?
2
3
4
5
When the hen is ready to lay her eggs, then and only then will the hen find a secluded spot to lay them.
Which of the following features would be LEAST efficient when using the Find and Replace dialogue box to replace all occurrences of the word “hen” with the word “duck”?
Skipping to each individual occurrence
Having the text in parts of words replaced
Finding each exact occurrence of the word “hen”
Finding the word “hen” using ‘whole words only’
Which of the following formulas will display the exercise name “Zumba” in any cell where the formula is placed?
=VLOOKUP(G4, A18:C22, 2, FALSE)
=VLOOKUP(G5, A18:C22, 2, FALSE)
=VLOOKUP(G4, A18:C22, 3, FALSE)
=VLOOKUP(G10, A18:C22, 2, FALSE)
Which of the following formulas will count the number of customers whose gender is equal to M in Column D?
=COUNT(D1:D10, "M")
=COUNTA(D2:D10, "M")
=COUNTIF(D1:D10, "M")
=COUNTIF(D2:D10, "M")
What type of cell referencing will replicate a formula that uses fixed cells?
I. Relative
II. Absolute
III. Mixed
I and II only
I and III only
II and III only
I, II and III
Which of the following features would give you the old and new versions of a previously saved document when using a word processor?
SAVE AS with file extension
SAVE AS with the old filename
SAVE AS with a new file type
SAVE AS with a new filename
The field that uniquely identifies a record in a database is called the
foreign key
primary key
alternate key
secondary key
Which of the following steps is required to centre text across a range of cells in a spreadsheet?
Copy the text across the cells.
Merge the cells and then centre the text.
Centre the text and then merge the cells.
Type the text in the middle of the cells.
If A > B Then Print(A);
Reads two numbers and prints the first number
Reads two numbers and prints the smaller number
Reads two numbers and prints the first number if it is smaller than the second number
Reads two numbers and prints the first number if it is larger than the second number
Which FOR statement below has the correct high-level language syntax to print the 7 times table from 1 to 12?
FOR count = 0 to 12 DO…END
FOR count = 1 DOWNTO 12…END
FOR count = 12 DOWNTO 1…ENDFOR
FOR count = 1 to 12 DO…ENDFOR
When implementing a program, which of the following steps comes after executing?
Linking
Compiling
Maintaining
Interpreting
What is the name given to an identifier pi = 3.14 that always holds the same value?
Constant
Location
Variable
Storage
Which of the following terms is an invalid variable name?
Sum
Count2
Vat15%
Count
The decision box of a program flow chart shows the
link to another page
test to be carried out
calculations to be done
input and output operators
A variable called class_avg to store exam average should be of what data type?
Real
Integer
Boolean
Character
I. Ask users for length and width
II. length, width
III. area ← length * width
Which option replaces I, II, III correctly?
Read, process, prompt
Process, read, prompt
Prompt, read, process
Read, prompt, process
Which construct executes statements and tests condition at the bottom of the loop?
For Do
While Do
If-then-Else
Repeat Until
The number of __________ in an algorithm determines the number of rows in a trace table.
constants
variables
computations
passes
Which of the following statements about conditional branching is TRUE?
It is implemented using loop structures.
It is one of four program flow constructs.
It is a part of the decision-making structure in a program.
It is expressed using keywords such as FOR and WHILE.
Which statement checks if X is the same or less than Y?
if X W?
arithmetic
conditional
relational
READ T, W IF T = W THEN PRINT "YES" ELSE T ← W * 2
If 3 and 4 are input, what is T?
3
4
6
8
A language that uses PUSH, CALL, RET is MOST LIKELY
a low-level language
a high-level language
Visual BASIC
C
Paul wrote a program which he translated and executed using two different sets of test data. Both tests produced incorrect results.
Incorrect results from both tests likely indicate a(n) __________ error.
divide-by-zero
logic
run-time
syntax
Paul wrote a program which he translated and executed using two different sets of test data. Both tests produced incorrect results.
Paul added output statements to observe variable values during execution. This process is called
compiling
debugging
testing
watching
A program is written using a high-level language featuring a count-controlled loop. The program has a statement that initializes the total variable with zero. The program was translated and executed. However, the output was zero, regardless of what input values were entered. The first three lines of program code are shown below:
inputVal = -1
total = 0
WHILE inputVal < 0
WHILE inputVal < 0 loop type ends based on user input variable?
I and II
II only
II and III
III only
inputVal = -1 total = 0 WHILE inputVal < 0 Which statement type is NOT shown?
input
assignment
loop
iteration
The flowchart segment below depicts all except:
finite steps
unambiguous instructions
flow of control
terminating condition
Which expression solves: Product = n1 * n2 Sum = n2 + n3 Answer = Product - Sum
answer ← n1 * n2 + n2 - n3
answer ← n1 * n2 - n2 + n3
answer ← n1 * n2 - (n2 + n3)
answer ← (n1 * n2) - (n2 + n3)
What is the minimum number of variables to compute and display the average of two numbers?
none
two
three
four
MOST helpful to a programmer maintaining someone else’s code?
source code
translation listing
internal documentation
external documentation
