Revision Quiz 3

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