This computer science problem involves algorithmic thinking and programming concepts. The solution below explains the approach, logic, and implementation step by step.
ScanSolve AI Answer
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. 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. 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) LEFT(B2,2) = LEFT("GHANA",2) = "GH" CONCATENATE("GH", "-", A2) = CONCATENATE("GH", "-", "WAEC") = "GH-WAEC" This matches the output in C2. A. =CONCATENATE(LEFT(B2,2),"-",A2) 17. C) Peripherals (like printers, keyboards, mice) are connected to the computer system through ports. 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. 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. 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. 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. A. have regular backups. 3 done, 2 left today. You're making progress.