Scribd
Upload
13 views17 pages

Notes For Final Examination

The document is a question bank for the course 'Basics of Computer,' featuring multiple-choice questions, short answers, and long-form questions based on the syllabus. It covers various topics including computer components, generations, software types, and MS Office applications. Additionally, it includes answer keys for some of the questions.

Uploaded by

isteyaqueofficial
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views17 pages

Notes For Final Examination

The document is a question bank for the course 'Basics of Computer,' featuring multiple-choice questions, short answers, and long-form questions based on the syllabus. It covers various topics including computer components, generations, software types, and MS Office applications. Additionally, it includes answer keys for some of the questions.

Uploaded by

isteyaqueofficial
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

`Course Code : DBBC-25-101

Title of the Course : BASICS OF COMPUTER

QUESTION BANK

MCQ, SHORT AND LONG AS PER COURSE SYLLABUS

1. Who is known as the father of computers?


A. Charles Babbage
B. Alan Turing
C. John von Neumann
D. Bill Gates
2. Which of the following is a component of the Block Diagram of a computer?
A. CPU
B. Printer
C. Monitor
D. Keyboard
3. Which device is used for input in a computer?
A. Printer
B. CPU
C. Keyboard
D. Monitor
4. What is the primary function of the memory unit in a computer?
A. Process data
B. Store data
C. Output data
D. Input data
5. Which of the following is a type of secondary memory?
A. RAM
B. CPU
C. Hard Disk
D. ALU
6. What does "ALU" stand for in the block diagram of a computer?
A. Arithmetic and Logical Unit
B. Audio Logic Unit
C. Advanced Logic Unit
D. None of the above
7. The first generation of computers used which of the following?
A. Vacuum tubes
B. Transistors
C. Microprocessors
D. Integrated Circuits
8. Which of the following is not a type of computer?
A. Supercomputer
B. Mainframe
C. Personal Computer
D. Magnetic Disk
9. In the second generation of computers, which of the following was primarily used?
A. Vacuum tubes
B. Transistors
C. Microprocessors
D. Punch cards
10. Which computer generation introduced the use of integrated circuits?
A. 1st Generation
B. 2nd Generation
C. 3rd Generation
D. 4th Generation
11. In which generation of computers were personal computers introduced?
A. 1st Generation
B. 2nd Generation
C. 3rd Generation
D. 4th Generation
12. The first microprocessor was introduced in which generation of computers?
A. 1st Generation
B. 2nd Generation
C. 3rd Generation
D. 4th Generation
13. Which of the following is a characteristic of 5th-generation computers?
A. Use of vacuum tubes
B. Use of transistors
C. Parallel processing
D. Use of integrated circuits
14. What is the primary function of the Input unit in a computer?
A. Output data
B. Perform calculations
C. Receive data
D. Store data
15. The 'brain' of the computer that performs calculations and logical operations is called the?
A. Memory
B. ALU
C. CPU
D. Input Unit
16. Which of the following is not an example of an input device?
A. Keyboard
B. Mouse
C. Scanner
D. Printer
17. Which memory type is volatile and used for temporary storage?
A. ROM
B. Hard Disk
C. RAM
D. Flash
18. The term "GUI" stands for?
A. Graphical User Interface
B. General User Interface
C. Global User Interface
D. None of the above
19. Which of the following is an example of system software?
A. MS Word
B. MS Excel
C. MS Paint
D. Operating System
20. High-level programming languages are closer to which of the following?
A. Machine language
B. Assembly language
C. Human language
D. Low-level language
21. Which of the following is a compiler's function?
A. Convert high-level language into machine code
B. Perform arithmetic operations
C. Store data temporarily
D. Manage files
22. An interpreter differs from a compiler in that it?
A. Converts entire code at once
B. Translates code line-by-line
C. Uses fewer resources
D. Requires manual intervention
23. Which of the following is not a type of software?
A. Application Software
B. System Software
C. Utility Software
D. Hardware Software
24. Which of the following is an example of a high-level language?
A. C
B. Assembly
C. Machine Code
D. Binary Code
25. Which of the following is used for system management in a computer?
A. Operating System
B. High-Level Language
C. Compiler
D. Assembler
26. Which software is used for word processing?
A. MS Excel
B. MS PowerPoint
C. MS Word
D. Notepad
27. In which year did E-commerce begin to rise significantly?
A. 1985
B. 1995
C. 2000
D. 2010
28. Which of the following is a limitation of E-commerce?
A. Faster transactions
B. Global reach
C. Privacy and security concerns
D. Easy payment methods
29. Which sector is NOT an application of Information Technology?
A. Education
B. Healthcare
C. Agriculture
D. None of the above
30. Which of the following applications uses IT for managing booking systems?
A. Railway
B. Weather Forecasting
C. Education
D. Mobile Phones
31. The concept of cloud computing is primarily used in which domain?
A. Airline
B. Hotel Management
C. Education
D. Mobile Phones
32. Which of the following industries use IT for managing inventory?
A. Banking
B. Insurance
C. Inventory Control
D. Railway
33. In banking, IT is mainly used for?
A. Data security
B. Managing transactions
C. Loan processing
D. All of the above
34. The term "E-commerce" stands for?
A. Electronic Commerce
B. Economic Commerce
C. Educational Commerce
D. None of the above
35. A major advantage of E-commerce is?
A. Faster communication
B. Faster transactions
C. Higher costs
D. None of the above
36. Which of the following is a method used for weather forecasting?
A. Machine learning
B. Cloud computing
C. Satellite data
D. All of the above
37. Which network topology connects each device to a central hub?
A. Bus
B. Star
C. Ring
D. Mesh
38. Which of the following is a type of transmission mode in networking?
A. Simplex
B. Duplex
C. Half-Duplex
D. All of the above
39. Which of the following is not a type of network?
A. LAN
B. WAN
C. MAN
D. SAP
40. In networking, what does "LAN" stand for?
A. Local Area Network
B. Large Area Network
C. Local Address Network
D. None of the above
41. What does "FTP" stand for in internet terminology?
A. File Transfer Protocol
B. File Tracking Protocol
C. Functional Transfer Protocol
D. None of the above
42. The World Wide Web (WWW) was proposed by which of the following?
A. Tim Berners-Lee
B. Vint Cerf
C. Steve Jobs
D. Bill Gates
43. Which of the following is NOT an application of the Internet?
A. E-mail
B. WWW
C. FTP
D. Video Conferencing
44. Which of the following is the main function of email?
A. Sharing files
B. Sending messages
C. Video calls
D. Image sharing
45. Which of the following is NOT a part of MS Word?
A. Title bar
B. Menu bar
C. Formula bar
D. Status bar
46. Which tool in MS Word allows users to change the font style?
A. Formatting toolbar
B. Status bar
C. Title bar
D. Scroll bar
47. In MS Word, which feature allows users to undo their last action?
A. Redo
B. Undo
C. Cut
D. Copy
48. How can you select all text in a document in MS Word?
A. Ctrl + A
B. Ctrl + C
C. Ctrl + V
D. Ctrl + X
49. What is the function of the "Spell Check" feature in MS Word?
A. Formatting text
B. Correct spelling mistakes
C. Inserting images
D. Changing font size
50. How do you insert a page break in MS Word?
A. Ctrl + Enter
B. Ctrl + P
C. Ctrl + S
D. Ctrl + F
51. Which is the default font in MS Word 2016?
A. Times New Roman
B. Calibri
C. Arial
D. Courier New
52. Which of the following can be used to make text bold in MS Word?
A. Ctrl + I
B. Ctrl + B
C. Ctrl + U
D. Ctrl + E
53. What is the shortcut for copying text in MS Word?
A. Ctrl + C
B. Ctrl + V
C. Ctrl + X
D. Ctrl + P
54. Which feature in MS Word is used to find and replace text?
A. Find and Replace
B. Search bar
C. Spell Check
D. AutoCorrect
55. Which of the following is the shortcut to paste copied text in MS Word?
A. Ctrl + C
B. Ctrl + V
C. Ctrl + X
D. Ctrl + P
56. Which of the following MS Excel components allows users to create formulas?
A. Formula Bar
B. Status Bar
C. Title Bar
D. Menu Bar
57. Which of the following is NOT part of the MS Excel screen?
A. Menu bar
B. Ribbon
C. Scroll bar
D. Formula Bar
58. What does the "SUM" function in MS Excel do?
A. Calculates the total of numbers
B. Adds a number to another number
C. Multiplies numbers
D. Divides numbers
59. In MS Excel, what does "Ctrl + C" do?
A. Paste data
B. Copy data
C. Cut data
D. Insert data
60. Which of the following is the default file extension for an MS Excel workbook?
A. .docx
B. .xlsx
C. .pptx
D. .html
61. Which function is used in MS Excel to calculate the average of a range of numbers?
A. SUM
B. AVERAGE
C. COUNT
D. MAX
62. How do you save an Excel workbook?
A. Ctrl + S
B. Ctrl + P
C. Ctrl + C
D. Ctrl + X
63. Which of the following is a feature of MS PowerPoint?
A. Slide transitions
B. Email attachments
C. File management
D. Web browsing
64. How do you insert a new slide in MS PowerPoint?
A. Ctrl + N
B. Ctrl + M
C. Ctrl + P
D. Ctrl + S
65. Which of the following is a default layout in MS PowerPoint?
A. Title Slide
B. Blank
C. Two Content
D. All of the above
66. Which toolbar in MS PowerPoint helps you change the formatting of text?
A. Formatting toolbar
B. Menu bar
C. Ribbon
D. Title bar
67. In MS PowerPoint, which of the following tools is used to add images?
A. Clip Art
B. Insert
C. Design
D. View
68. What is the function of the "Transitions" tab in MS PowerPoint?
A. Adding transitions between slides
B. Creating charts
C. Formatting text
D. Animating objects
69. Which of the following is a default animation effect in MS PowerPoint?
A. Fade
B. Zoom
C. Spin
D. All of the above
70. Which of the following is used to change the background color of a slide in PowerPoint?
A. Layout
B. Design
C. Transitions
D. Animation
71. How do you start a slideshow from the first slide in PowerPoint?
A. F5
B. Ctrl + S
C. F12
D. Shift + F5
72. In MS PowerPoint, which tab is used to add new slides?
A. Home
B. Insert
C. View
D. Design
73. How can you insert a hyperlink in MS PowerPoint?
A. Insert Tab > Hyperlink
B. Right-click > Hyperlink
C. Home Tab > Hyperlink
D. All of the above
74. Which of the following is used to apply consistent formatting to all slides in MS PowerPoint?
A. Slide Master
B. Layout
C. Format Painter
D. Animation Pane
75. What is the purpose of the "Slide Sorter" view in MS PowerPoint?
A. To view slides in a sequential order
B. To add transitions
C. To modify text
D. To arrange slides
76. How do you delete a slide in MS PowerPoint?
A. Select slide > Press Delete
B. Right-click > Delete
C. Click on the slide and press Backspace
D. All of the above
77. Which feature allows for the embedding of videos in MS PowerPoint?
A. Insert Tab > Video
B. Insert Tab > Media
C. View Tab > Video
D. Home Tab > Video
78. In MS PowerPoint, which of the following is used to create a title slide?
A. Title Slide Layout
B. Title Only Layout
C. Blank Layout
D. Comparison Layout
79. What is the purpose of the "Slide Show" tab in MS PowerPoint?
A. To start a presentation
B. To apply slide transitions
C. To format text
D. To insert images
80. How do you change the slide layout in MS PowerPoint?
A. Right-click the slide > Layout
B. Use the Layout option in the Home tab
C. Press F7
D. All of the above
81. How can you apply an animation to an object in MS PowerPoint?
A. Select object > Animation Tab
B. Right-click object > Add Animation
C. All of the above
D. None of the above
82. Which MS Office application is used for creating databases?
A. Word
B. Excel
C. PowerPoint
D. Access
83. Which MS Office application is primarily used for calculations and data analysis?
A. Word
B. Excel
C. PowerPoint
D. Access
84. How do you insert a chart in MS Excel?
A. Insert Tab > Chart
B. Home Tab > Chart
C. Data Tab > Chart
D. All of the above
85. Which is a feature available in MS Excel?
A. Sorting data
B. Filtering data
C. Creating formulas
D. All of the above
86. Which MS PowerPoint feature is used to add narration to a presentation?
A. Animation
B. Slide Show
C. Recording
D. Review
87. What is the shortcut for saving a PowerPoint presentation?
A. Ctrl + S
B. Ctrl + P
C. Ctrl + C
D. Ctrl + Z
88. Which of the following is a type of network topology?
A. Star
B. Ring
C. Bus
D. All of the above
89. In MS Excel, what does "Ctrl + Z" do?
A. Undo the previous action
B. Redo the previous action
C. Cut data
D. Paste data
90. Which of the following types of networks is used for small geographic areas?
A. LAN
B. WAN
C. MAN
D. WLAN
91. What does HTTP stand for?
A. HyperText Transfer Protocol
B. Hyper Transfer Protocol
C. High-speed Text Protocol
D. None of the above
92. What is the full form of "URL"?
A. Uniform Resource Locator
B. Uniform Resource Language
C. Universal Resource Locator
D. None of the above
93. Which of the following is the primary function of the CPU?
A. Perform calculations
B. Display data
C. Store data
D. Input data
94. Which memory is non-volatile in a computer system?
A. RAM
B. ROM
C. Cache
D. Registers
95. Which of the following devices is an output device?
A. Printer
B. Scanner
C. Keyboard
D. Mouse
96. Which programming language is commonly used to write system software?
A. C
B. Python
C. Java
D. HTML
97. Which of the following is a feature of the "Ribbon" in MS Office applications?
A. Formatting tools
B. File management
C. Help section
D. All of the above
98. In MS Word, which command is used to close a document?
A. Ctrl + C
B. Ctrl + X
C. Ctrl + W
D. Ctrl + S
99. Which of the following is NOT a common use of Information Technology?
A. File management
B. Data processing
C. Physical manufacturing
D. Communication
100. Which of the following is the function of the operating system?
A. Managing hardware resources
B. Providing a platform for applications
C. User interface
D. All of the above
Answer Keys
1. Answer: A 35. Answer: B 69. Answer: D
2. Answer: A 36. Answer: D 70. Answer: B
3. Answer: C 37. Answer: B 71. Answer: A
4. Answer: B 38. Answer: D 72. Answer: A
5. Answer: C 39. Answer: D 73. Answer: D
6. Answer: A 40. Answer: A 74. Answer: A
7. Answer: A 41. Answer: A 75. Answer: D
8. Answer: D 42. Answer: A 76. Answer: D
9. Answer: B 43. Answer: D 77. Answer: A
10. Answer: C 44. Answer: B 78. Answer: A
11. Answer: A 45. Answer: C 79. Answer: A
12. Answer: D 46. Answer: A 80. Answer: B
13. Answer: C 47. Answer: B 81. Answer: C
14. Answer: B 48. Answer: A 82. Answer: D
15. Answer: C 49. Answer: B 83. Answer: B
16. Answer: A 50. Answer: A 84. Answer: D
17. Answer: A 51. Answer: B 85. Answer: A
18. Answer: D 52. Answer: B 86. Answer: C
19. Answer: B 53. Answer: A 87. Answer: A
20. Answer: A 54. Answer: A 88. Answer: D
21. Answer: C 55. Answer: B 89. Answer: A
22. Answer: D 56. Answer: A 90. Answer: A
23. Answer: A 57. Answer: D 91. Answer: D
24. Answer: C 58. Answer: A 92. Answer: C
25. Answer: D 59. Answer: B 93. Answer: C
26. Answer: B 60. Answer: B 94. Answer: A
27. Answer: C 61. Answer: B 95. Answer: A
28. Answer: C 62. Answer: A 96. Answer: A
29. Answer: D 63. Answer: A 97. Answer: B
30. Answer: C 64. Answer: B 98. Answer: A
31. Answer: B 65. Answer: D 99. Answer: A
32. Answer: C 66. Answer: A 100. Answer: A
33. Answer: D 67. Answer: B
34. Answer: A 68. Answer: A
Short Question with Answers
1. Define internet (CO2) (Knowledge)
2. Explain about protocols (CO3) (Understand)
3. What are the two major protocols for accessing email from servers (CO3) (Understand)
4. Explain HTTPS protocols (CO3) (Understand)
5. Define web client (CO2) (Knowledge)
6. What do you mean by web hosting for websites? (CO3) (Understand)
7. How you can insert video in Microsoft Word 2013? (CO2) (Create)
8. Write the installation steps of window 7 (CO2) (Apply)
9. How you can collapse or expand parts of a document? (CO3) (Knowledge)
10. How to add foot-node & end note in word? (CO2) (Understand)
11. How to delete a break in column? (CO3) (Understand)
12. How can install or uninstall the software (CO3) (Understand)
13. What do you mean by cells in an Excel sheet? (CO2) (Understand)
14. What do you mean by cell address? (CO3) (Analyze)
15. Can you add comments to a cell? (CO2) (Understand)
16. Write steps to make the user account (CO4) (Apply)
17. Can you add new rows and columns to an Excel sheet? (CO2) (Understand)
18. Describe window registry (CO3) (Knowledge)
19. What is Ribbon and where does it appear? (CO3) (Analyze)
20. How do you freeze panes in Excel? (CO3) (Understand)
21. Can you protect workbooks in Excel? (CO2) (Understand)
22. Can you protect cells of a sheet from being copied? (CO2) (Understand)
23. What are macros? (CO3) (Analyze)
24. How you can add bookmark to the video in PowerPoint 2013? (CO2) (Understand)
25. How to Align Objects to the Slide? (CO3) (Analyze)
26. What Is The Reading View? (CO4) (Knowledge)
27. How you can insert online video in PowerPoint 2013? (CO4) ( Knowledge)
28. How you can set password in PowerPoint 2013? (CO3) (Analyze)
29. Tell about the windows themes (CO3) (Understand)
30. What is Microsoft outlook (CO2) (Understand)
31. How you can use and Eyedropper Tool in PowerPoint 2013? (CO4) (Understand)
31. What is the short cut key for last action performed and to move the mouse insertion point to the
next panel in PowerPoint 2013? (CO3) (Analyze)
32. Define wireless communication (CO2) (Understand)
33. Can we make PowerPoint slides into PDF files in PowerPoint 2013? (CO4) (Understand)
34. What is web search engine (CO2) (Understand)
35. Define electronic mail (CO2) (Understand)
36. What Is The Slide Show View? (CO3) (Understand)
37. What Is A Backstage View? (CO2) (Understand)
38. Describe advantage of networking (CO3) (Knowledge)
39. Define computer network (CO2) (Understand)
40. Explain peer to peer network (CO3) (Analyze)
41. Define client/server network (CO2) (Understand)
42. Explain LAN (CO3) (Understand)
43. Short note on Star topology (CO4) (Apply)
44. Write a note on ring topology (CO3) (Apply)
45. Disadvantage of Mesh topology (CO4) (Evaluate)
46. Write a note on Ethernet (CO4) (Apply)
47. Define intranet (CO2) (Understand)
48. Explain wide area network (CO3) (Understand)
49. what is Bluetooth (CO2) (Understand)
50. Write a note on wire and wired networking (CO4) (Apply)
Long Question with Answers
Section-A

1. Enlist the features of the Windows 11? (CO2) (Understand)


2. Explain how you can manage archive settings in Microsoft Outlook? (CO4) (Apply)
3. Explain the steps of Restoring Backup Files in windows (CO2) (Understand)
4. Give the steps to change the desktop themes. (CO3) (Understand)
5. How can create a desktop slideshow. Give the steps in detail. (CO2) (Knowledge)
6. Explain how can choose a screen saver (CO3) (Apply)
7. What are desktop gadgets? How can add gadgets on desktop. (CO3) (Understand)
8. What are the advantage windows operating systems? (CO3) (Understand)
9. Explain personalize the desktop background. Give the steps (CO3) (Understand)
10. What are the Basic elements of WINDOWS (CO3) (Understand)
11. What is safe mode in windows? (CO2) (Understand)
12. Explain In windows DNS server what is Primary, Secondary and Stub zone? (CO4) (Apply)
13. What is window explorer? Explain the features of it. (CO3) (Understand)
14. What are the installing steps of window 11? (CO3) (Understand)
15. What is Microsoft Windows? Windows OS is written in which programming language (CO2)
(Understand)
16. What are the steps to change the date and time in windows (CO3) (Analyze)
17. What is my document? Give the detail of folders that are existing in it. (CO4) (Apply)
18. What are the steps involved to change and delete user account password (CO2) (Apply)
19. Explain windows update and service pack (CO3) (Understand)
20. What are the features of system tool in windows (CO4) (Apply)

Section-B

1. What is MS Word & why it is used for? (CO3) (Understand)


2. In MS word how you can create a user entry forms? (CO3) (Understand)
3. How you can insert a picture in your word document in MS word with different ways? (CO2) (Apply)
4. What are the components of MS Word? Explain it. (CO2) (Understand)
5. Explain the main features of MS Word? (CO2) (Understand)
6. How do you add labels to graphs in Word? (CO3) (Apply)
7. How many types of views are there in MS Word? (CO2) (Understand)
8. Explain the difference between footnotes and endnotes? (CO3) (Apply)
9. How do I restrict editing in MS Word? (CO2) (Understand)
10. What is the mail merge? Explain it with example. (CO3) (Understand)
11. How to Create Cross Referencing In Word 2013? (CO3) (Understand)
12. Can I Add Or Remove Items From The Menus In Ms Word? (CO3) (Knowledge)
13. The Speller Would Not Check My Spelling. What Happened? (CO2) (Understand)
14. How Do I Create A Table Of Contents In Ms Word?. (CO2) (Understand)
15. How can fine-tune the paragraph layout in MS Word. (CO4) (Apply)
16. Explain about page setup tool of MS word. (CO2) (Understand)
17. How to insert and delete the column break in MS word. (CO3) (Apply)
18. How do you control what happens when you start MS word. (CO3) (Understand)
19. How do you turn-off the automatic URLs in MS word? (CO3) (Understand)
20. What is the normal template in MS word. (CO3) (Understand)

Section -C

1. what is MS Excel? Give the features in detail. (CO3) (Understand)


2. Explain Pivot tables along with their features? (CO3) (Apply)
3. How do you create Pivot Tables? Give example (CO4)(Knowledge)
4. What are the components of MS Excel? Explain it. (CO4) (Knowledge)
5. How does the VLOOKUP function work? Explain with example. (CO4) (Understand)
6. How would you format a cell? What are the options? Explain it (CO2) (Apply)
7. What is the difference between absolute and relative cell references? (CO2) (Understand)
8. Explain the difference between SUBSTITUTE and REPLACE function in MS-Excel? (CO4) (Apply)
9. How would you highlight cells with errors in it? (CO4) (Apply)
10. What are the different types of errors you can encounter in Excel? (CO4) (Understand)
11. What is MS power point? Give features in detail. (CO2) (Knowledge)
12. Can you insert an online video into a presentation? If yes, how? (CO3) (Apply)
13. Is it possible to convert a presentation into a video? If Yes, How? (CO4) (Understand)
14. What do you understand by Slide view? Give the detail. (CO2) (Knowledge)
16. How to insert a hyperlink to a PowerPoint presentation? (CO3) (Understand)
17. How to get start Live presentation in PowerPoint? (CO4) (Apply)
18 How to group multiple shapes in PowerPoint? (CO4) (Understand)
19. How you can embed a chart from Excel to PowerPoint? (CO3) (Understand)
20. How you can convert text to shapes in PowerPoint 2013? (CO4) (Apply)

Section D

1. Explain advantages and disadvantage of wireless networks.(CO4) (Understand)


(CO2) (Knowledge)
3. What Is A Web Browser? What Is The Purpose Of Web Browser? (CO2) (Knowledge)
4. Explain about the INTERNET history? (CO2) (Knowledge)
5 What are the main services provided by Internet? Explain briefly (CO3) (Apply)
6. What are the applications of Internet? (CO3) (Understand)
7. What Is The Need To Clear Browser Cache? (CO4) (Understand)
8. How Do Search Engines Use Social Signals? (CO4) (Apply)
9. Explain about the different types of transmission Medias in computer networks? (CO2) (Knowledge)
10. What are the various types of error correcting techniques? (CO4) (Understand)
11. What is E-mail? What’s the difference between IMAP and POP3? (CO3) (Apply)
12. Explain HTTP, ISP and SMTP (CO3) (Understand)
13. Explain History of internet (CO4) (Apply)
14. Explain about Inter-network Routing? (CO4) (Apply)
15. What are Peer-to-Peer networks and Server-Based networks? (CO3) (Understand)
16. What is DHCP and how does it work? (CO3) (Understand)
17. What is the difference between MAC address and IP address? (Understand) (CO4)
18. Difference between IPV4 and IPV6 (CO2) (Knowledge)
19 Explain NIC (Network Interface Card)? (CO3) (Apply)
20. What is FTP and how does an FTP work? (CO3) (Understand)

Common questions

Powered by AI

LAN (Local Area Network) is typically used in smaller geographic areas such as a single building or campus, providing high-speed connectivity between computers, which is ideal for organizations with close-proximity workstations requiring efficient resource sharing and communication . WAN (Wide Area Network), on the other hand, spans large geographic areas, connecting multiple LANs over extended distances. WANs are used by corporations and government entities to connect offices in different cities or countries, allowing for communication and data exchange over vast regions .

Key MS Excel components essential for business applications include worksheets, cells, formula bar, and data tables. Features such as PivotTables for summary data analysis, charts for visual data representation, and functions like VLOOKUP, SUM, and AVERAGE for computations are crucial. These components and features enable effective data organization, analysis, and visualization, making MS Excel a powerful tool for financial modeling, data reporting, and decision-making processes in businesses .

Tim Berners-Lee's significant contribution was the invention of the World Wide Web, including the development of HTML, URLs, and HTTP, which laid the groundwork for how information is accessed and shared over the internet . Vint Cerf, often regarded as a 'father of the internet,' co-designed the TCP/IP protocols, enabling different networks to interconnect and communicate with each other, fundamentally shaping the internet's architecture. While Berners-Lee focused on the web, Cerf's work made the global networking aspect of the internet feasible .

The 'Animation' feature in MS PowerPoint allows users to add dynamic visual effects to text and other objects in a presentation, making the content more engaging and helping emphasize key points . The 'Slide Master' feature enables users to maintain a consistent design across all slides by allowing changes to the design themes, fonts, and slide layouts from a central slide layout. This feature saves time and ensures uniformity, enhancing presentation effectiveness .

The 'Find and Replace' feature in MS Word allows users to quickly locate specific text and replace it with new content, enhancing editing efficiency . 'Track Changes' facilitates collaboration by recording changes made by different users, displaying edits and comments, and allowing for easy review and approval of modifications. These features collectively streamline the editing process and improve collaborative efforts by making document revisions transparent and manageable .

In a client/server network, the server hosts, manages, and provides resources and services to client machines. The clients request services from the server and rely on it for centralized management of data and resources. This model allows for efficient data management, scalability, and resource sharing, but also leads to a potential single point of failure at the server end. Centralized security and backups provide advantages in terms of ease of management and data integrity .

Mail Merge in MS Word enhances productivity by allowing users to create multiple personalized documents, such as letters or emails, efficiently from a single template combined with a data source like a spreadsheet. The steps include setting up the main document, connecting to a data source, inserting merge fields, previewing the merge, and completing the merge to generate individual personalized copies for each data entry. This automation reduces manual work and potential errors when dealing with large data volumes .

HTTP, or HyperText Transfer Protocol, is the foundation of data communication on the World Wide Web. It defines how messages are formatted and transmitted, and how web servers and browsers should respond to requests. HTTP is significant because it facilitates the retrieval of linked web pages and resources by enabling client-server communication over the internet. This protocol has been crucial in developing the web as a platform for communication and information exchange, influencing how users access content online .

The introduction of the World Wide Web by Tim Berners-Lee revolutionized global communication by providing a platform for sharing information, linking documents via hypertext, and enabling the development of web browsers for user-friendly access. This innovation democratized information, facilitated e-commerce, and transformed social interactions, making digital communication more accessible and diverse. The WWW has significantly impacted global economies and social structures by enabling rapid information exchange and connectivity .

Mesh topology provides advantages like high redundancy and reliability; if one connection fails, network traffic can be rerouted. However, it is costly and complex to install due to the need for multiple connections . Compared to star topology, mesh offers better fault tolerance. Star topology is easier to manage, with each device connecting to a central hub, but if the hub fails, the entire network is affected, showcasing star's central weakness .

You might also like