Bank Clerk computer capsule for mains exam question paper

Before you start reading this i would like to tell you that if you want to join best bank clerk coaching in Delhi visit this page.

Computer capsule for Bank Clerk exams

Data can be represented in various forms depending upon size of data

bit (b)
Byte (B)= 8 bits
1024 B = 1 KB (Kilo Byte)
1024 KB = 1 MB (Mega Byte)

Mbps – mega bits per sec.

MBps – mega Bytes per sec.(see the difference between small and capital B)

Other memory Units

1 GB (Giga Byte)=1024 MB

1024 GB = 1 TB (Tera Byte)

1024 TB = 1 PB (Peta Byte)

1024 PB = 1 XB (Exa Byte)

1024 XB = 1 ZB (Zeta Byte)

1024 ZB = 1 YB (Yota Byte)

bit < Byte < KB < MB < GB < TB < PB < XB < ZB < YB

The information you put into the computer is called Data
Information of a computer is stored as Digital Data
A number system defines a set of values that is used to represent Quantity
In which number system, the modern computers are operated? – Binary Number System
First bit from the left is the most significant bit.

Sign Bit

Which coding scheme represents data in a binary form in the computer system? ASCII, EBCDIC and Unicode are the most commonly used codes under this scheme. We positive number with 1 and negative number with 0.

Binary Coding Scheme

EBCDIC (Extended Binary Coded Decimal Interchange Code) is a 8-Bit code with 256 different representations of characters. It is mainly used in mainframe computers.
In the Hexadecimal Number System numbers from 0 to 9 and characters from A to F to represent numbers 10-15, respectively. It is commonly used as a shortcut notation for groups of four binary digits
BCD is a method that represents the decimal digits with the help of binary digits. It takes advantage that one decimal numeral can be represented by 4-bit pattern. BCD stands for Binary Coded Decimal
This coding system is used to represent the interval storage area of the computers. In this system, every character is represented by a combination of bits. Binary Coding System
The Base or Radix of the decimal number system is 10, Binary numbers 2 and for Hexadecimal numbers 16.
The arithmetic operations (addition, subtraction, multiplication and division) performed on the binary numbers is called Binary Arithmetic
What is the standard code the computer industry created to represent characters? American Standard Code for Information Interchange (ASCII)
ASCII is a code used for standardizing the storage and transfer of information amongst various computing devices.
It is required for representing more than 64 characters. At present, the mostly used coding systems are ASCII and EBCDIC
Which code is also known as Reflected Code? Gray Code
The 7-bit ASCII code is widely used for Two (0 or 1)
In the binary language, each letter of the alphabet, each number and each special character is made up of a unique combination of Eight Bits.

IBPS Clerk computer capsule for Generations of computers

Which was the first general purpose computer, designed to handle both numeric and textual information? Universal Automatic Computer (UNIVAC) (1951)

First Generation (1940-1956) Vacuum Tubes:

The first computers used vacuum tubes for circuitry and magnetic drums for memory, and were often enormous, taking up entire rooms.
The UNIVAC and ENIAC computers are examples of first-generation computing devices.
In first generation of computer, this operating system allowed only one program to run at a time, machine language was used to perform operations and a number of input jobs are grouped for processing, known as Batch Processing.

Second Generation (1956-1963) Transistors:

Transistors replaced vacuum tubes and ushered in the second generation of computers.

Third Generation (1964-1971) Integrated Circuits:

The development of the integrated circuit was the hallmark of the third generation of computers. Transistors were miniaturized and placed on silicon chips, called semiconductors, which drastically increased the speed and efficiency of computers.

Fourth Generation (1971-Present) Microprocessors:

The microprocessor brought the fourth generation of computers, as thousands of integrated circuits were built onto a single silicon chip.
What in the first generation filled an entire room could now fit in the palm of the hand
Fourth generation computers also saw the development of GUIs, the mouse and handheld devices

Fifth Generation (Present and Beyond) Artificial Intelligence:

Fifth generation computing devices, based on artificial intelligence, are still in development, though there are some applications, such as voice recognition, that are being used today.
In 1981 IBM introduced its first computer for the home user, and in 1984 Apple introduced the Macintosh.

Computer Capsule for Clerk Mains exam

– Some Short-Cut Keys”. Seeing the trend of the IBPS Clerk Exam Pattern till now, 1-2 questions can be expected in 2016 IBPS Mains exam.

IBPS Clerk mains : basic short Keys

Ctrl + Shift + Space – Creates a non breaking space
Ctrl + Space – Removes paragraph or character formatting.
Ctrl + B – Makes letters bold
Ctrl + I – Makes letters italic
Ctrl + U – Makes letters underline
Ctrl — – Decreases font size one value
Ctrl ++ – Increases the font size one value
Ctrl + C – Copies the selected text or object
Ctrl + X – Cut the selected text or file
Ctrl + V – Pastes text or file
Ctrl + Alt + V – Paste special
Ctrl + Shift + V – Paste formatting only
Ctrl + Z – Undo the last action
Ctrl + Y – Redo the last action
Ctrl+F4 – Close the window

Shortcut Keys of MS-Excel

F2 – Edit the selected cell
F5 – Go to a specific cell
F7 – Spell check selected text and/or document
F11 – Create chart
Ctrl + ; – Enter the current date
Ctrl + P – Bring up the print dialog box to begin printing
Ctrl + Z – Undo last action
Ctrl + Shift + ; – Enter the current time
Shift + F3 – Open the Excel formula window
Shift + F5 – Bring up search box.
Ctrl + A – Select all contents of the worksheet
Ctrl + F9 – Minimise current workbook
Ctrl + F10 – Maximise currently selected workbook
Ctrl + F6 – Switch between open workbooks/window
Ctrl + Page Up – Move between Excel worksheet in the same Excel document.
Ctrl + Page Down – Move between Excel worksheets in the same Excel

IBPS Clerk computer capsule for Important Abbreviations

We expect 2-3 questions on important abbreviations so try to remember all of them

Al – Artificial intelligence
ALGOL – Algorithmic Language
ARP – Address resolution Protocol
ASCII – American Standard Code for Information Interchange

BINAC – Binary Automatic Computer
BCC – Blind Carbon Copy
Bin – Binary
BASIC – Beginner’s All-purpose Symbolic Instruction Code
BIOS – Basic Input Output System
Bit – Binary Digit
BSNL – Bharat Sanchar Nigam Limited

CC – Carbon Copy
CAD – Computer Aided Design
COBOL – Common Business Oriented Language
CD – Compact Disc
CRT – Cathode Ray Tube
CDR – Compact Disc Recordable
CDROM – Compact Disc Read Only Memory
CDRW – Compact Disc Rewritable
CDR/W – Compact Disk Read/Write

DBA – Data Base Administrator
DBMS – Data Base Management System
DNS – Domain Name System
DPI – Dots Per Inch
DRAM – Dynamic Random Access Memory
DVD – Digital Video Disc/Digital Versatile Disc
DVDR – DVD Recordable
DVDROM – DVD Read Only Memory
DVDRW – DVD Rewritable
DVR – Digital Video Recorder
DOS – Disk Operating System

EBCDIC – Extended Binary Coded Decimal Interchange Code
e-Commerce – Electronic Commerce
EDP – Electronic Data Processing
EEPROM – Electrically Erasable Programmable Read Only Memory
ELM/e-Mail – Electronic Mail
ENIAC – Electronic Numerical Integrator and Computer
EOF – End Of File
EPROM – Erasable Programmable Read Only Memory
EXE – Executable

FAX – Far Away Xerox/ facsimile
FDC – Floppy Disk Controller
FDD – Floppy Disk Drive
FORTRAN – Formula Translation
FS – File System
FTP – File Transfer Protocol

Gb – Gigabit
GB – Gigabyte
GIF – Graphics Interchange Format
GSM – Global System for Mobile Communication

HDD – Hard Disk Drive
HP – Hewlett Packard
HTML – Hyper Text Markup Language
HTTP – Hyper Text Transfer Protocol

IBM – International Business Machine
IM – Instant Message
IMAP – Internet Message Access Protocol
ISP – Internet Service Provider

JPEG – Joint Photographic Experts Group

Kb – Kilobit
KB – Kilobyte
KHz – Kilohertz
Kbps – Kilobit Per Second

LCD – Liquid Crystal Display
LED – Light Emitting Diode
LPI – Lines Per Inch
LIS – Large Scale Integration

Mb – Megabit
MB – Megabyte
MPEG – Moving Picture Experts Group
MMS – Multimedia Message Service
MICR – Magnetic Ink Character reader
MIPS – Million Instructions Per Second

NIC – Network Interface Card
NOS – Network Operating System

OMR – Optical Mark Reader
OOP – Object Oriented Programming
OSS – Open Source Software

PAN – Personal Area Network
PC – Personal Computer
PDA – Personal Digital Assistant
PDF – Portable Document Format
POS – Point Of Sale
PNG – Portable Network Graphics
PPM – Pages Per Minute
PPP – Point-to-Point Protocol
PROM – Programmable Read Only Memory
PSTN – Public Switched Telephone Network
POST – Power On Self Test
PING – Packet Internet Gopher

RAM – Random Access Memory
RDBMS – Relational Data Base Management System
RIP – Routing Information Protocol
RTF – Rich Text Format

SMTP – Simple Mail Transfer Protocol
SQL – Structured Query Language
SRAM – Static Random Access Memory
SNMP – Simple Network Management Protocol
SIM – Subscriber Identification Module

TCP – Transmission Control Protocol
TB – Tera Bytes

UPS – Uninterrupted Power Supply
URI – Uniform Resource Identifier
URL – Uniform Resource Locator
USB – Universal Serial Bus
ULSI – Ultra Large Scale Integration
UNIVAC – Universal Automatic Computer

VAR – Variable
VGA – Video Graphics Array
VSNL – Videsh Sanchar Nigam Limited
VDU – Visual Display Unit

Wi-Fi – Wireless Fidelity
WLAN – Wireless Local Area Network
WPA – Wi-Fi Protected Access
WWW – World Wide Web
WORM – Write Once Read Many

XHTML – eXtensible Hyper text Markup Language
XML – eXtensible Markup language

ZB – Zeta Byte

SBI Clerk computer capsule for History of Computers

ENIAC ( Electronic Numerical Integrator And Computer) was the first electronic general-purpose computer.

KonradZuse invented the World’s first computer was named as the Z1 in 1936. It was the First freely programmable computer.

The first computer game was “Spacewar!”. This game was programmed by Steve Russell and first released in February 1962.

Jack Kilby& Robert Noyce develop the first Integrated Circuit (The Chip) in 1958

In 1954 John Backus & IBM develop first successful high level programming language FORTRAN Computer Programming Language

ARPAnet the first Internet connectivity started in 1969.

WordStar Software is the first release of Word Processors application developed by Seymour Rubenstein & Rob Barnaby in 1979.

Apple Lisa Computer is the first home computer with a GUI (graphical user interface) in 1983

The first web browser was invented by Sir Tim Berners-Lee in 1990. It was called WorldWideWeb (no spaces) and was later renamed Nexus.

The first search engine created was Archie, in 1990 by Alan Emtage, a student of McGill University in Montreal.

On Aug. 6, 1991, Tim Berbers-Lee published the first internet site from CERN, the world’s largest physics lab in Geneva, Switzerland.

The first supercomputer was the Control Data Corporation (CDC) 6600 with a single CPU. It was released in 1964.

India’s first supercomputer is PARAM 8000, which was installed in 1991.

NVIDIA’s Tesla computer was launched in London in December 2008 is first personal supercomputer.

The first banner advertising was used in 1994.

The E-mail is older than the World Wide Web.

The first domain name ever registered was Symbolics.com.

Rich Skrenta generated the first computer virus in February 1982. He is the author of Elk Cloner, the first computer virus to be released outside of the lab.

The first version of Excel was released for the Mac in 1985 and the first Windows version was released in November 1987.

Nobody can create a folder named “Con” in windows system.

TYPEWRITER is the longest word that can be made using the letters only on one row of the keyboard

Each Excel worksheet holds 1,048,576 rows and 16, 384 columns which makes 17,179,869,184 cells per worksheet.

Up to last 100 actions can be undo in excel