Computer Complete Notes

Junior Office Associate Exam Preparation

Miss Mono Academy

Contact: 0323-8324587

PART 1: BASIC COMPUTER FUNDAMENTALS & HARDWARE

1.1 Introduction to Computers
1.1.1 Definition
A computer is an electronic device that accepts data as input, processes it according to a set of instructions, and
produces output. It works on a simple cycle: Input → Process → Output → Storage.
Computer aik electronic machine hai jo data ko input leti hai, usay instructions ke mutabiq process karti hai, aur output
deti hai.

1.1.2 Data vs Information

Data means raw, unorganized facts and figures that have no meaning on their own. Information is data that has been
processed, organized, and structured so that it becomes meaningful and useful.
Data khaali raw facts hote hain jinka apne aap koi matlab nahi hota. Jab usi data ko process kiya jata hai to wo
information ban jati hai jo samajh aaye.

This distinction connects directly to how computers work: the CPU takes in data, processes it, and turns it into
information.

1.2 History of Computers

1.2.1 Charles Babbage
Charles Babbage is known as the Father of the Computer. He designed the Difference Engine and later the Analytical
Engine, which introduced the basic concept of a programmable computer.
Charles Babbage ko computer ka baap kaha jata hai. Unhon ne Difference Engine banaya aur baad mein Analytical
Engine design ki.

1.2.2 Ada Lovelace

Ada Lovelace wrote a detailed set of instructions (an algorithm) for the Analytical Engine. Because this was essentially
the first computer program ever written, she is considered the world's first computer programmer.
Ada Lovelace ne Babbage ki machine ke liye instructions likhe, isi liye unhein pehli programmer mana jata hai.

1.2.3 Alan Turing

Alan Turing is regarded as the father of modern computer science and artificial intelligence. During World War II, he
broke the German Enigma code. He later proposed the Turing Test, a method to check machine intelligence.
Alan Turing ko modern computer science ka baap mana jata hai. WWII mein unhon ne Enigma code toray. Baad mein
Turing Test ka idea diya.

1.2.4 Why History Matters

Babbage gave the machine, Lovelace gave the programming, and Turing gave the theory of intelligence.

1.3 Generations of Computers

1.3.1 First Generation (1940-1956)
Used vacuum tubes for circuitry and magnetic drums for memory. Computers were massive, expensive, and
consumed huge amounts of electricity. Examples: ENIAC, UNIVAC.
Pehli generation mein vacuum tubes use hote thay, is liye computers bade aur mehngay hotay thay.

1.3.2 Second Generation (1956-1963)

Vacuum tubes were replaced by transistors, making computers smaller, faster, cheaper, and more reliable.
Transistors ne vacuum tubes ki jagah li, jis se computers chhotay aur sasty ho gaye.

1.3.3 Third Generation (1964-1971)

Integrated Circuits (ICs) were introduced - many transistors combined onto a single silicon chip. Keyboards and
monitors became standard.
Integrated Circuits (IC) mein bohot se transistors aik chip par fit ho gaye. Isi daur mein keyboard aur monitor aam istemal
hone lage.

1.3.4 Fourth Generation (1971-Present)

The microprocessor was invented using VLSI (Very Large Scale Integration) technology, leading to personal
computers, laptops, and the internet.
Microprocessor mein poora CPU aik chip par aa gaya. Isi wajah se personal computers aur internet mumkin hue.

1.3.5 Fifth Generation (Present & Beyond)

Based on Artificial Intelligence (AI), quantum computing, and parallel processing.
Panchvi generation AI, quantum computing aur parallel processing par mabni hai.

1.4 Hardware vs Software

A computer needs both hardware and software to function.

1.4.1 Hardware
The physical, tangible parts of a computer that can be touched and seen, such as the monitor, keyboard, hard drive,
and motherboard.
Hardware un cheezon ko kaha jata hai jo dekh aur chhoo sakte hain.

1.4.2 Software
A set of instructions, data, or programs used to operate the computer. It is intangible - it cannot be physically touched.
Software instructions ka aik majmua hota hai jo computer ko chalane ke liye use hota hai.

[Link] System Software

Manages and controls the computer hardware itself. Examples: Windows, macOS, Linux.
System software hardware ko manage karta hai.

[Link] Application Software

Runs on top of system software to perform specific user tasks. Examples: MS Word, Excel, web browsers.
Application software system software ke upar chalta hai aur user ka specific kaam karta hai.

1.5 CPU, ALU, and Control Unit

1.5.1 Central Processing Unit (CPU)
Often called the brain of the computer, the CPU executes instructions and processes data through the Fetch →
Decode → Execute cycle.
CPU ko computer ka dimagh kaha jata hai. Yeh Fetch, Decode, Execute cycle mein kaam karta hai.

1.5.2 Arithmetic Logic Unit (ALU)

A part inside the CPU that performs all mathematical calculations and logical operations such as comparisons.
ALU CPU ke andar wo hissa hai jo hisaab aur comparisons karta hai.

1.5.3 Control Unit (CU)

Directs and coordinates the operation of the entire processor, telling memory, ALU, and I/O devices how to respond to
instructions.
Control Unit CPU ke tamam parts ko direct karta hai.

1.6 Types of Computers

1.6.1 Supercomputer
The fastest and most powerful type of computer, used for weather forecasting and scientific research.
Supercomputer sab se tez aur powerful hota hai.

1.6.2 Mainframe Computer

Large, powerful computers used by big organizations for bulk data processing.
Mainframe computer bada aur powerful hota hai, banks jaise organizations use karte hain.

1.6.3 Minicomputer
A mid-sized computer between mainframe and microcomputer.
Minicomputer mainframe aur microcomputer ke darmiyan aata hai.

1.6.4 Microcomputer
A small, low-cost computer using a single microprocessor as its CPU. Includes PCs, laptops, smartphones.
Microcomputer chhota aur sasta hota hai, jaise PC, laptop, smartphone.

1.7 Motherboard Components

The motherboard is the main circuit board that houses the CPU, RAM slots, expansion slots, and connection ports.
Motherboard aik main circuit board hai jisme CPU aur RAM lagte hain.

PART 2: COMPUTER MEMORY

2.1 Primary Memory (Main Memory)
Memory that the CPU can access directly and instantly while processing data.
Yeh wo memory hai jo CPU seedha access karta hai.

2.1.1 RAM (Random Access Memory)

Volatile memory, meaning all data is lost when power is turned off. It temporarily holds active applications.
RAM volatile memory hoti hai, computer band hote hi data khatam ho jata hai.

2.1.2 ROM (Read Only Memory)

Non-volatile memory, retains data permanently. Stores essential startup instructions known as BIOS.
ROM non-volatile memory hoti hai, ismein BIOS save rehta hai.
2.2 Secondary Memory (Auxiliary Storage)
Non-volatile storage used for permanently storing data, files, and installed programs.
Secondary storage permanently data store karti hai.

2.2.1 Hard Disk Drive (HDD)

Uses spinning mechanical platters and a magnetic head - making it slower and more fragile.
HDD purani technology hai jisme mechanical platters ghoomte hain.

2.2.2 Solid State Drive (SSD)

Uses flash memory with no moving parts, making it significantly faster, quieter, and more durable than an HDD.
SSD flash memory use karti hai, is wajah se yeh HDD se zyada tez hoti hai.

2.2.3 USB Flash Drive / Pen Drive

A small, portable solid-state storage device connected via a USB port.
Yeh chhoti, portable storage device hai jo USB port se connect hoti hai.

2.2.4 Optical Discs

CDs, DVDs, and Blu-ray discs use a laser beam to read and write data.
Yeh discs laser light se data read/write karti hain.

2.3 Memory Units

8 bits = 1 Byte | 1024 Bytes = 1 KB | 1024 KB = 1 MB | 1024 MB = 1 GB | 1024 GB = 1 TB
Aik byte 8 bits ke barabar hoti hai. Aik KB 1024 bytes ke barabar hota hai.

PART 3: INPUT AND OUTPUT DEVICES

3.1 Input Devices
Hardware used to send data, commands, and instructions from the user into the computer system.
Input devices wo hardware hote hain jo user ka data computer ke andar bhejte hain.

3.1.1 Keyboard
The primary text-input device, containing alphanumeric keys and function keys (F1-F12).
Keyboard text likhne ke liye primary device hai.

3.1.2 Mouse
A hand-held pointing device used to navigate graphical user interfaces (GUIs).
Mouse se GUI navigate karte hain.

3.1.3 Scanner
Converts physical, paper-based documents and images into digital format.
Scanner kaghaz par likhe documents ko digital form mein badalta hai.

3.1.4 Joystick
A lever-based device used primarily for controlling video games and simulations.
Joystick gaming aur simulations ke liye use hota hai.

3.1.5 Barcode Reader

An optical scanning device that reads printed barcodes attached to products.
Barcode reader products ke barcode scan karta hai.

3.2 Output Devices

Hardware used to display, project, or reproduce processed data.
Output devices CPU ke process kiye hue data ko dikhate ya sunate hain.

3.2.1 Monitor
Displays visual information as a soft copy.
Monitor visual information dikhata hai, isay soft copy kaha jata hai.

3.2.2 Printer
Produces hard copies of documents. Types: Inkjet, Laser, Dot Matrix.
Printer documents ki hard copy nikalta hai.

3.2.3 Speaker
Converts electrical audio signals into sound waves.
Speaker electrical signal ko awaz mein badalta hai.

3.2.4 Plotter
A device used for producing high-quality vector graphics, blueprints, and engineering designs.
Plotter engineering drawings ke liye use hota hai.

PART 4: OPERATING SYSTEM & WINDOWS BASICS

4.1 Operating System Functions
The Operating System (OS) acts as the essential intermediary between hardware and the user or application software.
Operating system hardware aur user ke darmiyan aik zaroori pul ki tarah kaam karta hai.

4.1.1 Process Management

Allocates CPU time fairly among the various programs that are actively running.
Yeh CPU time har chalte hue program ko allot karta hai.

4.1.2 Memory Management

Tracks how much RAM is being used and allocates or frees up space.
Yeh track karta hai ke kitni RAM use ho rahi hai.

4.1.3 File Management

Organizes files and folders using a hierarchical directory system.
Yeh files aur folders ko aik tarteeb mein organize karta hai.

4.1.4 Security
Protects system data through authentication and access controls.
Yeh password aur access controls ke zariye system ko mehfooz rakhta hai.

4.2 File Management & Windows Shortcuts

4.2.1 File Operations
Creating, opening, copying, moving, renaming, and deleting files and folders.
Files ko banana, copy karna, naam badalna aur delete karna.

4.2.2 Recycle Bin

The Recycle Bin is configured by default to store deleted files up to 10 percent of the total size of the hard disk. Once
this limit is reached, older deleted files are permanently removed to make space for new ones.
Recycle Bin default tor par hard disk ke 10 percent size tak deleted files store karta hai, uske baad purani files khud hi
permanently delete ho jati hain.

4.2.3 Directory Structure

A directory structure organizes files in a tree-like hierarchy. The root of a directory structure is the topmost directory on
the disk, from which all other folders branch out.
Directory structure files ko tree ki tarah organize karti hai. Root sab se upar wali directory hoti hai jahan se baaki sab
folders nikalte hain.

4.2.4 File Systems

A file system decides how data is stored and organized on a disk. Common file systems include NTFS (used by
modern Windows, supports large files and security features), FAT32 (older, simpler, used for compatibility across
devices), and EXT (used mainly by Linux systems).
File system yeh decide karta hai ke data disk par kaise store hoga. NTFS naye Windows mein use hota hai, FAT32
purana aur simple hai, EXT Linux mein use hota hai.

4.2.5 Client vs Server Operating Systems

A Client Operating System is designed for individual, everyday use on a personal computer, such as Windows 10. A
Server Operating System is designed to manage and serve resources to multiple users or computers on a network,
such as Windows Server 2016, 2012, or 2003.
Client OS aik akela user ke liye hoti hai, jaise Windows 10. Server OS network par multiple users ko resources dene ke
liye hoti hai, jaise Windows Server.

4.2.2 Important Shortcuts

Shortcut Function

Ctrl + C Copy selected item

Ctrl + V Paste copied item

Ctrl + X Cut selected item

Ctrl + Z Undo last action

Ctrl + Y Redo an action

Ctrl + S Save active file

Ctrl + A Select all items

Alt + F4 Close active window

Alt + Tab Switch between windows

F2 Rename selected item

F5 Refresh
PART 5: MICROSOFT WORD
5.1 Document Creation & Formatting
5.1.1 Text Formatting
Changing font type, size, style (Bold, Italic, Underline), and text color.
Font ka type, size, style aur color change karna.

5.1.2 Paragraph Formatting

Alignment options (Left, Right, Center, Justified), line spacing, indentation, and bullet lists.
Paragraph ki alignment, line spacing aur bullets set karna.

5.1.3 Page Setup

Adjusting margins, page orientation (Portrait vs Landscape), paper size, and page breaks.
Margins, orientation aur paper size set karna.

5.2 Advanced Word Tools

5.2.1 Tables
Inserting and formatting rows and columns, and splitting or merging cells.
Table mein rows/columns insert aur format karna.

5.2.2 Headers and Footers

Adding document titles, page numbers, and dates that repeat automatically on every page.
Page ke upar/neeche title aur page number add karna.

5.2.3 Mail Merge

A feature that creates multiple personalized documents by combining one main document with a data source.
Mail Merge se aik document template ko data source ke sath combine kar ke personalize kiya jata hai.

5.2.4 Important Shortcuts

Shortcut Function

Ctrl + B Bold text

Ctrl + I Italicize text

Ctrl + U Underline text

Ctrl + F Find text

Ctrl + H Find and Replace

PART 6: MICROSOFT EXCEL

6.1 Spreadsheets & Cell Management
6.1.1 Workbook and Worksheet
An Excel file is called a Workbook. Each Workbook can contain one or more Worksheets.
Excel file ko Workbook kaha jata hai, jisme Worksheets hoti hain.
6.1.2 Rows, Columns, and Cells
Rows run horizontally (numbers). Columns run vertically (letters). A Cell is the box where a row and column meet, e.g.
A1.
Cell row aur column ke milne se banta hai, jaise A1.

6.2 Formulas and Functions

6.2.1 Formula Initialization
Every formula in Excel must begin with an equal (=) sign.
Excel mein har formula = sign se shuru hota hai.

6.2.2 Essential Functions

SUM(range) adds numbers. AVERAGE(range) calculates the mean. COUNT(range) counts numeric cells.
COUNTA(range) counts non-empty cells. VLOOKUP() searches a table and returns a related value.
SUM range ke numbers jama karta hai, AVERAGE average nikalta hai, VLOOKUP table mein value dhoondta hai.

6.2.3 Logical Functions

Logical functions test whether a condition is true or false. AND returns true only if all conditions are true. OR returns
true if at least one condition is true. NOT reverses a logical value (true becomes false, and vice versa). Note that SUM
is a mathematical function, not a logical one.
Logical functions check karte hain ke condition sahi hai ya ghalat. AND tab sahi hota hai jab sab conditions sahi hon, OR
tab sahi hota hai jab koi bhi aik condition sahi ho, NOT value ko ulat deta hai.

6.2.4 IF Statement
The correct syntax of the IF function in Excel is: =IF(test, result if True, result if False). It checks a condition and
returns one value if the condition is true, and another value if it is false.
Excel mein IF function ka sahi tareeqa hai: =IF(test, result if True, result if False). Yeh condition check kar ke sahi ya
ghalat ke hisab se result deta hai.

6.2.5 Cell Referencing

When you define a name for a cell or range in Excel, it provides an absolute reference to that cell. A relative reference
changes when copied to another cell (e.g., A1). An absolute reference stays fixed when copied (e.g., $A$1). A mixed
reference locks only the row or only the column (e.g., $A1 or A$1).
Cell ya range ko naam dene se absolute reference milta hai. Relative reference copy karne par change ho jata hai,
absolute reference fix rehta hai, aur mixed reference sirf row ya column ko lock karta hai.

6.2.6 Charts
A chart is a feature of MS Excel used to visually represent data, and it can also be used in PowerPoint to display data
within slides.
Chart Excel ka feature hai jo data ko visually dikhata hai, aur yeh PowerPoint mein bhi use ho sakta hai.

PART 7: MICROSOFT POWERPOINT

7.1 Presentation Basics
7.1.1 Slides
Individual pages of a presentation, containing text, graphics, and multimedia.
Slide presentation ka aik page hota hai.
7.1.2 Templates and Themes
Pre-designed layouts and color schemes for a consistent look.
Yeh presentation ko uniform look dete hain.

7.1.3 Slide Master

A single control point used to apply formatting changes across every slide at once.
Slide Master se aik hi jagah change karo aur sari slides update ho jati hain.

7.2 Animations & Slide Shows

7.2.1 Transitions
Visual effects that play when moving from one slide to the next.
Transition slides ke darmiyan effect hota hai.

7.2.2 Animations
Visual effects applied to individual elements within a single slide.
Animation aik slide ke andar kisi cheez par effect hota hai.

7.2.3 Important Shortcuts

Shortcut Function

F5 Start slideshow from beginning

Shift + F5 Start from current slide

Esc End slideshow

7.2.4 Slide Resolution and Footer

The resolution of slides can be checked and adjusted in the View tab. A footer can be used to insert the date, slide
number, and time on every slide automatically.
Slides ki resolution View tab mein dekhi ja sakti hai. Footer mein date, slide number aur time insert kiya ja sakta hai.

PART 8: INTERNET, WEB BROWSERS & EMAIL

8.1 Internet Fundamentals
8.1.1 World Wide Web (WWW)
Invented by Tim Berners-Lee in 1989. A global system of interlinked documents identified by URLs.
WWW Tim Berners-Lee ne 1989 mein banaya.

8.1.2 Web Browser

Software used to access websites. Examples: Chrome, Firefox, Edge, Safari.
Browser websites dekhne ke liye use hota hai.

8.1.3 Search Engine

A software system that searches the web for information. Examples: Google, Bing, Yahoo.
Search engine internet par information dhoondne ke liye use hota hai.

8.2 Electronic Mail (Email)

8.2.1 Email Inventor
Ray Tomlinson implemented the first email program on ARPANET in 1971 and introduced the @ symbol.
Email Ray Tomlinson ne 1971 mein banaya aur @ symbol introduce kiya.

8.2.2 Email Structure

Username + @ symbol + Domain Name (e.g., user@[Link]).
Email address username, @ symbol aur domain se milta hai.

8.2.3 Key Fields

To: Primary recipient. CC: Visible copies to others. BCC: Hidden copies - other recipients cannot see.
"To" main recipient hai. CC mein sab ko pata chalta hai, BCC mein kisi ko nahi pata chalta.

8.2.4 Cyber Security & Safety

Awareness of phishing emails, spam, suspicious links, and using reliable antivirus tools.
Phishing fake emails hoti hain jo password churane ki koshish karti hain.

PART 9: COMPUTER NETWORKS & BASIC SECURITY

9.1 Network Types & Hardware
9.1.1 LAN (Local Area Network)
Connects computers within a limited geographical area, such as a home or office.
LAN chhoti area ke andar computers ko jorta hai.

9.1.2 WAN (Wide Area Network)

Spans a large geographical distance. The internet is the largest example of a WAN.
WAN bade countries mein failta hai, internet sab se bara WAN hai.

9.1.3 MAN (Metropolitan Area Network)

Covers an area larger than a LAN but smaller than a WAN, typically an entire city.
MAN aik pure shehar ko cover karta hai.

9.1.4 IP Address
A unique numerical label assigned to every device connected to a network.
IP Address har device ka unique number hota hai.

9.1.5 IPv4 Addressing

An IPv4 address is 32 bits long. It is written as four numbers separated by dots (e.g., [Link]), where each
number represents 8 bits.
IPv4 address 32 bits lambi hoti hai, aur char numbers dots se separate ho kar likhi jati hai.

9.1.6 DNS (Domain Name System)

DNS stands for Domain Name System. It translates human-readable website names (like [Link]) into numerical
IP addresses that computers use to identify each other on a network.
DNS website ke naam (jaise [Link]) ko IP address mein tabdeel karta hai taake computers aik doosre ko pehchan
sakein.

9.1.7 Useful Network Commands

ipconfig/all is a command-line tool used in the Windows environment to check detailed IP configuration of a device.
Ping tests whether a connection to another device is working. Telnet is used to remotely connect to another computer
over a network.
ipconfig/all Windows mein IP configuration check karne ke liye use hota hai. Ping connection test karta hai, Telnet
remote computer se connect karta hai.

9.1.8 Network Hardware

Router: connects networks. Switch: connects devices in one network. Modem: converts signals for internet.
Router networks ko jorta hai, switch devices ko jorta hai, modem internet deta hai.

9.2 Computer Threats & Protection

9.2.1 Malware
Malicious software including viruses, trojans, ransomware, and spyware.
Malware nuqsan dene wala software hota hai.

9.2.2 Antivirus Software

Programs designed to detect, prevent, and remove malware threats.
Antivirus in threats ko detect kar ke remove karta hai.

9.2.3 Firewall
A network security system that monitors and controls incoming and outgoing traffic.
Firewall network ke traffic ko control karta hai.

PART 10: IMPORTANT COMPUTER ABBREVIATIONS

10.1 Hardware & Processing
CPU - Central Processing Unit | ALU - Arithmetic Logic Unit | RAM - Random Access Memory | ROM - Read Only
Memory | BIOS - Basic Input/Output System | VLSI - Very Large Scale Integration

10.2 Storage & Memory

HDD - Hard Disk Drive | SSD - Solid State Drive | USB - Universal Serial Bus | KB / MB / GB / TB - Kilobyte / Megabyte
/ Gigabyte / Terabyte

10.3 Software & OS

OS - Operating System | GUI - Graphical User Interface | IDE - Integrated Development Environment

10.4 Internet & Networking

WWW - World Wide Web | URL - Uniform Resource Locator | HTTP - HyperText Transfer Protocol | HTTPS -
HyperText Transfer Protocol Secure | IP - Internet Protocol | IPv4 - Internet Protocol version 4 (32-bit) | DNS - Domain
Name System | ISP - Internet Service Provider | LAN / WAN / MAN / PAN | FTP - File Transfer Protocol | SMTP -
Simple Mail Transfer Protocol | NTFS - New Technology File System

10.5 File Formats

.docx - MS Word | .xlsx - MS Excel | .pptx - MS PowerPoint | .pdf - Portable Document Format
10.6 Security & Modern Tech
VPN - Virtual Private Network | AI - Artificial Intelligence | IoT - Internet of Things

PART 11: PRACTICE MCQs

1. Who is known as the father of the computer?
A) Alan Turing B) Charles Babbage C) Ada Lovelace D) Tim Berners-Lee

2. Who is considered the world's first computer programmer?

A) Ada Lovelace B) Charles Babbage C) Ray Tomlinson D) Alan Turing

3. What is the base of the Binary Number System?

A) 8 B) 10 C) 2 D) 16

4. 1 Byte is equal to how many bits?

A) 4 B) 8 C) 16 D) 32

5. 1 Kilobyte (KB) is equal to how many Bytes?

A) 100 B) 1000 C) 1024 D) 512

6. Which key is used to refresh a web page in a browser?

A) F2 B) F5 C) F1 D) Esc

7. Which shortcut key is used to rename a selected file or folder?

A) F1 B) F2 C) F5 D) Ctrl+R

8. What does 'IP' stand for in networking?

A) Internal Process B) Internet Protocol C) Input Program D) Internet Process

9. Which type of memory is lost when the computer is turned off?

A) ROM B) HDD C) RAM D) SSD

10. What is the extension of MS Word files (Office 2007 and newer)?
A) .doc B) .docx C) .txt D) .word

11. Who invented the World Wide Web?

A) Ray Tomlinson B) Charles Babbage C) Tim Berners-Lee D) Alan Turing

12. Who invented email and introduced the @ symbol?

A) Ray Tomlinson B) Tim Berners-Lee C) Ada Lovelace D) Bill Gates

13. Which memory stores the BIOS?

A) RAM B) ROM C) Cache D) SSD

14. What is the extension of MS Excel files?

A) .xlsx B) .docx C) .pptx D) .exl

15. Which device converts signals to enable internet connectivity?

A) Router B) Switch C) Modem D) Hub

16. What does URL stand for?

A) Universal Record Locator B) Uniform Resource Locator C) United Resource Link D) Universal Resource Link
17. What does GUI stand for?
A) General User Interface B) Graphical User Interface C) Global Unit Interface D) Graphic Unit Input

18. What does VPN stand for?

A) Virtual Public Network B) Virtual Private Network C) Verified Private Network D) Virtual Personal Network

19. Which part of the CPU performs mathematical calculations?

A) Control Unit B) ALU C) RAM D) ROM

20. Which network covers an entire city?

A) LAN B) WAN C) MAN D) PAN

21. How long is an IPv4 address?

A) 128 bits B) 64 bits C) 48 bits D) 32 bits

22. DNS is the abbreviation of:

A) Dynamic Network System B) Domain Name System C) Dynamic Name System D) Domain Network Service

23. Which of the following is a Client Operating System?

A) Windows Server 2003 B) Windows Server 2016 C) Windows Server 2012 D) Windows 10

24. Which command line tool is used in Windows to check IP Configuration in detail?
A) IP B) IPConfig/all C) Ping D) Telnet

25. The Recycle Bin is configured automatically to store files equal to ___ of the size of your hard disk.
A) 1 percent B) 5 percent C) 10 percent D) 15 percent

26. The ___ of a directory structure is the topmost directory on the disk.
A) root B) tree C) subdirectory D) base

27. Which of the following file format is supported in Windows 7?

A) NTFS B) BSD C) EXT D) FAT32

28. ___ is NOT a logical function.

A) AND B) NOT C) OR D) SUM

29. Which is the correct syntax of the IF statement in Excel?

A) =IF(test, result if True, result if False) B) =IF(result if True, result if False) C) =IF(result if False, test, result if
True) D) =(test, result if True, result if False)

30. Defining a name for a cell or range in Excel provides a ___ reference to that cell.
A) relative B) absolute C) mixed D) none of these

31. ___ is a feature of MS Excel and can also be used in PowerPoint.

A) chart B) merge cells C) function D) none of these

32. We press ___ key to start slide show from current slide.
A) Shift+F5 B) Ctr+F5 C) F5 D) Alt+F5

33. Resolution of slides can be seen in ___.

A) animation tab B) home tab C) view tab D) slide show tab

34. Footer can be used to insert ___ in a slide.

A) date B) slide number C) time D) all of these