1725189407984_class_11_IT_Revision_worksheet.docx

**Half-Yearly** **Revision Worksheet** **Multiple Choice Questions (MCQs)** 1. Which of the following is an example of volatile memory? - a\) Hard Drive - b\) RAM - c\) ROM - d\) SSD 2. Which key combination is used to save a document in LibreOffice Writer?...

**Half-Yearly** **Revision Worksheet** **Multiple Choice Questions (MCQs)** 1. Which of the following is an example of volatile memory? - a\) Hard Drive - b\) RAM - c\) ROM - d\) SSD 2. Which key combination is used to save a document in LibreOffice Writer? - a\) Ctrl + C - b\) Ctrl + V - c\) Ctrl + S - d\) Ctrl + P 3. Which of the following is NOT a function available in spreadsheets? - a\) SUM - b\) SQRT - c\) ADDTEXT - d\) MAX 4. The process of correcting a document\'s spelling errors automatically as you type is known as: - a\) Spell Check - b\) AutoCorrect - c\) Grammar Check - d\) Proofreading 5. Which command is used in a spreadsheet to ensure a specific cell reference does not change when copied to another cell? - a\) Absolute Reference - b\) Relative Reference - c\) Mixed Reference - d\) Fixed Reference 6. Which network topology connects all devices to each other directly without any central connecting device? - a\) Star - b\) Mesh - c\) Ring - d\) Bus 7. What is the purpose of the IF function in a spreadsheet? - a\) To perform mathematical calculations - b\) To display a message box - c\) To make decisions based on conditions - d\) To format text 8. Which software application is typically used for creating and editing text documents? - a\) Spreadsheet - b\) Database Management System - c\) Word Processor - d\) Presentation Software 9. Which of the following is NOT a cybercrime? - a\) Hacking - b\) Phishing - c\) Installing Antivirus - d\) Spamming 10. What does the term \"Bit\" stand for in computer terminology? - a\) Binary Digit - b\) Binary Term - c\) Bitrate - d\) Binary Information Technology 11. Which of the following is an example of a non-verbal form of communication? - a\) Writing - b\) Speaking - c\) Email - d\) Facial expressions 12. The \"A\" in SMART goals stands for: 13. Which of the following is NOT a type of network topology? 14. In a spreadsheet, the COUNT function is used for: 15. Which of the following is an output device? 16. What does the term \"volatile memory\" refer to? 17. Which menu in a word processor is typically used to change the page layout? 18. Which type of network connects multiple local area networks (LANs) across cities or countries? 19. What is the primary function of a router in a network? 20. Which of the following is considered a cybercrime? **Subjective Questions** 11. Describe the difference between volatile and non-volatile memory. Give an example of each. 12. Explain how a MAC address is used in a network. Why is it important? 13. List and explain any three key features of a word processor. 14. Discuss the importance of network security and mention two methods that can be used to enhance it. 15. What are macros in a spreadsheet application? Describe their advantages with an example. 16. Explain the purpose of the SUM and AVERAGE functions in a spreadsheet and provide examples of their use. 17. Describe the steps to create a new document in LibreOffice Writer and save it. 18. What is a network protocol? Name two commonly used network protocols and briefly describe their functions. 19. Differentiate between a switch and a hub in a network. Include examples of when each might be used. 20. List and explain the steps involved in formatting a paragraph in a word processor, including changing the alignment, line spacing, and indentation.