The document contains a 50 question multiple choice test on computer fundamentals and Microsoft Office applications like Excel and Word. The test covers topics such as computer hardware, operating systems, input/output devices, binary concepts, and functions of spreadsheet and word processing software. It aims to assess the user's knowledge in a 2 hour time frame with a full mark of 100.
The document contains a 50 question multiple choice test on computer fundamentals and Microsoft Office applications like Excel and Word. The test covers topics such as computer hardware, operating systems, input/output devices, binary concepts, and functions of spreadsheet and word processing software. It aims to assess the user's knowledge in a 2 hour time frame with a full mark of 100.
The document contains a 50 question multiple choice test on computer fundamentals and Microsoft Office applications like Excel and Word. The test covers topics such as computer hardware, operating systems, input/output devices, binary concepts, and functions of spreadsheet and word processing software. It aims to assess the user's knowledge in a 2 hour time frame with a full mark of 100.
The document contains a 50 question multiple choice test on computer fundamentals and Microsoft Office applications like Excel and Word. The test covers topics such as computer hardware, operating systems, input/output devices, binary concepts, and functions of spreadsheet and word processing software. It aims to assess the user's knowledge in a 2 hour time frame with a full mark of 100.
1. Who is the father of Computers? a) James Gosling b) Charles Babbage c) Dennis Ritchie d) Bjarne Stroustrup 2. Which of the following is the correct abbreviation of COMPUTER? a) Commonly Occupied Machines Used in Technical and Educational Research b) Commonly Operated Machines Used in Technical and Environmental Research c) Commonly Oriented Machines Used in Technical and Educational Research d) Commonly Operated Machines Used in Technical and Educational Research 3.What is the full form of CPU? a) Computer Processing Unit c) Central Processing Unit b) Computer Principle Unit d) Control Processing Unit 4. Which of the following language does the computer understand? a) Computer understands only C Language b) Computer understands only Assembly Language c) Computer understands only Binary Language d) Computer understands only BASIC 5. Which of the following is the brain of the computer? a) Central Processing Unit c) Arithmetic and Logic unit b) Memory d) Control unit 6. Which of the following is not a characteristic of a computer? a) Versatility b) Accuracy c) Diligence d) I.Q. 7. Which of the following unit is responsible for converting the data received from the user into a computer understandable format? a) Output Unit b) Input Unit c) Memory Unit d) Arithmetic & Logic Unit 8. Which of the following monitor looks like a television and are normally used with non- portable computer systems? a) LED b) LCD c) CRT d) Flat Panel Monitors 9. Which of the following is not a type of computer code? a) EDIC b) ASCII c) BCD d) EBCDIC 10. Which of the following part of a processor contains the hardware necessary to perform all the operations required by a computer? a) Controller b) Registers c) Cached) Data path 11. Which of the following is designed to control the operations of a computer? a) User b) Application Software c) System Software d) Utility Software 12. Which of the following are physical devices of a computer? a) Hardware b) Software c) System Software d) Package 13. Which of the following devices provides the communication between a computer and the outer world? a) Compact b) I/O c) Drivers d) Storage 14. Which of the following is the device used for converting maps, pictures, and drawings into digital form for storage in computers? a) Image Scanner b) Digitizer c) MICR d) Scanner 15. What is MS Excel? A)SpreadsheetB) Database Management C)PresentationD) Workbook 16. Which of the following is not a type of computer on the basis of operation? a) Digital b)Analog c) Hybrid d) Remote 17. Which of the following type of computer is mostly used for automatic operations? a) Analog b) digital c) hybrid d) remote 18. Which of the following computers are lower than mainframe computers in terms of speed and storage capacity? a) Mainframes b) Hybrid c) Mini d) Super 19. Which unit is responsible for converting the data received from the user into a computer understandable format? a) Memory Unit b) Arithmetic & Logic Unit c) Input Unit d) Output Unit 20. The smallest unit of data in computer is ________________ a) Byte b) Nibble c) Bit d) KB 21. One nibble is equivalent to how many bits? a) 2b) 4c) 8d) 1 22. 1 yottabyte = ______________ a) 1024 TB b) 1024 EB c) 1024 ZB d) 1024 PB 23. Which of the following is not a function of the Input Unit? a) It reads instructions and data from the outside world b) It converts the data into computer acceptable format c) It makes the data into user understandable format d) It supplies the data and instructions to the computer for further processing 24.RAM stands for a) Random access memory b) Random accessible memory c) Random access management d) None 25.How many arrow keys in keyboard a)1 b)2 c)3 d)4 26.The full form of GUI is: a)Graphical UPS input b)Graphical user interface c)Graphical user’s input d)None of these 27.Windows 7 is an example of: a)GUI b)Storage device c)Hardware d)Operating system 28.The main screen of the computer is called the a)Desktop b)Keyboard c)Motherboard d)None of these 29.Desktop icons represents a) Programs b) Files c) Folders d)All of the above 30.When you switch on the computer, it takes time to load the operating system so that it can work. This process is known as: a) Sooting b)Booting c)Shooting d) None of these 31.A file is a collection of ____. a) Data b) Settings c) Commands d) All of the above 32.Some files together can be stored in a ____ a)New file b)Folder c) Recycle bind)None of the above 33.For selecting a single icon on the desktop, you should perform a)Single-click b)Double click c)Right-click d)Scroll 34.What is the row limit of MS Excel 2019? A)4,81,0576 B)1,048,576 C)1,57,648 D)1,63, 84 35. In Microsoft Excel spreadsheets, rows are designated as _______. A. 1, 2, 3,...B. A, B, C,...C. A1, B1, C1, ....D. I, II, III,... 36. _____ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise. A) OR B) AND C) IF D) ANDIF 37. The intersection of a column and a row in a worksheet is called____ A)Column B)Address C)Value D)Cell 38.The Greater Than sign (>) exemplifies a/an _____ operator. A)Arithmetic B)Conditional C)Logical D) Greater 39. ____ is the correct syntax of IF() Function. A)=IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false])) B)=IF (logical_test, [value_if_true], [value_if_false]) C)=IF (logical_test, {[value_if_true]}, {[value_if_false]}) D)=IF (logical_test: [value_if_true], [value_if_false]) 40.What do Excel formulas start with? A) / B) f C) = D).–
41.Microsoft word is ____ software.
(A) Application(B) Compiler(C) System (D) Programming 42. Which is not in MS word? (A) Italic(B) Magic tool(C) Font(D) Bold 43.Documents can be ____ with MS Word. A.Created B. Edited C. Saved D.All of the above 44. File extension of word document is (A) .xls (B) .doc (C) .word (D) .jpeg 45. The shortcut command of ‘save’ in word: (A) Ctrl + A (B) Ctrl + C (C) Ctrl + V (D) Ctrl + S 46. Portrait and Landscape are ________ . (A) Paper size (B) Page layout (C) Page orientation (D) Page margin 47. What is an Excel feature that displays only the data in column (s) according to specified criteria? A)Filtering B)Sorting C)Formula D) Pivot 48. A number of letter that appears little above the normal text is called A.Superscript B.Subscript C.Supertex D. Top text 49. A number of letter that appears little below the normal text is called A. Superscript B.Subscript C.Supertext D.Toptext