What are the answers to the following multiple-choice questions regarding spreadsheet data types, errors, functions, computer peripherals, and memory types?

Here are the answers to the objectives:

14. D) The data in cells A3 to A6 (WAEC, OCR, KNEC, NECTA, IEB) are sequences of characters, which are classified as Text data type.

    $$\boxed{\text{D. Text}}$$

15. C) The #REF! error in a spreadsheet indicates a reference error, meaning the formula refers to a cell that is no longer valid or non-existing.

    $$\boxed{\text{C. the formula refers to a non-existing cell.}}$$

16. A) To get "GH-WAEC" in cell C2:

    • LEFT(B2,2) extracts the first two characters from cell B2 ("GHANA"), which is "GH".
    • A2 contains "WAEC".
    • CONCATENATE("GH", "-", "WAEC") combines these to form "GH-WAEC". Let's check option A: =CONCATENATE(LEFT(B2,2),"-",A2)
    $$\text{LEFT(B2,2)} = \text{LEFT("GHANA",2)} = \text{"GH"}$$ $$\text{CONCATENATE("GH", "-", A2)} = \text{CONCATENATE("GH", "-", "WAEC")} = \text{"GH-WAEC"}$$

    This matches the output in C2.

    $$\boxed{\text{A. =CONCATENATE(LEFT(B2,2),"-",A2)}}$$

17. C) Peripherals (like printers, keyboards, mice) are connected to the computer system through ports.

    $$\boxed{\text{C. port}}$$

18. C) Volatile memory loses its data when the power is turned off. RAM (Random Access Memory) is a type of volatile memory. EPROM, PROM, and ROM are non-volatile.

    $$\boxed{\text{C. RAM}}$$

19. C) Set-top boxes primarily use a remote control for navigation and selection, which typically does not involve extensive keyboard entry. Deskphones and touch-tone devices use numeric keypads (a form of keyboard entry), and terminals are heavily reliant on full keyboard input.

    $$\boxed{\text{C. Set-top boxes}}$$

20. D) A head crash on a hard disk occurs when the read/write head physically contacts the platter. This can be caused by microscopic particles such as dirt, hair, and dust getting between the head and the platter, or by physical shock. Therefore, I, II, and III are all potential causes.

    $$\boxed{\text{D. I, II and III}}$$

21. A) The most effective way to protect computer hard drive data from loss due to hardware failure, accidental deletion, or other issues is to have regular backups.

    $$\boxed{\text{A. have regular backups.}}$$