p question.pdf

100 Practice Questions 1. Which of the following is not a function in Excel? o A. SUM o B. AVERAGE o C. JOIN o D. MAX Answer: C 2. The shortcut key to save a document in Microsoft Word is: o A. Ctrl + A o B. Ctrl + S o...

100 Practice Questions 1. Which of the following is not a function in Excel? o A. SUM o B. AVERAGE o C. JOIN o D. MAX Answer: C 2. The shortcut key to save a document in Microsoft Word is: o A. Ctrl + A o B. Ctrl + S o C. Alt + S o D. Shift + S Answer: B 3. Which of these is a primary storage device? o A. Hard Disk o B. RAM o C. USB Drive o D. DVD Answer: B 4. The hexadecimal equivalent of decimal 15 is: o A. E o B. F o C. 10 o D. 1E Answer: B 5. Which function in Excel is used to find the average of a range of values? o A. COUNT o B. SUM o C. AVERAGE o D. MEDIAN Answer: C 6. What does CPU stand for? o A. Central Processing Unit o B. Control Programming Unit o C. Computer Personal Unit o D. Central Printing Unit Answer: A 7. Which key combination is used to open Task Manager in Windows? o A. Ctrl + Alt + Del o B. Ctrl + Shift + Esc o C. Alt + F4 o D. Win + X Answer: B 8. Which of the following is a spreadsheet software? o A. Adobe Acrobat o B. Microsoft Excel o C. Microsoft Word o D. Mozilla Firefox Answer: B 9. Which term describes the malicious attempt to gain sensitive information by disguising as a trustworthy entity in electronic communication? o A. Hacking o B. Phishing o C. Spamming o D. Baiting Answer: B 10. What is the default file extension for an Excel workbook? o A..docx o B..xlsx o C..pptx o D..xls Answer: B 11. Which shortcut is used to paste copied content? o A. Ctrl + P o B. Ctrl + V o C. Ctrl + X o D. Ctrl + C Answer: B 12. Which function is used to find the maximum value in a set of numbers in Excel? o A. MAX o B. SUM o C. AVERAGE o D. MIN Answer: A 13. What type of device is a printer? o A. Input o B. Output o C. Storage o D. Processing Answer: B 14. Which protocol is used to send emails? o A. FTP o B. HTTP o C. SMTP o D. IMAP Answer: C 15. The part of the computer that performs calculations is the: o A. ALU o B. CU o C. RAM o D. ROM Answer: A 16. Which Excel function can be used to count the number of cells that contain numbers? o A. COUNT o B. COUNTA o C. COUNTIF o D. COUNTBLANK Answer: A 17. What is a compiler? o A. Software to convert high-level code into machine code o B. Hardware device for computation o C. Operating System feature o D. Network protocol Answer: A 18. In Word, the feature to create a list of items is called: o A. Indexing o B. Numbering o C. Paragraph o D. Hyperlink Answer: B 19. Which key combination is used to undo an action? o A. Ctrl + U o B. Ctrl + Z o C. Ctrl + Y o D. Ctrl + A Answer: B 20. What does the term 'bit' stand for? o A. Binary Digit o B. Byte Information Text o C. Binary Information Tool o D. Binary Text Answer: A 21. What is the default row height in Excel? o A. 10 o B. 15 o C. 20 o D. 25 Answer: B 22. The term 'phishing' is related to: o A. Online fraud o B. Network routing o C. Data compression o D. Website design Answer: A 23. Which component is known as the brain of the computer? o A. RAM o B. Motherboard o C. CPU o D. Hard Disk Answer: C 24. Which type of memory is non-volatile? o A. RAM o B. ROM o C. Cache o D. Register Answer: B 25. Which function in Excel can be used to join two strings? o A. CONCATENATE  o B. MERGE o C. JOIN o D. COMBINE Answer: A 26. What is the shortcut key to find a word in a document in MS Word? o A. Ctrl + F o B. Ctrl + H o C. Ctrl + S o D. Ctrl + A Answer: A 27. Which of these is an example of a database software? o A. MS Word o B. MS Excel o C. MS Access o D. MS PowerPoint Answer: C 28. How many bits make up a byte? o A. 4 o B. 8 o C. 16 o D. 32 Answer: B 29. What does HTTP stand for? o A. HyperText Transmission Protocol o B. HyperText Transfer Protocol o C. Hyperlink Text Transfer Protocol o D. Hyperlink Transfer Text Protocol Answer: B 30. What is the default extension for Word documents? o A..doc o B..docx o C..txt o D..pdf Answer: B 31. The most common type of software is: o A. Operating system o B. Database o C. Spreadsheet o D. Word processor Answer: A 32. In Excel, which of the following is used to reference a cell from another worksheet? o A. Sheet Name!Cell Address o B. File Name!Sheet Name o C. Sheet Name Address o D. File Name  Address Answer: A 33. Which command is used to close the currently active window? o A. Alt + F4 o B. Ctrl + F4 o C. Ctrl + W o D. Shift + F4 Answer: A 34. Which programming language is often used for web development? o A. C++ o B. Java o C. Python o D. JavaScript Answer: D 35. The binary number system is based on: o A. 2 digits o B. 8 digits o C. 10 digits o D. 16 digits Answer: A 36. What is the function of an operating system? o A. Manages hardware and software resources o B. Compiles code o C. Edits photos o D. Provides internet connection Answer: A 37. Which Excel function returns the current date and time? o A. TODAY() o B. DATE() o C. NOW() o D. TIME() Answer: C 38. What is the purpose of the 'Print Preview' feature in MS Word? o A. To edit the document o B. To save the document o C. To check how the document will look when printed o D. To change the document format Answer: C 39. What is the primary function of a router in networking? o A. Store data o B. Connect devices to a network o C. Transmit audio signals o D. Display web pages Answer: B 40. What does the shortcut Ctrl + P do in most software? o A. Print the document o B. Open a new document o C. Save the document  o D. Paste the content Answer: A 41. Which part of the computer is responsible for calculations and logical operations? o A. Control Unit o B. RAM o C. Arithmetic Logic Unit o D. Hard Disk Answer: C 42. In Excel, what does the VLOOKUP function do? o A. Vertically searches for a value in the first column of a table o B. Horizontally searches for a value in the first row of a table o C. Looks up data within a single column o D. Displays a chart Answer: A 43. Which protocol is primarily used for browsing the web? o A. FTP o B. SMTP o C. HTTP o D. IMAP Answer: C 44. Which of the following is an example of application software? o A. Windows OS o B. Android o C. Microsoft Word o D. BIOS Answer: C 45. In binary, what is the sum of 1 + 1? o A. 1 o B. 10 o C. 11 o D. 0 Answer: B 46. Which MS Excel function returns the smallest value from a set of numbers? o A. MAX o B. MIN o C. AVERAGE o D. COUNT Answer: B 47. How can you access the task manager on Windows? o A. Ctrl + Shift + Esc o B. Ctrl + Alt + Del o C. Both A and B o D. Alt + Tab Answer: C 48. Which of the following describes the 'cloud' in cloud computing? o A. Software stored on a physical hard drive o B. Storage on a remote server accessible via the internet o C. A form of data encryption  o D. An email hosting service Answer: B 49. What is the purpose of the BIOS in a computer? o A. Manage peripherals o B. Start the operating system o C. Provide internet connection o D. Run antivirus software Answer: B 50. In MS Word, what is the shortcut to create a new document? o A. Ctrl + N o B. Ctrl + O o C. Ctrl + D o D. Ctrl + C Answer: A 51. Which of the following shortcut keys is used to copy selected text or objects? o A. Ctrl + X o B. Ctrl + V o C. Ctrl + C o D. Ctrl + A Answer: C 52. Which of the following is a web browser? o A. Google Chrome o B. Microsoft Word o C. Adobe Photoshop o D. MS Excel Answer: A 53. What does RAM stand for? o A. Read Access Memory o B. Random Access Memory o C. Right Access Module o D. Read And Modify Answer: B 54. Which function in Excel helps to sum values based on a condition? o A. SUM o B. SUMIF o C. COUNTIF o D. AVERAGEIF Answer: B 55. The default view in PowerPoint is: o A. Slide Sorter View o B. Normal View o C. Slide Show View o D. Notes Page View Answer: B 56. Which file extension is used for PowerPoint presentations? o A..docx o B..xlsx o C..pptx  o D..txt Answer: C 57. What is the purpose of the 'IF' function in Excel? o A. To perform logical tests and return specific values o B. To add numbers o C. To find the average of values o D. To count cells Answer: A 58. Which device is used to connect a computer to a network? o A. Router o B. Keyboard o C. Monitor o D. Printer Answer: A 59. In Word, which feature is used to check spelling and grammar? o A. Spell Check o B. Word Count o C. Thesaurus o D. AutoCorrect Answer: A 60. Which Excel function calculates the interest rate for a loan or investment? o A. RATE o B. INTEREST o C. PMT o D. IRR Answer: A 61. Which of the following is a type of network topology? o A. Star o B. Rectangle o C. Triangle o D. Sphere Answer: A 62. Which key combination is used to create a new slide in PowerPoint? o A. Ctrl + N o B. Ctrl + M o C. Ctrl + S o D. Ctrl + P Answer: B 63. Which of these storage devices can hold the most data? o A. CD-ROM o B. DVD o C. Blu-ray Disc o D. USB Flash Drive (16GB) Answer: D 64. What is the default font in MS Word 2016? o A. Calibri o B. Arial o C. Times New Roman o D. Verdana Answer: A 65. What does the term 'URL' stand for? o A. Uniform Resource Locator o B. Universal Resource Locator o C. Uniform Retrieval Location o D. Universal Retrieval Location Answer: A 66. What is the shortcut key to redo an action in MS Word? o A. Ctrl + Z o B. Ctrl + Y o C. Ctrl + U o D. Ctrl + R Answer: B 67. What is the purpose of a firewall in computing? o A. To monitor online activity o B. To protect against unauthorized access o C. To increase processing speed o D. To manage network bandwidth Answer: B 68. Which of the following is not an input device? o A. Mouse o B. Keyboard o C. Monitor o D. Scanner Answer: C 69. What type of software is an operating system? o A. System Software o B. Application Software o C. Utility Software o D. Programming Software Answer: A 70. Which of the following is an example of a database management system (DBMS)? o A. MS Word o B. Oracle o C. Adobe Reader o D. Notepad Answer: B 71. The first page of a website is called: o A. Main Page o B. Master Page o C. Home Page o D. Index Page Answer: C 72. Which programming language is primarily used for creating Android apps? o A. Java o B. C++ o C. Python o D. Swift Answer: A 73. What does 'HTTP' stand for in website URLs?  o A. HyperText Transfer Protocol o B. HyperText Transmission Protocol o C. Hyperlink Text Transfer Protocol o D. Hyperlink Transfer Text Protocol Answer: A 74. In networking, what is the function of an IP address? o A. To identify a network router o B. To identify a specific computer or device on a network o C. To measure bandwidth o D. To secure the network Answer: B 75. What is a macro in MS Excel? o A. A set of instructions to automate tasks o B. A formula to perform calculations o C. A tool for drawing shapes o D. A feature to manage worksheets Answer: A 76. The default alignment of text in a cell in MS Excel is: o A. Center o B. Left o C. Right o D. Justify Answer: B 77. Which of the following is not a type of computer network? o A. LAN o B. WAN o C. SAN o D. TUN Answer: D 78. In Excel, which symbol is used to start a formula? o A. # o B. % o C. @ o D. = Answer: D 79. What does BIOS stand for? o A. Basic Input Output System o B. Basic Interactive Output System o C. Binary Input Output Service o D. Binary Integrated Output System Answer: A 80. What is the primary purpose of the 'Format Painter' tool in MS Word? o A. To copy the format of text and apply it to another selection o B. To change the font size o C. To create a new document o D. To print the document Answer: A 81. What is the shortcut key to insert a new worksheet in MS Excel? o A. Shift + F11  o B. Ctrl + F11 o C. Alt + F11 o D. Ctrl + Shift + F11 Answer: A 82. Which of the following represents a gigabyte? o A. 1024 bytes o B. 1024 kilobytes o C. 1024 megabytes o D. 1024 terabytes Answer: C 83. Which tool in MS Word is used for adding predefined sets of text styles, colors, and effects to a document? o A. Style Set o B. Template o C. Theme o D. Design Answer: C 84. In Excel, what does the ‘PMT’ function calculate? o A. Principal amount o B. Payment amount for a loan o C. Profit Margin Total o D. Percentage Mean Total Answer: B 85. Which device is considered an output device? o A. Keyboard o B. Scanner o C. Printer o D. Microphone Answer: C 86. What is the purpose of the 'Track Changes' feature in MS Word? o A. To highlight spelling errors o B. To keep a record of changes made to a document o C. To find and replace text o D. To insert comments Answer: B 87. Which function in Excel is used to calculate the number of days between two dates? o A. DATEDIF o B. DAYCOUNT o C. DAYS o D. DATECOUNT Answer: A 88. What is the main function of the ALU (Arithmetic Logic Unit) in a CPU? o A. Perform arithmetic and logical operations o B. Manage data storage o C. Control input/output devices o D. Connect the computer to a network Answer: A 89. What is a byte? o A. 2 bits  o B. 4 bits o C. 8 bits o D. 16 bits Answer: C 90. Which menu in PowerPoint allows you to set slide transitions? o A. Home o B. Design o C. Animations o D. Slide Show Answer: C 91. What is the full form of PDF? o A. Personal Document Format o B. Portable Document Format o C. Program Data File o D. Printable Document File Answer: B 92. Which Excel function can be used to find the highest number in a range? o A. HIGHEST o B. MAX o C. UPPER o D. TOP Answer: B 93. Which of the following is not an example of application software? o A. Microsoft Excel o B. Adobe Photoshop o C. Windows OS o D. Mozilla Firefox Answer: C 94. Which key combination is used to create a chart from the selected data in Excel? o A. Alt + F1 o B. F2 o C. Ctrl + C o D. Shift + F1 Answer: A 95. What is the function of an antivirus program? o A. To organize files o B. To create a backup of data o C. To protect the computer from malicious software o D. To encrypt data Answer: C 96. In MS Word, the space between the page content and the edge of the page is known as: o A. Margin o B. Padding o C. Border o D. Spacing Answer: A 97. What does ISP stand for? o A. Internet Service Provider o B. Internal System Program  o C. Integrated Service Processor o D. Internet Secure Protocol Answer: A 98. Which of these is not a programming language? o A. Python o B. Java o C. HTML o D. Chrome Answer: D 99. What is the shortcut key to create a hyperlink in MS Word? o A. Ctrl + K o B. Ctrl + H o C. Ctrl + U o D. Ctrl + L Answer: A 100. What is cloud computing? - A. Storing data on a local machine - B. Using remote servers hosted on the internet to manage, store, and process data - C. Using multiple CPUs for complex computations - D. Using a high-speed LAN connection Answer: B