Wednesday 8 February 2012

BANK EXAMS COMPUTER KNOWLEDGE PRACTICE MCQs

1. Which of the following is not as language for computer programming ?
(a) WINDOWS
(b) PASCAL
(c) BASIC
(d) COBOL
(e) All of these
 
ANSWER: (a)
2. What digits are representative of all binary Numbers?
(H) 0
(b) 1
(c) Both ‘a’ and ‘b’
(d) 3
(e) None of these

ANSWER: (c)
3. The term gigabyte refers to
(a) 1024 bytes
(b) 1024 kilobytes
(c) 1024 megabytes
(d) 1024 gigabytes
(e) None of these

ANSWER: (c)
4. Off-line operation is the operation of devices without the control of
(a) Memory
(b) CPU
(C) ALU
(d) Control unit
(e) None of these

ANSWER: (b)
5. Name the first general purpose electronic computer
(a) ADVAC
(b) ADSAC
(c) UNIVAC
(d) EDVAC
(e) None of these

ANSWER: (c)
6. Which of the following statement is wrong?
(a) Windows XP is an operating system
(b) Linux is owned and sold by Microsoft
(c) Photoshop is a graphical design tool by Adobe
(d) Linux is free and open source software
(e) None of the above

ANSWER: (b)
7. A software used to convert source program instructions to object instruction is known as
(a) Compiler
(b) Assembler
(c) Interpreter
(d) Language processor
(e) None of these

ANSWER: (d)
8. The term ‘Operating System’ means
(a) A set of programs which control computer working
(b) The way a user operates the computer system
(c) Conversion of high level language to machine language
(d) The way computer operator works
(e) None of the above

ANSWER: (a)
9. Input, output and processing devices grouped together represent a(n) ……
(a) Mobile device
(b) Information processing cycle
(c) Circuit boards
(d) Computer system
(e) None of the above

ANSWER: (d)
10. The …… is the box that houses the most Important parts of a computer system.
(a) Software
(b) Hardware
(c) Input device
(d) System unit
(e) None of these

ANSWER: (d)
11. The physical arrangement of elements on a page is referred to as a document’s ……
(a) Features
(b) Format
(c) Pagination
(d) Grid
(d) None of these

ANSWER: (b)
12. All of the following are examples of real security and privacy risks EXCEPT
(a) Hackers
(b) Spam
(c) Viruses
(d) Identity theft
(e) None of these

ANSWER: (b)
13. The ability to recover and read deleted or damaged files from a Criminals computer is an example of a law enforcement specialty called
(a) Robotics
(b) Simulation
(C) Computer forensics
(d) Animation
(e) None of these

ANSWER: (c)
14. This tags, when placed on an animal, can be used to record and track in a database all of the
Animal’s movements
(a) POS C
(b) RFID
(C) PPS
(d) GPS
(e) None of these

ANSWER: (b)
15. These terminals (formerly known as cash Registers) are often connected to complex inventory and sales computer systems
(a) Data
(b) Point-of-sale (POS)
(c) Sales
(d) Query
(e) None of the above

ANSWER: (b)
16. 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 the above

ANSWER: (a)
17. It is the science that attempts to produce machines that display the same type of Intelligence that humans do
(a) Nano science
(b) Nanotechnology
(c) Simulation
(d) Artificial intelligence (AI)
(e) None of the above

ANSWER: (d)
18. 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)
19.Computers gather data, which means that they allow users to
(a) Present data
(B) input data
(C) Output data
(d) Store data
(e) None of these

ANSWER: (b)
20. Which type of data has been organized or presented in a meaningful fashion ?
(a) A process
(b) Software
(C) Storage
(d) Information
(e) None of these

ANSWER: (d)
21. 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)
22. Computers process data into information by working exclusively with
(a) Multimedia
(b) Words
(c) Characters
(d) Numbers
(e) None of these

ANSWER: (d)
23. The term bit is short for
(a) Megabyte
(b) Binary language
(C) Binary digit
(d) Binary number
(e) None of these

ANSWER: (c)
24. In the binary language each letter of the alphabet, each number and each special character is made up of a unique combination of
(a) eight bytes
(b) eight kilobytes
(C) Eight characters
(d) eight bits
(e) None of these

ANSWER: (d)
25. Computers use which language to process data?
(a) Processing
(b) Kilobyte
(C) binary
(d) Representational
(e) None of these

ANSWER: (c)

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.