Which of the following is used for executing HTML code?

• Browser

• Hyperlink

• Web server

• Uniform Resource Locator

Real numbers entered in a cell on a spreadsheet are automatically

• Right justified with no decimal places

• Right justified with decimal places

• Left justified with decimal places

• Centred with no decimal places

What type of cell addressing must be used to keep the cell address in a formula the same, when the cell address is copied to another cell?

• Fixed

• Direct

• Relative

• Absolute

Item 44 refers to the following sentence: "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”)

Which of the following features allows the user to insert individual names in a primary document?

• Footer

• Header

• Mail merge

• Search and replace

When creating a database for a supermarket, the MOST appropriate data type to use for the price of an item is

• Text

• Number

• Currency

• AutoNumber

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 characteristics must two database tables have in order for them to be linked?

• Composite keys

• The same data in all tuples

• At least two tuples in the table

• At least one common attribute name