WorksheetsComputer Awareness Practice Paper-1 (Worksheet Extraction)
Total questions: 150
Worksheet time: 1hrs 15mins
Which of the following is not true about computer files?
They are collections of data saved to a storage medium.
Every file has a filename.
A file extension is established by the user to indicate the computer on which it was created.
All files contain data.
None of these
Which of the following is not an example of hardware?
MS-WORD
Printer
Monitor
Mouse
Scanner
Which of the following is a secondary memory device?
Keyboard
Disk
ALU
Mouse
Printer
The result of a formula in a cell is the
Label
Value
Range
Displayed value
None of these
Which of the following is not a storage medium?
Hard disk
Flash drive
DVD
CD
Monitor
Choose the odd one out
Micro Computer
Mini Computer
Super Computer
Notebook Computer
Digital Computer
The ALU performs ____ operations.
Logic
ASCII
Algorithm-based
Logarithm-based
Final operations
____ is the part of the computer that does the arithmetical calculations.
OS
ALU
CPU
Memory
Printer
In a sequence of events that takes place in an instruction cycle, the first cycle is
Store cycle
Execute cycle
Fetch cycle
Decode cycle
Code cycle
Peripheral devices such as printers and plotters are considered to be
Hardware
Software
Data
Information
None of these
Which of the following Excel charts represents only one value for each variable?
Function
Line
Pie
Bar
None of these
To see the document before the printout is taken, use
Insert Table
Paste
Format Painter
Cut
Print Preview
ALU works on the instructions and data held in the
Notebook
Registers
Copy Pad
I/O devices
None of these
To move data from one part of the document to another, following is used
Cut and Paste
Copy and Paste
Cut and Delete
Copy and Undo
Cut and Insert
Another name for a preprogrammed formula in Excel is
Range
Graph
Function
Cell
None of these
To save a document for the first time, ____ option is used.
Save as
Save first
Save on
Copy
Paste
What is a device that can change images into codes for the computer?
Mouse
Printer
Joystick
Keyboard
Scanner
Two basic types of graphics used in Word 2000 are
Autoshapes and ClipArt
Header and Footer
Drawing Objects and Pictures
Spelling and Grammar
Word Count
User can use ____ commands to search for and correct words in a document.
Print and Print Preview
Header and Footer
Find and Replace
Spelling and Grammar
Copy and Paste
What is the advantage of using basic HTML to create a document?
HTML is very easy to use
The document can be displayed by all word processors
The document can be displayed by all programmes
The document can be displayed by all browsers
None of these
Which of the following functions is not performed by the CPU?
Graphical Display of Data
Arithmetic Calculations
Managing Memory
Managing Input and Output
None of these
The feature that keeps track of the right margin is
Find and replace
Word wrap
Right justified
Left justified
Ragged right
Keyboard shortcuts are used to move the ____
I-beam
Insertion point
Scroll bar
Mouse
None of these
To specify margins in Word, the user has to select Page Setup option from the ____ menu
Edit
Table
Autocorrect
File
Format
What is the name of the package which helps to create, manipulate and analyse data arranged in rows and columns?
Application package
Word processing package
Outlining package
Outline processors
Spreadsheet package
What does an electronic spreadsheet consist of? (Choose the best answer)
Rows
Columns
Cells
All of these
None of these
ROM is an example of which of the following?
Volatile memory
Cache memory
Nonvolatile memory
Virtual memory
None of these
Which of the following options is used to display information such as title, page number of the document?
Insert Table
Autocorrect
Thesaurus
Spelling and Grammar
Header and Footer
Which part of the computer can display the user's work?
Mouse
Keyboard
Disk Drive
Monitor
None of these
When a computer prints a report, this output is called
Program
Soft copy
Hard copy
Execution
None of these
The processor is a ____ chip plugged onto the motherboard in a computer system.
LSI
VLSI
ULSI
XLSI
WLSI
A register that keeps track of the next instruction to be executed is called a
Data Register
Instruction Register
Action Register
Program Counter
Accumulator
The microprocessor of a computer
Does not understand machine language
Understands machine language and high level languages
Understands only machine language
Understands only high level languages
Understands only assembly language
A set of choices on the screen is called a(n)
Menu
Reverse video
Action plan
Editor
Template
What is the full form of PROM?
Programmable Read-Only Memory
Progressive Read-Only Memory
Periodic Read-Only Memory
Perfect Read-Only Memory
Program Read-Only Memory
Which of these should be used, if sender of e-mail text wants to format it in bold and italic?
Rich Signature
Rich Text
Reach Format
Plain Format
Plain Text
Which of the following words is not related to Internet?
Link
Function Key
Browser
Search Engine
Hyperlink
Which justification aligns the text of a document on both left and right side margins?
Right
Justify
Both sides
Balanced
None of these
What is the full form of LSI?
Low-Scale Internet
Large-Scale Internet
Low-Scale Integration
Large-Scale Integration
Local-Scale Integration
To take any text from its original site to other site without deleting it, is called
Scrolling
Searching
Moving
Copying
Halting
In Excel, which of the following is also called active cell?
Current Cell
Formula
Range
Cell Address
None of these
What is included in e-mail address?
Domain's name and its user's name
User's name and his domain
User's name and his code
User's name and his postal address
User's name and his street address
The secret code which blocks to certain programs is popularly called?
Access code
Passport
Entry code
Password
Keyword
Which of the following type of menu displays further sub-choices?
Reverse
Template
Scrolled
Wrapped
Pull-down
Whenever one receives e-mail from an unknown sender, which of the following must be secured?
Open it to know about sender and reply
Delete it after opening
Delete it without opening
Open it and try to guess who is the sender?
None of these
Mother-board is also known as
Mouse
Computer Board
System Device
Central Board
System Board
With which tool any part of a document can be seen on the screen?
Searching
Pasting
Scrolling
Editing
Copying
With which device Excel is able to calculate dynamically the results from the data?
Go-to
Table
Chart
Diagram
Formula and Function
What kind of storage Hard Disk is?
Non-permanent
Volatile
Temporary
Non-volatile
None of these
Which of the following is a hardware but not a software?
Excel
Printer-driver
Operating System
Power Point
Mouse
Computer uses the number system to store data and perform calculations.
binary
octal
decimal
hexadecimal
None of these
A disk's content that is recorded at the time of manufacture and that cannot be changed or erased by the user is—
Memory-only
Write-only
Once-only
Run-only
Read-only
Which of the following can be used to select the entire document?
CTRL + A
ALT + F5
SHIFT + A
CTRL + K
CTRL + H
Attempts by individuals to obtain confidential information from you by falsifying their identity are—
Phishing
Computer viruses
Spyware scams
Viruses
None of the above
Part number, part description, and number of parts ordered are examples of—
control
output
processing
feedback
input
A Web site's main page is called its—
Home Page
Browser Page
Search Page
Bookmark
None of these
The simultaneous processing of two or more programs by multiple processors is—
multiprogramming
multitasking
time-sharing
multiprocessing
None of these
Codes consisting of lines of varying widths or lengths that are computer-readable are known as—
an ASCII code
a magnetic tape
an OCR scanner
a bar code
None of these
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.
Fit to Form
Format
Autosize
AutoFit
Contents
Why is it unethical to share copy-righted files with your friends?
It is not unethical, because it is legal.
It is unethical because the files are being given for free.
Sharing copyrighted files without permission breaks copy-right laws.
It is not unethical because the files are being given for free.
It is not unethical—anyone can access a computer.
Reusable optical storage will typically have the acronym—
CD
DVD
ROM
RW
ROS
The most common type of storage devices are—
persistent
optical
magnetic
flash
steel
A device that connects to a network without the use of cables is said to be—
distributed
free
centralized
open source
None of these
A person who uses his or her expertise to gain access to other people's computers to get information illegally or do damage is a—
hacker
analyst
instant messenger
programmer
spammer
To access properties of an object, the mouse technique to use is—
dragging
dropping
right-clicking
shift-clicking
None of these
To change selected text to all capital letters, click the change case button, then click—
UPPERCASE
UPPER ALL
CAPS LOCK
Lock Upper
Large Size
The basic unit of a worksheet into which you enter data in Excel is called a—
tab
cell
box
range
None of these
You can keep your personal files/folders in—
My folder
My Documents
My Files
My Text
None of these
In Word you can force a page break—
By positioning your cursor at the appropriate place and pressing the F1 key
By positioning your cursor at the appropriate place and pressing Ctrl+Enter
By using the Insert/Section Break
By changing the font size of your document
None of these
A DVD is an example of a(n)—
hard disk
optical disc
output device
solid-state storage device
None of these
The default view in Excel is view.
Work
Normal
Roman
None of these
The process of transferring files from a computer on the Internet to your computer is called—
downloading
uploading
FTP
JPEG
downsizing
The process of dividing the disk into tracks and sectors is—
Tracking
Formatting
Crashing
Allotting
None of these
Help Menu is available at which button?
End
Start
Turnoff
Restart
Reboot
The contents of are lost when the computer turns off.
storage
input
output
memory
When you save to this, your data will remain intact even when the computer is turned off.
RAM
Motherboard
Secondary storage device
Primary storage device
None of these
A central computer that holds collections of data and programs for many PCs, workstations, and other computers is a(n)—
supercomputer
minicomputer
laptop
server
None of these
The folder retains copies of messages that you have started but are not yet ready to send.
Drafts
Outbox
Address Book
Sent Items
Inbox
Grouping and processing all of a firm's transactions at one time is called—
a database management system
batch processing
a real-time system
an on-line system
None of these
The enables you to simultaneously keep multiple Web pages open in one browser window.
tab box
pop-up helper
tab row
address bar
Esc key
Which ports connect special types of music instruments to sound cards?
BUS
CPU
USB
MIDI
MINI
You can a search by providing more information the search engine can use to select a smaller, more useful set of results.
refine
expand
load
query
slowdown
What is the permanent memory built into your computer called?
RAM
Floppy
CPU
CD-ROM
ROM
What displays the contents of the active cell in Excel?
Namebox
Row Headings
Formulabar
Taskpane
None of these
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
blue cord
tower
modem
None of these
Video processors consist of and which store and process images.
CPU and VGA
CPU and memory
VGA and memory
VGI and DVI
None of these
If you want to connect to your own computer through the Internet from another location, you can use—
FTP
instant message
Telnet
None of these
To reload a Web page, press the button.
Redo
Reload
Restore
Ctrl
Refresh
This first step in the transaction processing cycle captures business data through various modes such as optical scanning or at an electronic commerce website—
Document and report generation
Database maintenance
Transaction processing start-up
Data Entry
None of these
A special visual and audio effect applied in PowerPoint to text or content is a(n)—
animation
flash
wipe
dissolve
None of these
When the pointer is positioned on a , it is shaped like a hand.
grammar error
Formatting error
Screen Tip
Spelling error
hyperlink
Personal computers can be connected together to form a—
server
supercomputer
network
enterprise
None of these
The term used when a search engine returns a Web page that matches the search criteria is—
blog
hit
link
view
success
Words that a programming language has set aside for its own use are—
Control words
Control structures
Reserved words
Reserved keys
None of these
Mobile Commerce is best described as—
The use of Kiosks in marketing
Transporting products
Buying and selling goods/ services through wireless hand-held devices
Using notebook PC's in marketing
None of the above
Which of the following is a storage device that uses rigid, permanently installed magnetic disks to store data/information—
floppy diskette
hard disk
permanent disk
optical disk
None of these
The computer abbreviation KB usually means—
Key Block
Kernel Boot
Key Byte
Kit Bit
Kilo Byte
What is the process of copying software programs from secondary storage media to the hard disk called?
Configuration
Download
Storage
Upload
Installation
In Excel, allows users to bring together copies of work-books that other users have worked on independently.
Copying
Merging
Pasting
Compiling
None of these
Which of the following are advantages of CD-ROM as a storage media?
CD-ROM is an inexpensive way to store large amount of data and information
CD-ROM disks retrieve data and information more quickly than magnetic disks do
CD-ROMs make less errors than magnetic media
All of the above
None of these
allows users to upload files to an online site so they can be viewed and edited from another location.
General-purpose applications
Microsoft Outlook
Web-hosted technology
Office Live
None of these
What feature adjusts the top and bottom margins so that the text is centered vertically on the printed page?
Vertical justifying
Vertical adjusting
Dual centering
Horizontal centering
Vertical centering
Which of these is not a means of personal communication on the Internet?
Chat
Instant messaging
Instanotes
Electronic mail
None of these
What is the overall term for creating, editing, formatting, storing, retrieving and printing a text document?
Word processing
Spreadsheet design
Web design
Database management
Presentation generation
Fourth-generation mobile technology provides enhanced capabilities allowing the transfer of both data types, including full-motion video, high-speed Internet access, and videoconferencing.
Video data and information
Voice and non-voice
Music & video
Video and audio
None of these
is a form of denial of service attack in which a hostile client repeatedly sends SYN packets to every port on the server using fake IP addresses.
Cybergaming crime
Memory shaving
Syn flooding
Software piracy
None of these
Which of these is a point-and-draw device?
Mouse
Scanner
Printer
CD-ROM
Keyboard
The letter and number of the intersecting column and row is the—
cell location
cell position
cell address
cell coordinates
cell contents
A set of rules for telling the computer what operations to perform is called a—
procedural language
structures
natural language
command language
programming language
A detailed written description of the programming cycle and the program, along with the test results and a printout of the program is called—
documentation
output
reporting
spec sheets
directory
Forms that are used to organize business data into rows and columns are called—
transaction sheets
registers
business forms
sheet-spreads
spreadsheets
In PowerPoint, the Header & Footer button can be found on the Insert tab in what group?
Illustrations group
Object group
Text group
Tables group
None of these
is a set of programs designed to manage the resources of a computer, including starting the computer, managing programs, managing memory, and coordinating tasks between input and output devices.
application suite
compiler
input/output system
interface
operating system (OS)
A typical slide in a slide presentation would not include—
photo images
graphs and clip art
clip art and audio clips
full-motion video
content templates
The PC productivity tool that manipulates data organized in rows and columns is called a—
spreadsheet
word processing document
presentation mechanism
database record manager
EDI creator
In the absence of parentheses, the order of operation is—
Exponentiation, addition or subtraction, multiplication or division
Addition or subtraction, multiplication or division, exponentiation
Multiplication or division, exponentiation, addition or subtraction
Exponentiation, multiplication or division, addition or subtraction
Addition or subtraction, exponentiation, Multiplication or division
To find the Paste Special option, you use the Clipboard group on the tab of PowerPoint.
Design
Slide Show
Page Layout
Insert
Home
A program is one that is ready to run and does not need to be altered in any way.
interpreter
high-level
compiler
COBOL
executable
Usually downloaded into folders that hold temporary Internet files, are written to your computer's hard disk by some of the Web sites you visit.
anonymous files
behaviour files
banner ads
large files
cookies
What is the easiest way to change the phrase, revenues, profits, gross margin, to read revenues, profits, and gross margin?
Use the insert mode, position the cursor before the g in gross, then type the word and followed by a space
Use the insert mode, position the cursor after the g in gross, then type the word and followed by a space
Use the overtype mode, position the cursor before the g in gross, then type the word and followed by a space
Use the overtype mode, position the cursor after the g in gross, then type the word and followed by a space
None of these
A program, either talk or music, that is made available in digital format for automatic download over the Internet is called a—
wiki
broadcast
vodcast
blog
podcast
Which PowerPoint view displays each slide of the presentation as a thumbnail and is useful for rearranging slides?
Slide Sorter
Slide Show
Slide Master
Notes Page
Slide Design
Different components on the motherboard of a PC unit are linked together by sets of parallel electrical conducting lines. What are these lines called?
Conductors
Buses
Connectors
Consecutives
None of these
What is the name given to those applications that combine text, sound, graphics, motion video, and/or animation?
motionware
anigraphics
videoscapes
multimedia
maxomedia
A USB communication device that supports data encryption for secure wireless communication for notebook users is called a—
USB wireless network adapter
wireless switch
wireless hub
router
None of these
language reflects the way people think mathematically.
cross-platform programming
3GL business programming
event-driven programming
functional
None of these
When entering text within a document, the Enter key is normally pressed at the end of every—
line
sentence
paragraph
word
file
When a real-time telephone call between people is made over the Internet using computers, it is called—
a chat session
an e-mail
an instant message
Internet telephony
None of these
Which of the following is the first step in sizing a window?
Point to the title bar
Pull down the View menu to display the toolbar
Point to any corner or border
Pull down the View menu and change to large icons
None of these
Which of the following software could assist someone who cannot use their hands for computer input?
Video conferencing
Speech recognition
Audio digitizer
Synthesizer
None of these
a document means the file is transferred from another computer to your computer.
Uploading
Really Simple Syndication (RSS)
Accessing
Downloading
Upgrading
Which computer memory is used for storing programs and data currently being processed by the CPU?
Mass memory
Internal memory
Non-volatile memory
PROM
None of these
Computers that control processes accept data in a continuous—
data traffic pattern
data highway
infinite loop
feedback loop
slot
What refers to a set of characters of a particular design?
Keyface
Formation
Calligraph
Stencil
Typeface
is used by public and private enterprises to publish and share financial information with each other and industry analysts across all computer platforms and the Internet.
Extensible Markup Language (EML)
Extensible Business Reporting Language (XBRL)
Enterprise Application Integration (EAI)
Sales Force Automation (SFA) software
None of these
Which part of the computer is used for calculating and comparing?
ALU
Control unit
Disk unit
Modem
None of these
The method of Internet access that requires a phone line, but offers faster access speeds than dial-up is the connection.
cable access
satellite access
fiber-optic service
digital subscriber line (DSL)
modem
software creates a mirror image of the entire hard disk, including the operating system, applications, files, and data.
Operating system
Backup software
Utility programs
Driver imaging
None of these
What is a URL?
A computer software program
A type of programming object
The address of a document or 'page' on the World Wide Web
An acronym for Unlimited Resources for Learning
A piece of hardware
What is the significance of a faded (dimmed) command in a pulldown menu?
The command is not currently accessible
A dialog box appears if the command is selected
A Help window appears if the command is selected
There are no equivalent keystrokes for the particular command
None of these
Your business has contracted with another company to have them host and run an application for your company over the Internet. The company providing this service to your business is called an—
Internet service provider
Internet access provider
Application service provider
Application access provider
Outsource agency
allows you to access your e-mail from anywhere.
Forum
Webmail interface
Message Board
Weblog
None of these
Which of the following would you find on LinkedIn?
Games
Connections
Chat
Applications
None of these
is a technique that is used to send more than one call over a single line.
Digital transmission
Infrared transmission
Digitizing
Streaming
Multiplexing
The Search Companion can—
Locate all files containing a specified phrase
Restrict its search to a specified set of folders
Locate all files containing a specified phrase and restrict its search to a specified set of folders
Cannot locate all files containing a specified phrase or restrict its search to a specified set of folders
None of these
Which of the following cannot be part of an e-mail address?
Period (.)
At sign (@)
Space ( )
Underscore (_)
None of these
Which of the following must be contained in a URL?
A protocol identifier
The letters, www.
The unique registered domain name
www. and the unique registered domain name
A protocol identifier, www. and the unique registered domain name
Which of the following information systems focuses on making manufacturing processes more efficient and of higher quality?
Computer-aided manufacturing
Computer-integrated manufacturing
Computer-aided software engineering
Computer-aided system engineering
None of these
A mistake in an algorithm that causes incorrect results is called a—
logical error
syntax error
procedural error
compiler error
machine error
A device for changing the connection on a connector to a different configuration is—
a converter
a component
an attachment
an adapter
voltmeter
