Wednesday 8 February 2012

BANK PO EXAM SOLVED PAPER

(Exam held on 18-09-2011)  


1. Computer uses the……….number system to store data and perform calculations.
(A) binary
(B) octal
(C) decimal
(D) hexadecimal
(E) None of these
Ans : (A)

2. A disk's content that is recorded at the time of manufacture and that cannot be changed or erased by the user is–
(A) Memory-only
(B) Write-only
(C) Once-only
(D) Run-only
(E) Read-only
Ans : (E)

3. Which of the following can be used to select the entire document ?
(A) CTRL+A
(B) ALT+F5
(C) SHIFT+A
(D) CTRL+K
(E) CTRL+H
Ans : (A)

4. ……….are 'attempts by individuals to obtain confidential information from you by falsifying their identity.
(A) Phishing
(B) Computer viruses
(C) Spyware scams
(D) Viruses
(E) None of the above
Ans : (A)

5. Part number, part description, and number of parts ordered are examples of–
(A) control
(B) output
(C) processing
(D) feedback
(E) input
Ans : (E)

6. A Web site's main page is called its–
(A) Home Page
(B) Browser Page
(C) Search Page
(D) Bookmark
(E) None of these
Ans : (A)

7. The simultaneous processing of two or more programs by multiple processors is–
(A) multiprogramming
(B) multitasking
(C) time-sharing
(D) multiprocessing
(E) None of these
Ans : (D)

8. Codes consisting of lines of varying widths or lengths that are computer-readable are known as–
(A) an ASCII code
(B) a magnetic tape
(C) an OCR scanner
(D) a bar code
(E) None of these
Ans : (D)

9. To instruct Word to fit the width of a column to the contents of a table automatically, click the button and then point to AutoFit Contents.
(A) Fit to Form
(B) Format
(C) Autosize
(D) Contents
(E) AutoFit
Ans : (E)

10. Why is it unethical to share copyrighted files with your friends ?
(A) It is not unethical, because it is legal.
(B) It is unethical because the files are being given for free.
(C) Sharing copyrighted files without permission breaks copyright laws.
(D) It is not unethical because the files are being given for free.
(E) It is not unethical-anyone can access a computer
Ans : (C)

11. Reusable optical storage will typica1ly have the acronym–
(A) CO
(B) DVD
(C) ROM
(D) RW
(E) ROS
Ans : (D)

12. The most common type of storage devices are–
(A) persistent
(B) optical
(C) magnetic
(D) flash
(E) steel
Ans : (D)

13. A device that connects to a network without the use of cables is said to be–
(A) distributed
(B) free
(C) centralized
(D) open source
(E) None of these
Ans : (B)

14. A person who used his or her expertise to gain access to other people's computers to get information illegally or do damage is a–
(A) hacker
(B) analyst
(C) instant messenger
(D) programmer
(E) spammer
Ans : (A)

15. To access properties of an object, the mouse technique to use is–
(A) dragging
(B) dropping
(C) right-clicking
(D) shift-clicking
(E) None of these
Ans : (C)

16. To change selected text to all capital letters, click the change case button, then click–
(A) UPPERCASE
(B) UPPER ALL
(C) CAPS LOCK
(D) Lock Upper
(E) Large Size
Ans : (A)

17. The basic unit of a worksheet into which you enter data in Excel is called a–
(A) tab
(B) cell
(C) box
(D) range
(E) None of these
Ans : (B)

18. You can keep your personal files / folders in–
(A) My folder
(B) My Documents
(C) My Files
(D) My Text
(E) None of these
Ans : (B)

19. In Word you can force a page break–
(A) By positioning your cursor at the appropriate place and pressing the F1 key
(B) By positioning your cursor at the appropriate place and pressing Ctrl+Enter
(C) By using the Insert/Section Break
(D) By changing the font size of your document
(E) None of these
Ans : (B)

20. A DVD is an example of a(n) –
(A) hard disk
(B) optical disc
(C) output device
(D) solid-state storage device
(E) None of these
Ans : (B)

21. The default view in Excel is……….view.
(A) Work
(B) Auto
(C) Normal
(D) Roman
(E) None of these
Ans : (C)

22. The process of transferring files from a computer on the Internet to your computer is called–
(A) downloading
(B) uploading
(C) FTP
(D) JPEC
(E) downsizing
Ans : (A)

23. ……….is the process of dividing the disk into tracks and sectors.
(A) Tracking
(B) Formatting
(C) Crashing
(D) Allotting
(E) None of these
Ans : (B)

24. Help Menu is available at which button ?
(A) End
(B) Staft
(C) Turnoff
(D) Restart
(E) Reboot
Ans : (B)

25. The contents of……….are lost when the computer turns off.
(A) storage
(B) input
(C) output
(D) memory
(E) None of these
Ans : (D)

26. When you save to this, your data will remain intact even when the computer is turned off–
(A) RAM
(B) Motherboard
(C) Secondary storage device
(D) Primary storage device
(E) None of these
Ans : (C)

27. A central computer that holds collections of data and programs for many PCs, workstations, and other computers is a(n) –
(A) supercomputer
(B) minicomputer
(C) laptop
(D) server
(E) None of these
Ans : (D)

28. The……….folder retains copies of messages that you have started but are not yet ready to send.
(A) Drafts
(B) Outbox
(C) Address Book
(D) Sent Items
(E) Inbox
Ans : (B)

29. Grouping and processing all of a firm's transactions at one time is called–
(A) a database management system
(B) batch processing
(C) a real-time system
(D) an on-line system
(E) None of these
Ans : (B)

30. The……….enables you to simultaneously keep multiple Web pages open in one browser window.
(A) tab box
(B) pop-up helper
(C) tab row
(D) address bar
(E) Esc key
Ans : (C)

31. Which ports connect special types of music instruments to sound cards ?
(A) BUS
(B) CPU
(C) USB
(D) MIDI
(E) MINI
Ans : (C)

32. You can……….a search by providing more information the search engine can use to select a smaller, more useful set of results.
(A) refine
(B) expand
(C) load
(D) query
(E) slowdown
Ans : (A)

33. What is the permanent memory built into your computer called ?
(A) RAM
(B) Floppy
(C) CPU
(D) CO-ROM
(E) ROM
Ans : (E)

34. What displays the contents of the active cell in Excel ?
(A) Name box
(B) Row Headings
(C) Formula bar
(D) Task pane
(E) None of these
Ans : (A)

35. The piece of hardware that converts your computer's digital signal to an analog signal that can travel over telephone lines is called 
(A) red wire
(B) blue cord
(C) tower
(D) modem
(E) None of these
Ans : (D)

36. Video processors consist of……….and………., which store and process images.
(A) CPU and VGA
(B) CPU and memory
(C) VGA and memory
(D) VGI and DVI
(E) None of these
Ans : (C)

37. If you want to connect to your own computer through the Internet from another location, you can use–
(A) e-mail
(B) FTP
(C) instant message
(D) Telnet
(E) None of these
Ans : (D)

38. To reload a Web page, press the……….button.
(A) Redo
(B) Reload
(C) Restore
(D) Ctrl
(E) Refresh
Ans : (E)

39. This first step in the transaction processing cycle captures business data through various modes such as optical scanning or at an electronic commerce website–
(A) Document and report generation
(B) Database maintenance
(C) Transaction processing startup
(D) Data Entry
(E) None of these
Ans : (D)

40. A(n) ……….is a special visual and audio effect applied in Power-point to text or content.
(A) animation
(B) flash
(C) wipe
(D) dissolve
(E) None of these
Ans : (A)

41. When the pointer is positioned on a……….it is shaped like a hand.
(A) grammar error
(B) Formatting error
(C) Screen Tip
(D) Spelling error
(E) hyperlink
Ans : (E)

42. Personal computers can be connected together to form a–
(A) server
(B) supercomputer
(C) network
(D) enterprise
(E) None of these
Ans : (C)

43. A……….is the term used when a search engine returns a Web page that matches the search criteria.
(A) blog
(B) hit
(C) link
(D) view
(E) success
Ans : (E)

44. ……….are words that a programming language has set aside for its own use.
(A) Control words
(B) Control structures
(C) Reserved words
(D) Reserved keys
(E) None of these
Ans : (C)

45. Mobile Commerce is best described as–
(A) The use of Kiosks in marketing
(B) Transporting products
(C) Buying and selling goods/services through wireless handheld devices
(D) Using notebook PC's in marketing
(E) None of the above
Ans : (C)

46. Which of, the following is a storage device that uses rigid, permanently installed magnetic disks to store data/information–
(A) floppy diskette
(B) hard disk
(C) permanent disk
(D) optical disk
(E) None of these
Ans : (B)

47. The computer abbreviation KB usually means–
(A) Key Block
(B) Kernel Boot
(C) Key Byte
(D) Kit Bit
(E) Kilo Byte
Ans : (E)

48. What is the process of copying software programs from secondary storage media to the hard disk called?
(A) Configuration
(B) Download
(C) Storage
(D) Upload
(E) Installation
Ans : (D)

49. In Excel……….allows users to bring together copies of work-books that other users have worked on independently.
(A) Copying
(B) Merging
(C) Pasting
(D) Compiling
(E) None of these
Ans : (B)

50. Which of the following are advantages of CD-ROM as a storage media?
(A) CD-ROM is an inexpensive way to store large, amount of data and information
(B) CD-ROM disks retrieve data and information more quickly than magnetic disks do
(C) CD-ROMs make less errors than magnetic media
(D) An of the above
(E) None of these
Ans : (D)

BANK EXAMS COMPUTER KNOWLEDGE PRACTICE MCQs

. Technology no longer protected by copyright, available to everyone, is considered to be:
(A) proprietary
(B) open
(C) experimental
(D) in the public domain
(E) None of these
Answer: (A)

2. A typical modern computer uses
(A) Magnetic cores
(B) LSI chips
(C) Magnetic tapes
(D) More than 1000 vacuum tubes
(E) None of these
Answer: (B)

3.ALU is called for _____ of a computer
(A) Heart
(B) Master dispatcher
(C) Primary memory
(D) All of the above
(E) None of these
Answer: (C)

4. A single dimensional array is called
(A) List
(B) Subscripts
(C) Matrix
(D) File
(E) None of these
Answer: (A)

5.How many types of drawing objects are available in drawing Tool Bar ?
(A) 4
(B) 5
(C) 10
(D) 12
(E) None of these
Answer: (E)

6.Data processing is___
(A) data collection
(B) similar to computer programming
(C) associated with commercial work
(D) akin to data coding
(E) None of these
Answer: (C)

7.In computer terminology, information means
(A) Raw data
(B) Data in more useful
(C) Alphanumeric data
(D) Program
(E) None of these
Answer: (B)

8.What is meant by the term RAM?
(A) Memory which can only be read
(B) Memory which can be both read and written to
(C) Memory which is used for permanent storage
(D) Memory which can only be written to
(E) None of these
Answer: (B)

9. In UNIX, which command is used to sort the lines of data in a file in reverse order
(A) sort
(B) sh
(C) st
(D) sort –r
(E) None of these
Answer: (D)

10. The commonly used UNIX commands like date, ls, cat etc. are stored in
(A) /dev directory
(B) /bin directory
(C) /tmp directory
(D) /unix directory
(E) None of these
Answer: (B)

11. In UNIX, which command is used to change the protection mode of files starting with the string emp and ending with 1, 2 or 3 ?
(A) Chmod u+x emp[1-3]
(B) Chmod 777 emp*
(C) Chmod u+r ??? emp
(D) Chmod 222 emp ?
(E) None of these
Answer: (A)

12. The variables which can be accessed by all modules in a C program, are known as
(A) Local variables
(B) Internal variables
(C) External variables
(D) Global variables
(E) None of these
Answer: (D)

13. Which computer memory is used for storing programs and data currently being processed by the CPU ?
(A) Mass memory
(B) Internal memory
(C) Non-volatile memory
(D) PROM
(E) None of these
Answer: (B)

14. A record that follws a group of related records and contains data relevant to those records is called as....
(A) Trailer record
(B) Traffic record
(C) Transaction record
(D) Transducer
(E) None of these
Answer: (A)

15. A type of semiconductor memory that usually has small capacity but very fast access is
(A) PROM
(B) RAM
(C) Scratchpad
(D) ROM
(E) None of these
Answer: (C)

16. ____ is the study of molecules and structures whose size ranges from 1 to 100 nanometers.
(A) Nanoscience
(B) Microelectrodes
(C) Computer forensics
(D) Artificial intelligence
(E) None of these
Answer: (A)

17.A single pole, single throw switch with one common line and one output line is
(A) Switch circuit
(B) SPDT switch
(C) SPST switch
(D) Star bit
(E) None of these
Answer: (C)

18.A one-bit signal that indicates the start of data transmission by an asynchronous device is
(A) Parity bit
(B) Status bit
(C) Zero bit
(D) Star bit
(E) None of these
Answer: (D)

19.__ is data that has been organized or presented in a meaningful fashion.
(A) A process
(B) Software
(C) Storage
(D) Information
(E) None of these
Answer: (D)

20. The name for the way that computers manipulate data into information is called
(A) programming
(B) processing
(C) storing
(D) organizing
(E) None of these
Answer: (B)

21. Computers gather data, which means that they allow users to _____ data.
(A) present
(B) input
(C) output
(D) store
(E) None of these
Answer: (B)

22. After a picture has been taken with a digital camera and processed appropriately, the actual print of the picture is considered
(A) data
(B) output
(C) input
(D) the process
(E) None of these
Answer: (B)

23. A circut with about 100 transistors fabricated on a single chip is called
(A) MCR
(B) MSI
(C) MIS
(D) RJE
(E) None of these
Answer: (B)

BANK EXAMS COMPUTER KNOWLEDGE MCQs

1. How many input lines are needed to construct 1024 bit coincident core plane?
(a) 8
(b) 16
(c) 32
(d) 64
(e) None of the above.
ANS: d



2. A digital computer is based on the principle of
(a) measurement
(b) logic
(c) multiplication
(d) counting
ANS: d



3. How many types of storage loops exist in magnetic bubble memory
(a) 8
(b) 4
(c) 16
(d) 2
(e) None of the above
ANS: d



4. The linking of computers with a communication system is called
(a) networking
(b) pairing
(c) interlocking
(d) assembling
ANS: a



5. Standardization means
(a) connecting two computer systems
(b) compatibility between different computer systems from different suppliers.
(c) always using a standard parallel interface
(d) joining a computer user group
ANS: b



6. Which memory is nonvolatile and may be written only once?
(a) RAM
(b) EP-ROM
(c) SRAM
(d) PROM
(e) None of the above.
ANS: c



7. For creating and editing legal documents which application package would be most useful
(a) spreadsheet
(b) word-processing
(c) graphic
(d) communication
ANS: b



8. Word-processing is used for
(a) presentation of data in graphical form
(b) what-if analysis
(c) entry, verifying, updating, retrieving etc. of records
(d) creation, storage, editing etc. of text.
ANS: d



9. Which of the 'following statements is wrong?
(a) An EPROM can be programmed, erased and reprogrammed by the user with an EPROM programming instrument
(b) magnetic tape is non volatile
(c) magnetic core  and semiconductor memories are used as mass memory medium
(d) RAM is a type of volatile memory
(e) None of the above
ANS: c



10. Which of the following program is useful for merging names and address with repetitive letters for mass mailing
(a) word-processing and database integrated program
(b) database management and spreadsheet program
(c) graphics program
(d) communication program
ANS: a



11. The data bus in 8080A/8085 micro-processor is a group of
(a) eight bi-directional lines that are used to transfer 8 bits between the micro-processor and its I/O and memory
(b) sixteen bi-directional lines that are used for data transfer between the micro-processor and memory
(c) eight undirectional lines that are used for I/O devices
(d) eight lines used to transfer data among the registers
(e) None of the above.
ANS: a



12. The operation of a digital computer is based on .....principle.
(a) counting
(b) measuring
(c) electronic
(d) logical
(e) None of the above.
ANS: a



13. DBMS stand for
(a) database marketing system
(b) database management studies
(c) database management system
(d) database marketing strategies
ANS: c



14. An integrated circuit is
(a) a complicated circuit
(b) an integrating device
(c) much costlier than a single transistor
(d) fabricated on a tiny silicon chip
(e) None of the above .
ANS: d

15. A dumb terminal with a keyboard and CRT and connected to a computer is
(a) an off-line device
(b) an on-line device
(c) neither on-line nor off-line device
(d) both (a) and (b)
ANS: b



16. When a bank teller uses a computer terminal to know the balance in a customer's accounts it is an example of ?
(a) on-line updating
(b) off-line processing
(c) on-line query
(d) on-line processing
ANS: c



17. Most important advantage of an IC is its
(a) easy replacement in case of circuit failure
(b) extremely high reliability
(c) reduced cost
(d) low power consumption
(e) None of the above.
ANS: b



18. The concept that many users can share a computer is called
(a) time-sharing
(b) distributed processing
(c) parallel processing
(d) interpersonal relationship
ANS: a



19. Which one of the following words has computer meaning and a computer meaning
(a) node
(b) bus
(c) quick
(d) plotter
ANS: a


20. Which of the following is a computer program
(a) utility software
(b) application package
(c) operating system
(d) all of the above computer programs
ANS: d

21. The computer stores its program and data in its
(a) ALU
(b) control unit
(c) memory
(d) cache memory
ANS: c

22. What is the number of read-write heads in the drive for a 9-track magnetic tape?
(a) 9
(b) 16
(c) 18
(d) 27
(e) None of the above.
ANS: b



23. An operating system
(a) is not required on large computers
(b) is always supplies with computer
(c) is always written in BASIC
(d) consists of programs that help in the operation of computer
ANS: d



24. The number of tracks on a 1/2 inch wide magnetic tape is
(a) 7
(b) 9
(c) 18
(d) 16
(e) None of the above.
ANS: b

25. Which type of computers have really brought the advantages of computers to homes and small business
(a) minicomputers
(b) microcomputers
(c) super computers
(d) mainframes
ANS: b



26. The tangible part of a computer system is called
(a) input data
(b) output data
(c) software
(d) hardware
ANS: d



27. Large computers which can process huge data at high speeds are known as
(a) networks
(b) minicomputers
(c) microcomputers
(e) mainframes
ANS: c



28. What is the most common speed in rpm at which the hard disk usually rotate
(a) 2400
(b) 3600
(c) 4700
(d) 1600
ANS: b



29. Computerized railway reservation system is an example of
(a) on-line application
(b) off-line application
(c) both (a) and (b)
(d) None of the above.
ANS: a


30. Managers who have no technical knowledge about a computer can be easily trained to operate a/an
(a) minicomputer
(b) personal computer
(c) super computer
(d) microcomputer
ANS: b

BANK EXAMS COMPUTER KNOWLEDGE MCQs

1. The use of computer work stations to send and receive messages is known as
(a) electronic funds transfer
(b) electronic message switching
(c) electronic mail
(d) electronic publishing
ANS: c


2. Protecting the data from unauthorized access is called
(a) data inaccessibility
(b) data encryption
(c) data security
(d) data validity
ANS: c



3. What is true about supercomputers
(a) they can fit on a single small chip
(b) they are found at thousands of places around the world
(c) they cost only few thousand rupee
(d) they can process billions of operations in a second
ANS: d



4. In a distributed computer system
(a) there are many computers and terminals
(b) the task is executed by a number of processors
(c) the task is distributed throughout the system
(d) All of the above.
ANS: c



5. A computer programming language often used by children is
(a) LOGO
(b) PILOT
(c) BASIC
(d) PASCAL
ANS: a



6. The linking of computers with a communication system is called
(a) networking
(b) pairing
(c) interfacing
(d) assembling
ANS: a



7. The software generally used for what-if analysis is related to
(a) word-processing
(b) graphics
(c) database management
(d) None of the above
ANS: d



8. Distributed data entry means that data can be
(a) entered at different locations where it originates
(b) sent to different locations from a central place
(c) accessed from different places know as distribution points
(d) distributed through a network
ANS: a



9. Software documentation refers to
(a) anything written about how the software is designed or functions
(b) the documents which, the user has to sign before using the software legally
(c) the compatibility of the software with IBM-PC
(d) None of the above.
ANS: a



10. If a home computer user wants access to national database networks he/she at least requires
(a) a microcomputer, a modem, a telephone line
(b) a microcomputer, a tele-printer, a telephone line
(c) a microcomputer, communications soft-ware, a telephone line
(d) a microcomputer, a modem, communications software, a telephone line
ANS: d



11. Which of the following factors does not affect the total time taken to generate by using computers?
(a) entry of data
(b) complexity of calculations to be performed
(c) type and format of output required
(d) power of the processor
(e) speed of the printer
(f) place where the computer is kept
ANS: f



12. Which of the following functions of a computer is wrong?
(a) it obtains data from an input device
(b) it processes the data and delivers the final results to an output device
(c) it takes processing steps from the list of instructions called program
(d) it stores the program and data in memory.
(e) It generates the program on its own.
ANS: e



13. The heart of a computer is
(a) CPU
(b) Memory
(c) I/O Unit
(d) Disks
ANS: a

14. A computer consists of
(a) a central processing unit
(b) a memory
(c) input and output units
(d) All the above.
ANS: d



15. Which of the following is not used as secondary storage?
(a) semiconductor memory
(b) magnetic disks
(c) magnetic drums
(d) magnetic tapes
ANS: a



16. Which of the following memory is capable of operating at electronics speed?
(a) semiconductor memory
(b) magnetic disks
(c) magnetic drums
(d) magnetic tapes
ANS: a



17. Which of the following is responsible for coordinating various operations using timing signals?
(a) Arithmetic-logic unit
(b) Control unit
(c) Memory unit
(b) I/O unit
ANS: b



18. The ALU of a computer normally contains a number of high speed storage elements called
(a) semiconductor memory
(b) registers
(c) hard disk
(d) magnetic disk
ANS: b



19. Memories in which any location can be reached in a fixed (and short) amount of time after specifying its address is called
(a) sequential-access memory
(b)  random-access memory
(c) secondary memory
(d) mass storage
ANS: b



20. Which of the following is the fastest?
(a) CPU
(b) Magnetic tapes and disks
(c) Video terminal
(d) Sensors, mechanical controllers
ANS: a



21. Modern computers do not work with decimal numbers. Instead, they process binary numbers i.e., groups of Os and 1s because
(a) electronic devices are most reliable when designed for two state (binary) operation
(b) binary circuits are simple
(c) memory is only possible for binary numbers
(d) with decimal numbers, the circuits are complex and costly
(e) with decimal numbers, processing speed is slow
ANS: a



22. A computer can be defined as an electronic device that can (choose the most precise definition)
(a) carry out arithmetical operations
(b) carry out logical functions
(c) do complicated calculations
(d) accept and process data by implementing sequentially a set of stored instructions.
(e) Present information to the operator on a visual display unit
ANS: d



23. Stored instructions and data in digital computers consists of
(a) alphabets
(b) numerals
(c) characters
(d) scripts
(e) bits
ANS: e



24. A digital computer performs its computations by
(a) mechanical means
(b) analogy
(c) guessing
(d) counting
(e) None of the above.
ANS: d



25. Binary coded decimal (BCD) numbers express each decimal digitals as
(a) binary digits
(b) digits and strings
(c) nibble
(d) word
(e) byte
ANS: c



26. The basic operation performed by a computer is
(a) arithmetic operations
(b) logic operations
(c) storage and retrieval operations ../(d) all the above
(e) None of the above.
ANS: d



27. Who is regarded as the Father of computers?
(a) Abascus
(b) John Napier
(c) Pascal
(c) Charles Babbage
(e) Hollerith
ANS: c



28. The analog computer deals directly with
(a) number or codes
(b) measured values of continuous physical magnitude
(c) signals in the form of 0 or 1
(d) signals in discrete values from 0 to 9
ANS: b



29. Transistor was invented in
(a) 1945
(b) 1946
(c) 1947
(d) 1948
ANS: d



30. Integrated circuits are classified according to the
(a) no. of chips
(b) no. of vacuum tube
(c) no. of gates
(d) no. of transistor
ANS: c



31. 1 K bits equals to the
(a) 1000 bits
(b) 100 bits
(c) 1024 bits
(d) 10 bits
ANS: c



32. The first microprocessor was introduced in
(a) 1971
(b) 1972
(c) 1973
(d) 1974
ANS: a



33. In terms of processing power there is a class of computers between minicomputers and microcomputers known as
(a) Supercomputer
(b) Mainframe
(c) Personal computer
(d) Workstation
ANS: d



34. The biggest manufacturer of workstations is
(a) Sun Microsystems
(b) IBM
(c) DEC
(d) HP
ANS: a



35. The first AT Systems have
(a) 12 bit ISA Bus
(b) 14 bit ISA Bus
(c) 16 bit ISA Bus
(d) 18 bit ISA Bus
ANS: c

Tuesday 7 February 2012

Microsoft Excel shortcut keys

F2Edit the selected cell.
F5Go to a specific cell. For example, C6.
F7Spell check selected text or document.
F11Create chart.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Alt + Shift + F1Insert New Worksheet.
Shift + F3Open the Excel formula window.
Shift + F5Bring up search box.
Ctrl + ASelect all contents of the worksheet.
Ctrl + BBold highlighted selection.
Ctrl + IItalic highlighted selection.
Ctrl + KInsert link.
Ctrl + UUnderline highlighted selection.
Ctrl + 5Strikethrough highlighted selection.
Ctrl + PBring up the print dialog box to begin printing.
Ctrl + ZUndo last action.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize currently selected window.
Ctrl + F6Switch between open workbooks / windows.
Ctrl + Page upMove between Excel work sheets in the same Excel document.
Ctrl + Page downMove between Excel work sheets in the same Excel document.
Ctrl + TabMove between Two or more open Excel files.
Alt + =Create a formula to sum all of the above cells
Ctrl + 'Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !Format number in comma format.
Ctrl + Shift + $Format number in currency format.
Ctrl + Shift + #Format number in date format.
Ctrl + Shift + %Format number in percentage format.
Ctrl + Shift + ^Format number in scientific format.
Ctrl + Shift + @Format number in time format.
Ctrl + Arrow keyMove to next section of text.
Ctrl + SpaceSelect entire column.
Shift + SpaceSelect entire row.

Microsoft Word shortcut keys

Ctrl + 0Adds or removes 6pts of spacing before a paragraph.
Ctrl + ASelect all contents of the page.
Ctrl + BBold highlighted selection.
Ctrl + CCopy selected text.
Ctrl + EAligns the line or selected text to the center of the screen.
Ctrl + FOpen find box.
Ctrl + IItalic highlighted selection.
Ctrl + JAligns the selected text or line to justify the screen.
Ctrl + KInsert link.
Ctrl + LAligns the line or selected text to the left of the screen.
Ctrl + MIndent the paragraph.
Ctrl + POpen the print window.
Ctrl + RAligns the line or selected text to the right of the screen.
Ctrl + TCreate a hanging indent.
Ctrl + UUnderline highlighted selection.
Ctrl + VPaste.
Ctrl + XCut selected text.
Ctrl + YRedo the last action performed.
Ctrl + ZUndo last action.
Ctrl + Shift + LQuickly create a bullet point.
Ctrl + Shift + FChange the font.
Ctrl + Shift + >Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ]Increase selected font +1pts.
Ctrl + Shift + <Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [Decrease selected font -1pts.
Ctrl + / + cInsert a cent sign (¢).
Ctrl + ' + Insert a character with an accent (grave) mark, where is the character you want. For example, if you wanted an accented è you would use Ctrl + ' + e as your shortcut key. To reverse the accent mark use the opposite accent mark, often on the tilde key.
Ctrl + Shift + *View or hide non printing characters.
Ctrl + Moves one word to the left.
Ctrl + Moves one word to the right.
Ctrl + Moves to the beginning of the line or paragraph.
Ctrl + Moves to the end of the paragraph.
Ctrl + DelDeletes word to right of cursor.
Ctrl + BackspaceDeletes word to left of cursor.
Ctrl + EndMoves the cursor to the end of the document.
Ctrl + HomeMoves the cursor to the beginning of the document.
Ctrl + SpacebarReset highlighted text to the default font.
Ctrl + 1Single-space lines.
Ctrl + 2Double-space lines.
Ctrl + 51.5-line spacing.
Ctrl + Alt + 1Changes text to heading 1.
Ctrl + Alt + 2Changes text to heading 2.
Ctrl + Alt + 3Changes text to heading 3.
Alt + Ctrl + F2Open new document.
Ctrl + F1Open the Task Pane.
Ctrl + F2Display the print preview.
Ctrl + Shift + >Increases the highlighted text size by one.
Ctrl + Shift + <Decreases the highlighted text size by one.
Ctrl + Shift + F6Opens to another open Microsoft Word document.
Ctrl + Shift + F12Prints the document.
F1Open Help.
F4Repeat the last action performed (Word 2000+)
F5Open the find, replace, and go to window in Microsoft Word.
F7Spellcheck and grammar check selected text or document.
F12Save as.
Shift + F3Change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
Shift + F7Runs a Thesaurus check on the word highlighted.
Shift + F12Save.
Shift + EnterCreate a soft break instead of a new paragraph.
Shift + InsertPaste.
Shift + Alt + DInsert the current date.
Shift + Alt + TInsert the current time.

Sunday 1 January 2012

IBPS COMPUTER KNOWLEDGE PRACTICE QUESTIONS

1. One megabyte equals approximately
1) 1,000 bits
2) 1,000 bytes
3) 1 million bytes
4) 1 million bits
5) 2,000 bytes
2. Data going into the computer is called?
1) Output
2) Algorithm
3) Input
4) Calculations
5) Flowchart
3. Which of the following refers to the memory in your computer?
1) RAM
2) DSL
3) USB
4) LAN
5) CPU
4. When you are working on a document on PC, where is the document temporarily stored?
1) RAM
2) ROM
3) The CPU
4) Flash memory
5) The CD-Rom
5. Information travels between components on the mother board through-
1) Flash memory
2) CMOS
3)Bays
4) Buses
5) Peripherals
6. How are data organised in a spreadsheet?
1) Lines and spaces
2) Layers and planes
3) Height and width
4) Rows and columns
5) None of these
7. Which of the following is true?
1) Byte is a single digit in a binary number
2) Bit represents a grouping of digital numbers
3) Eight-digit binary number is called a byte
4) Eight-digit binary number is called a bit
5) None of these
8. Transformation of input into output is performed by?
1) Peripherals
2) Memory
3) Storage
4) The Input-Output unit
5) The CPU
9. How many options does a binary choice offer?
1) None
2) One
3) Two
4) It depends on the amount of memory in the computer
5) It depends on the speed of the computer's processor
10. .....is collection of web pages and ......is the very first page that we see on opening of a web-site
1) Home-page, Web-page
2) Web-site, Home-page
3) Web-page, Home-page
4) Web-page, Web-site
5) None of these
11. When the pointer is positioned on a _____ it is shaped like a hand.
1) Grammar error
2) Hyperlink
3) Screen tip
4) Spelling error
5) Formatting error
12. The _____ of a system includes the programs or instructions.
1) Hardware
2) Icon
3) Information
4) Software
5) None of these
13. 'www' stands for _____
1) World Word Web
2) World Wide Web
3) World White Web
4) World Work Web
5) None of these
14. What menu is selected to cut, copy, and paste?
1) File
2) Tools
3) Special
4) Edit
5) None
15. You can use the tab key to
1) Move a cursor across the screen
2) Indent a paragraph
3) Move the cursor down the screen
4) Only (1) and (2)
5) None of these
16. The most important or powerful computer in a typical network is _____
1) Desktop
2) Network client
3) Network server
4) Network station
5) None of these
17. Which of the following is an example of connectivity?
1) Internet
2) Floppy disk
3) Power cord
4) Data
5) None of these
18. The ability to find an individual item in a file immediately _____ is used.
1) File allocation table
2) Directory
3) Sequential access
4) Direct access
5) None of these
19. The primary purpose of software is to turn data into _____
1) Web sites
2) Information
3) Programs
4) Objects
5) None of these
20. To what temporary area can you store text and other data, and later paste them to another location?
1) The clipboard
2) ROM
3) CD-ROM
4) The hard disk
5) None of these
21. Storage that retains its data after the power is tuned off is referred to as
1) volatile storage
2) non-volatile storage
3) sequential storage
4) direct storage
5) None of these
22. _____is the science that attempts to produce machines that display the same type of intelligence that humans do.
1) Nano science
2) Nanotechnology
3) Simulation
4) Artificial intelligence (AI)
5) None of these
23. Changing an existing document is called _____ the document.
1) Creating
2) Editing
3) Modifying
4) Adjusting
5) None of these
24. Computers use the _____ number system to store data and perform calculations.
1) Decimal
2) Hexadecimal
3) Octal
4) Binary
5) None of these
25. Which of the following is the largest unit of storage?
1) GB
2) KB
3) MB
4) TB
5) None of these
26. The _____ key will launch the start buttons.
1) Esc
2) Shift
3) Windows
4) Shortcut
5) None of these
27. _____is the process of finding errors in software code.
1) Compiling
2) Testing
3) Running
4) Debugging
5) None of these
28. To move to the beginning of a line of text, press the _____ key.
1) Home
2) A
3) Page-up
4) Enter
5) None of these
29. Virtual memory is
1) Memory on the hard disk that the CPU uses as an extended RAM
2) RAM
3) Only necessary if you do not have any RAM in your computer
4) A back up device for floppy disks
5) None of these
30. A _____ contains specific rules and words that express the logical steps of an algorithm.
1) Syntax
2) Programming structure
3) Programming language
4) Logic chart
5) None of these
31. When sending an e-mail, the _____ line describes the contents of the message.
1) to
2) subject
3) contents
4) CC
5) None of these
32. The _____ tells the computer how to use its components.
1) Utility
2) Network
3) Operating system
4) Application program
5) None of these
33. Which grouping do you work with when formatting text in word?
1) Tables, paragraphs and indexes
2) Paragraphs, indexes and sections
3) Characters, sections and paragraphs
4) Indexes, characters and tables
5) None of these
34. What is backup?
1) Adding more components to your network
2) Protecting data by copying it from the original source to a different destination
3) Filtering old data from the new data
4) Accessing data on tape
5) None of these
35. Network components are connected to the same cable in the _____ topology.
1) Star
2) Ring
3) Bus
4) Mesh
5) Mixed
36. This component is required to process data into information and consists of integrated circuits.
1) Hard disk
2) RAM
3) CPU
4) ROM
5) None of these
37. One advantage of dial-up-internet access is ___
1) It utilises broadband technology
2) It utilizes existing telephone service
3) It uses a router for security
4) Modem speeds are very fast
5) None of these
38. What is the term for unsolicited e-mail?
1) News group
2) Use net
3) Backbone
4) Flaming
5) Spam
39. Two or more computers connected to each other of sharing information form a _____
1) Network
2) Router
3) Server
4) Tunnel
5) Pipeline
40. Computers that are portable and convenient for users who travel are known as _____
1) Super computers
2) Lap tops
3) Mini computers
4) File servers
5) None of these
41. A computer checks the _____ of user names and passwords for a match before granting access.
1) Website
2) Network
3) Backup file
4) Data base
5) None of these
42. Office LANs that are spread geographically apart on a large scale can be connected using a corporate _____
1) CAN
2) LAN
3) DAN
4) WAN
5) TAN
43. The code for a Web page is written using _____
1) A fifth generation language
2) Win Zip
3) Peripherals
4) Hypertext Markup Language
5) URL
44. What is the process of copying software programs from secondary storage media to the hard disk called?
1) Configuration
2) Download
3) Storage
4) Upload
5) Installation
45. Small application programs that run on a web page and may ensure a form is completed properly or provide animation are known as _____
1) Flash
2) Spiders
3) Cookies
4) Applets
5) Sparks
46. The first computers were programmed using _____
1) Assembly language
2) Machine language
3) Source code
4) Object code
5) Spaghetti code
47. Which process checks to ensure the components of the computer and operating are connected properly?
1) Booting
2) Processing
3) Saving
4) Editing
5) None of these
48. In a relational database, this is a data structure that organizes the information about a single topic into rows and columns.
1) Block
2) Record
3) Tuple
4) Table
5) Command line interface
49. How can the user determine what programs are available on a computer?
1) Checking the hard disk properties
2) Viewing the installed programs during the booting process
3) Checking the operating system for a list of installed programs.
4) Checking the existing files saved on the disk
5) None of these
50. When we run a program in HTML coding _____ is used as backend and ____ works as front-end.
1) Notepad - Internet-Explorer
2) Notepad - Msn-messenger
3) MS-Word - Internet Explorer
4) Both (1) and (2)
5) None of these

ANSWERS:
1)3 2)3 3)1 4)1 5)4 6)3 7)3 8)5 9)3 10)2 11)2 12)4 13)2 14)4 15)2 16)3 17)1 18)1 19)2 20)1 21)2 22)4 23)2 24)4 25)4 26)3 27)4 28)1 29)2 30)3 31)2 32)3 33)1 34)2 35)2 36)3 37)2 38)5 39)1 40)2 41)4 42)4 43)4 44)5 45)4 46)2 47)1 48)4 49)4 50)1