Welcome to your G.C.E. (O/L) ICT Exam 1. Total Questions: 20, Time: 30 minutesClick "Next" button to continue Name E-Mail Phone No. 1. The answer of A1 =B2/B1*C3-B1^C3+A3 in Microsoft excel120306092. What is the memory which is located to store frequently used data and programs and which helps to increase the speed of the computer?Random Access MemoryRead Only MemoryMemory RegistersCache Memory3. Consider the following statement regarding the selection of a word document are,A - Enter Key is the shortcut key to select the entire documentB - Double click the mouse on that word to select a wordC - To select a sentence, click on the beginning of the first word of the sentences and drag till theend of last word.Which of the above statements is/ are true?A and C onlyB onlyB and C onlyA and B only4. Gifts are given by one of bank for their customers who deposit money during the new year festival days. Following tables are used to store gifts and customer details.In above database, an example for foreign key field is,Acc_No of Customer_Gift_TableAcc_No of Customer_TableGift_No of Gift_TableReceived_Date of Customer_Gift_Table5. What is the true statement about output devices?A. Laser printers give high quality printouts.B. Ink jet printer is used to print the receipt of ATM machines.C. Cathode ray tube is higher radioactive device.A and C OnlyAll A,B,COnly BOnly A6. Consider the expression (a+b)ᶰ created in a word processing software. Which of the following feature should be used to type the character N?SuperscriptHightlightFont faceSubscript7. Which one is the programme file extension from the file extensions given belowwmf.docx.jpg.exe8. Consider the following statements about firewall.A – It may be a hardwareB – It may be a softwareC – It is used for controlling unauthorized data access in the InternetA onlyA , B onlyB onlyA, B, C all9. What is the answer that shows the suitable data types in the order for the fields of above Students Books TableText, Number, Date/ Time, Date/TimeText, Text, Date/ Time, Date/TimeNumber, number, Date/ Time, Date/TimeNumber, Text, Text, Text10. Incorrect statement about IP addressInternet service providers give IP addresses.IP addresses can be used to identify every computer in internet uniquelyOne IP address can have many computers within a networkIP address contain four numbers of decimal separated by dots from 0-2511. 1101101₂ is not equals to155₈109₁₀6D₁₆119₁₀12. You are required to copy following files to your flash drive which has only 2 GB space. What are the files that you can store into your flash drive according to the space available?Only A, B and DOnly A and BAll A, B, C and DOnly A, B and C13. What is the answer included only optical media data storage devices?None of aboveDigital Versatile Disk (DVD), Hard Disk, Blue-RayDigital Versatile Disk (DVD), Compact Disk (CD) , Blue-RayHard Disk, Floppy Disk , Magnetic Tape14. What is the correct answer for the calculation given below?8+2*3^2/6-3588.661015. The world first digital electronic computer is,Pascaline MachineABACUSENIACMark 1- Automatic Sequence Control Calculator16. . Consider the following spreadsheet functions.A - =SUM(A1,A4) B - =SUM(A1:A4) C - +SUM(A1:A4,A5)Which of the above is/are valid?A onlyA, C onlyA,B,C allB only17. Pixel is the basic building block of a digital graphic. When amount of bits of a pixel is increased, its' color amount is also increased. What is the color amount, if its' amount of bits are four?648163218. Which one is used to get the information from the relational tables?FormstableReportsQueries19. Which of the followings is the correct precedence of operators of 2 - 4*1 + 5/2 in the evaluation?+, -, *, /-, *, +, //, *,-, +*, / , -, +20. Consider the following two figures created in a typical graphics editing software.Which of the following tool may be used to create figure 2 drawn from figure 1?Paint bucket toolSub selection toolSelection toolText tool5 out of 4Congratulations..., You have completed the exam. Click "Submit" button to review your answers. Exam Home New Exam
