Q1.What is mainframe computer?
Ans: big,
powerful, expensive computers used in the background by large organizations.
Q2.What is a PC?
Ans: PC-
personal computer It is a micro-computer. It is a general purpose computer
whose size, capabilities and price is limited which make it useful for
individuals.
Q3.What is Mac?
Ans: The Apple
Mac is a computer. It uses different operating system. It requires special
version of application program.
Q4.What is a networked computer?
Ans: A network
computer allows to connect two or more computers together.
Q5.What is laptop?
Ans: Laptop a
small portable which run on batteries as well as main power
Q6.What is PDA?
Ans: Personal Digital Assistant It is a
small size computer/device. It uses special pen rather than keyboard. It is used for storing and retrieving
information.
Q7.What are input devices?
Ans: Allows to
input information to the computer.
Q8.What are output devices?
Ans: Allows to
output information from computer.
Q9.What is peripheral device?
Ans: Device
which can be attached to computer it’s called peripheral Device.
Q10.Write some factors which impact on a
computer performance?
Ans: i. CPU
speed ii. RAM size iii. Graphics card processor and memory iv. Number of
applications running.
Q11.What is computer memory?
Ans: Computer
memories are the devices. They store information temporarily/virtually or
permanently/physically.
Q12.What is ROM?
Ans: ROM- Read
only memory It is a memory. It holds software which can be read but not written
to. It contains software which first starts the computer & load the operating system to the ram.
Q13.What is video(graphics) memory?
Ans: It is a
memory. It is used to store picture which is displayed on monitor.
Q14.What is an operating system?
Ans: Operating
system is a special software its called
system software also. It loads automatically when we press power button
to run computer for using advanced features of Operating system.
Q15.What is an application program?
Ans: Application
program is a software which is used by user to perform their daily task. It is
operated by operating system.
Q16.What is LAN?
Ans: LAN – local
area network PCs are connected together using cables or wireless. It is used in
short area.
Q17.What is WAN?
Ans: WAN – wide
area network. Allows connecting to other computers over a wider area.
Q18.What is WLAN?
Ans: WLAN – wireless local area network. Allows to
connect two or more computer within LAN without cables.
Q19.What does client/server mean?
Ans: Resources
are kept centrally on the server and used locally by the client.
Q20.What is difference between internet
and intranet?
Ans: Internet is
a global network of interconnected networks. Intranet is network which can be
accessed by authorized members of an organization.
Q21. What is the difference between
intranet and extranet?
Ans: An extranet
is an intranet which is partially accessible to authorized outsiders, Who have
been issued a password. An intranet is normally only accessible by members of
the same company or organization.
Q22. What is E-commerce? What is its
advantages or disadvantage?
Ans: Buying or
selling via the internet. Advantage:
i. Service
available 24/7
ii. Detailed
product description
iii. Large stock
range
iv. Equal
delivery town or country.
v. Returning
Facility of Defective Goods.
Disadvantages:
i. Possible
credit card fraud.
ii. Cannot talk
to real person
iii. Website may
not be genuine.
iv. How are you
covered when you purchase goods from another country?
Q23.what is E-banking? What is its
advantages or disadvantage?
Ans: Managing
money online instead of heaving to go to the local branch.
Advantage:
1. Bank cost can
be reduced
2. 24 – hour
access to banking service
3. Moving money
from place to another place.
Disadvantages:
1. No physical
person to make complain.
2. Poor security
of online system may loose user bank balance.
3. Create many
jobless in the Banking sector.
Q24.what are the advantages of
E-government?
Ans: i. Census
ii. vehicle registration. iv. Revenue collection v. Electronic voting
Q25.what is E-learning? What is its
advantages or disadvantage?
Ans: Learning
via internet
Advantages: i. Distance learning system.
ii. Can use
internet as homework resource
iii. Cheaper
iv. Learning
facilities is available 24/7
Disadvantages:
i. May be no
opportunity to ask question to a real person.
ii. Connection
may temporarily fail.
iii. Download
speed may be too slow for some forms of e-learning.
Q26.what is tele-working? What is its
advantages or disadvantage?
Ans: People
working at home connected to the rest of the organization via computer network.
Advantages: i. Reduced or zero commuting time ii.
Greater ability to focus on task. iii. Flexible schedules. iv. Reduced office
desk space requirements.
Disadvantages:
i. Lack of human
contact
ii. Harmful for
self-discipline.
iii. Negative
impact on teamwork,
iv. Possible
Employee Exploitation.
Q27.What are files? What are the types
of file?
Ans: Files are
container of data to store inside hard disk. There are two types of file:
i. Program file:
program files are managed by software or program like MS office
ii. Data file:
data files are managed by OS.
Q28.What are folders?
Ans: Files are
stored on a disk in folders. Folder is the container of files.
Q29.What is drive?
Ans: Logical
pointer of different physical devices to access.
Q30.What is windows explorer?
Ans: permits to
explore all aspects of system using hierarchical view
Q31.why view icon is used in windows
explorer?
Ans: Allows to
set view to display files.
Q32.Why details menu is used in windows
explorer?
Ans: display all
files and associated file details such as name, size, type and last accessed
date in a single column.
Q33.what is the good practice when
naming files or folders?
Ans: use
meaningful names for files and folders
which should be related with the data of file
Q34.which key is used to rename folder
Ans: F2
Q35.when a folder is deleted then where
it moves?
Ans: Recycle Bin
Q36.What is Hardware?
Ans: A hardware
is a physical part of a computer which can be touched physically. The example
of a hardware is a key board, a mouse, Monitor etc.
Q37. What are the parts of a computer?
Ans: The parts
of a computer are the elements/component by which the computer made up of. The
following are the main parts of a computer.
• Central
Processing Unit (CPU)
• Types of
Memory
• The Hard Disk
• The Mother
Board
• Input Output
Devices
There are also
some invisible parts of a computer which can’t be seen but essential to run a
computer. Different types of OS and Application software are such kind of
computer part.
Q38.What do you understand by the term
computer performance?
Ans: The term
Computer performance means that how fast the computer will run. Its Totally
depends on the compatibility between different parts of a computer. In other
words when the CPU speed, RAM size, Graphics Card processor, and the Memory
have similar configuration then the user can get the best output from the
Computer. So we can say that computer performance is the condition how fast or
slow the computer works.
Q39.What is CPU speed?
Ans: CPU speed
is the measurement of the data processing capacity of the CPU. CPU speed is
measured in Megahertz of Gigahertz. The higher the value the faster the CPU will
process data.
Q40.What is Computer Memory?
Ans: Computer
Memory is a part of Computer which can permanently or temporarily store data.
For example Hard disk, RAM, ROM, ROM-BIOS etc are different types of computer
memory.
Q41.Write the Name of the Input
Devices.
Ans: They are as
follows: • Keyboard • Mouse • Scanner • Microphone • Webcam • Digital Camera •
Tracker Ball • Touch Pad • Joy sticks etc
Q42.Write the Name of the Output Devices
Ans: They are as
follows: • Traditional computer Monitor • Projection devices • Speakers and
Headphones • Printer • Speech Synthesizer
Q43.Write the name of some input output
device.
Ans: The Name of
some Input Output Devices are: 1) Modem, 2) Touch Screen Device
Q44.What are the types of Network?
Ans: The types
of Network are as follows: • LAN (Local Area Network) • WLAN (Wireless Local
Area Network) • WAN (Wide Area Network) • Client/Server Network • Internet •
Intranet • Extranet
Q45.How many options are there to
connect to internet?
Ans: There are five
options to connect to the internet. They are as follows • Phone Line • Cable •
Mobile Phone • Wireless Hot Spots • Satellite.
Q46.What are the Characteristics of the
broad band internet Connection?
Ans: There are 4
Characteristics of a Broadband internet connections. • Always On: Unlike a dial
up connection a broadband connection is always on. • Flat Fee payments: Unlike
a dial up connection where w should pay for every minute connected a broadband
connection is paid for via a
flat monthly
fee. • High Speed Access: With broadband the more we pay the higher the
connection speed.
Q47.What is e-mail
Ans: E-mail
refers to Electronic mail. Electronic mail is a program which allow us to send
text message along with attached files to the internet connected people
anywhere in the
world.
Q48.What the difference between digital
and analog technology.
Ans: The key
difference between digital and Analog technologies is Analog technologies
record wave forms as they are, while digital technologies convert analog wave
forms into sets of numbers, recording the number instead. When play back the
numbers are converted into a voltage stream that approximates the original
analog wave.
Q49.How can you save a document?
Ans: To save a
document in MS-word we do: Office button ? Save ? set file name and location ?
save
Q50.What do you mean by IT?
Ans: IT stands
for information Technology.
Q51.Write down the different type of
computer and describe shortly.
Ans: According
to the usage and working capacity computers can be divided into three different
types: Such as • Super Computer • Mini Computer or Mainframe Computer • Micro
Computer or Personal Computer Super Computer: Super computers are very powerful
and heavy duty computers which generally use in scientific, medical or
astronomical works. Mini Computer or Mainframe Computer: A mainframe or mini
computer is designed specially for used by many people usually at the same time
or large data processing system which require specialized staff to operate to
operate effectively. Micro Computer/Personal Computer : A personal computer(PC)
is any general purpose computer whose size capability and price make it useful
for individuals. The great facilities of PCs are it can be operated by any end
user who may not have specialized computing skills or knowledge. Laptop, etc
are such kind of computer.
Q52.What is a Network Computer?
Ans: Generally a
Network Computer is a diskless desktop computer designed by Oracle Corporation
which can be connected to a LAN, WAN, WLAN or any kind of Network. In that case
any general purpose computer can be called as Network Computer.
Q53.What do you understand by the system
Unit and system board/main board/mother board?
Ans: System
Unit: System Unit refers to the CPU box or Casing where all the input device,
output device, power supply box storage units and processor are embedded
together. System Board: System board/Main board/Mother board is the unit where
every parts of a computer including CPU, RAM, ROM-BIOS, Graphics Unit, Sound Card
etc. are embedded.
Q54.Define CPU, RAM, ROM, ROM-BIOS and
Flash BIOS.
Ans: CPU: CPU
stands for central processing unit. It does all kind of logical and processing
works. Intel processor, AMD processor etc are available in the market. Computer
performance mainly depends on CPU’s speed which is measured in Megahertz or
Gigahertz. RAM: RAM stands for
Random Access Memory. It is a temporary memory of computer which disappear when
computer is being shut down. Operating system and other programs are loaded into
the RAM as we switch on the computer or open them. RAM speed affects/increase
the performance of the computer which is measured in Megabytes or Gigabytes. ROM: Rom stands for Read only Memory.
ROM is a permanent type of memory which can be read but not written to and can’t be edited or deleted. ROM-BIOS: ROM-BIOS stands for Read Only
Memory Basic Input Output System. It contains the Basic instructions for the
computer to run the operating system which is constant a software.
Q55.What is information Security?
Ans: Information
security means protecting information and
Information
systems from unauthorized access, use, disclosure, disruption, modification,
perusal, inspection, recording or destruction.
Q56.What is a word processor?
Ans: Word
processor is an application software released by Microsoft which is used for
production and editing of any printable material. MS-office Word 2007 is a kind
of word processor.
Q57.What is Table?
Ans: Table is
combination of columns and rows where huge amount of data can be stored/saved
in cells in a disciplined/systematic way. In MS-word we can insert a table by
following this: Insert Tab ? Table ? drag mouse over the cells as desired rows
and columns and click.
Q58.What is Header and Footer?
Ans: Header and
Footer is the portion of a word document above and below the margin where we
can insert page number, chapter name, foot note etc. Insert Tab ? Header and
Footer?
Q59.What is Tab?
Ans: In office
2007 menu items of menu bar are called Tab. Every Tab has different Group of
tools (Which are in combination called Ribbon)
to edit a
document. For example Home Tab, Insert Tab, Page layout etc.
Q60.What is Group in MS-word ?
Ans: Group is a
collection of (related) similar tools in the Ribbon. Such as Clipboard, Font,
Paragraph editing, style etc.
Q61.What is Subscript and Superscript?
Ans: Sometimes
we need to display a character above or below the normal text line. Superscript
refers to character displayed above the normal line. For example A2
+2ab+B2=(A+B) 2 Subscript refers to text below the normal line of
text. For example CH4, H2SO4 etc.
Q62.What is template?
Ans: Templates
are pre-defined format of document, which created by the Microsoft corporation.
Which have a fixed infrastructure to reduced the dignity & save the time.
Q63.What is Bulleted list?
Ans: Bulleted
list is a type/format of list where black circle or any animated sign sits
before every list item rather than Number of Alphabet. Home ? Paragraph Group ?
bulleted list.
Q64.What is document exchange?
Ans: Document
exchange means to transfer data from one application to another application.
Q65.What is clipboard?
Ans: Clipboard
is a group of tools icon in the Ribbon under the Home tab in MS-word2007. It
contains Cut, copy paste etc tools.
Q66.How can you save a document and also
save it under another Name?
Ans: To save we
do : Office button ? save ? write file name and set location ? Save. To save
under another location we do: Office button ? save as ? change file name ? set
location as desired ? save.
Q67.How can you save document as
template , different word version formate, RTF file TXT file?
Ans: We can save
them from save as menu of office button.
Q68.How can we show all non printing
character or control which is show in display?
Ans: Under Home
tab there is an icon of tool named show/hide non printing character in
paragraph Group. Clicking on that button we can display or hide non printing
character.
Q69.How can you insert symbol within
your text?
Ans: To insert
symbols into text in MS-word we do : Insert Tab ? symbols ? select desired
symbol ? insert ? close.
Q70.How can you apply the superscript or
subscript?
Ans:
Superscript: Home Tab ? Click superscript icon in the font group? Ctrl + shift
+ write something . shortcut key : ctrl +, Subscript: Home ? click subscript
icon in the font group ? write something
Q71.How can you find a text in a
document?
Ans: Home ? find
icon in Editing Group ? write the expected word/ text ? return/find next.
Q72.What is wildcard?
Ans: A wildcard
is a symbol that takes the place of an unknown character or set of characters.
Commonly used wildcards are asterisk (*) and the question mark (?). The
asterisk represents any number of unknown characters. We use it when searching
for documents or files for which we have only partial names.
Q73.What is folders in MS windows?
Ans: A folder is
a container of files. We store files on a disk in folders.
Q74.How can you solve spelling and
grammatical mistes?
Ans: By using
spell checking program we can solve spelling and grammatical mistakes. When we
press F7 we see the spelling and grammar dialog box. We use this box to solve
the problem. It works by comparing the words within my document with a list of
words contained within a dictionary. MS Word sometimes highlights a word which
it cannot recognize but this word is necessary which as any name or trade mark.
It we add this word to the dictionary next time MS word will not highlight it.
Q75.What do you mean by text alignment?
Ans: Text
alignment means where the text will stay. It is of four types : • Left
alignment • Center alignment • Right alignment • Justify alignment
Q76.How can you print a range of
selected pages ?
Ans: We can do
this by opening print dialog box. Within the print range section of the dialog
box click on the selection button. Now only the selected portion of the
document will be printed.
Q77.Write the keyboard shortcut of open
a document close document save document print document.
Ans: The
keyboard shortcuts are given below: Open a document : ctrl + N Close a
document: ctrl + F4 Save a document : ctrl + S Print document : ctrl + P
Q78.How can you give automatically page
number in header of the MS word?
Ans: Insert Tab ? Header and Footer section ?
click page number ? top of the page ? select desired pattern.
Q79.Write the following keyboard
shortcut BOLD, ITALIC, UNDERLINE, MAKING TEXT TO THE RIGHT ALIGN, FONT
INCREASING.
Ans: The keyboard shortcut are given below :
Bold : After selecting the Text ctrl + B Italic : After selecting the text ctrl
+I Underline : After
selecting the
text ctrl + U Making text to the right aligned : Keeping the cursor on the text
ctrl + R Font increasing : After selecting the text ctrl +]
Q80.How to navigate different cells in
MS word table by shortcut keys?
Ans: Keeping the
keyboard cursor in one cell to navigate ( Means: one cell to another cell) into
another cell by keyboard key- press Tab key in the keyboard.
Q81.what is page formatting?
Ans: page
formatting relates to formatting that normally affects the whole page, such as
page orientation, page margin etc.
Q82. There are how many types of page
orientation?
Ans: There are
two types of page orientation:
1. Portrait: it
is a page orientation which is like looking at a photograph, where the long
edge is the vertical line.
2. Landscape: it
is used for certain types of documents such as notices.
Q83.what is letter size paper?
Ans: It is
normally measured in inches. It is shorter than 'A4' size paper. It is normally
used in united states
Q84.what is A4 size paper?
Ans: A4 size paper is normally measured in inches
or centimeters. A4 size paper is longer and slightly narrower than 'letter'
sized paper.
Q85.what is page margins?
Ans: This is the
space between the edge of text and the edge of page. A document has a top,
left, right and bottom margin.
Q86.which keyword is used for page
break?
Ans: Ctrl+Enter
Q87.Which keyword is used for spell
checking?
Ans: F7
Q88. How to open existing file in Excel?
Ans: Ctrl+o
Q89.which keyword is used to create new
workbook?
Ans: Ctrl+N
Q90. which keyword is used to switch
between Workbook?
Ans: Ctrl+F6
Q91.What is active cell in Excel?
Ans: Excel
identifies the active cell with a bold outline around the cell and highlighting
the column heading letter and row heading number of the cell. To enter data
into a cell, it needs to be the active cell.
Q92.why are selection techniques
important?
Ans: often when
you want to do something within excel you need to select an item first.
Q93.what is word processor?
Ans: Word processor is a software
application to type in, edit and format text documents. This software is
relapsed by Microsoft. it used for the document production, text formatting ,
official purpose and used to complete the daily tasks of the people.
Q94.what
is mail merge? why we use mail merge?
Ans: The mail merge feature is
used to insert variable data into a fixed format by combining two files into
one file. Two files needed are the data file and the main document. We use mail
merge when we need a particular document to be made, printed, or sent to many
persons at a time.
Q95.Before
printing a document what types of task we must have to be done?
Ans: Before we printout a file we
should manually check our documents which includes: checking the layout,
presentation and spelling. We should make sure that the margins, font sizes and
formats are appropriate and there are no spelling errors or repeated word.
Q96.what
is ribbon tab?
Ans: (Shaheb 2nd time Describe) Ribbon is the area of the
screen where the all tabs, Board, Groups and their related tool button and
control stay. (Correct)
(Shaheb
1st time Describe)
Ribbon (tab) is the portion of MS Office which contain the board, group and
their related tools like font, paragraph, style bottom and control etc
(SIR
Describe) Ribbon
tab is a tab which contains some icon option such as font, paragraph, style
etc.
(N.B.:
You can choose any one or you can modify as much as necessary)
Q97.What
is Tab? Write the name of four types of Tab and their uses?
Ans: Tab is a position on the
ruler by which we can define where the cursor will go if we press the Tab
button on the keyboard and in what alignment the text will be.
There are four types of Tab:
1. Left Tab: inserts a left
aligned tab stop
2. Center Tab: inserts a Center
aligned tab stop.
3. Right Tab: inserts a Right
aligned tab stop.
4. Decimal Tab: inserts a Decimal
tab stop.
Q98.What
are bulleted lists? How can you remove bullet formatting from a list?
Ans: Bulleted lists are lists in
which bullets are used to set-off and paragraph sections of text. Bullets are
symbols such as dots or diamonds. To remove the bullet formatting from a list
we have to select the bulleted list and click on the bullets icon or none on
the formatting toolbar.
Exactly
Q98.What
are header and footer?
Ans : Header and Footer are the
sections within the top and bottom margins of every page which allow us to
insert information like chapter headings, date and time with page numbers etc.
Q99.What
is hyphenation? How can we set hypernation?
Ans: Hyphenation is putting
hyphens at the end of every line if words are broken into the next line. To put
hyphenation: 1. Click Tools -> language -> hyphenation (97/2003)
2. In the hyphenation dialog box
check 'automatically hyphenate document'
and click ok.
or
Click Page Layout->go to page
setup->click on Hyphenation ->click on -> Automatically Hyphenate
document”
3. To set
hyphenation in a specific position, click on the manual button.
Q100.which keyword is used to display
the Find and replace dialog box, with the replace tab already selected
Ans: Ctrl+H
Q102.Formulas within Excel start with
which symbol?
Ans: =(equal to)
Q103.What are the commonly used
operators in Excel?
Ans: +(plus), -(minus), *(multiplication),
/(divide)
Q104.What are the error messages in
Excel?
Ans: ######: The contents of the cell cannot be
displayed correctly as the column is too narrow.
#REF!: indicates
that a cell reference is invalid.
#NAME? : Excel
does not recognise text contained within a formula.
#DIV/01: This
indicates that you have tried to divide a number by zero
Q105.There are how many types of cell
references in Excel? What are they?
Ans:
There are two
types of cell references in Excel. They are:
1. Relative
2. Absolute
Q106.What is the difference between
relative and absolute cell reference?
Ans: Relative Cell References
This is the most
widely used type of cell reference in formulas.
Relative cell references are basic cell references that adjust and change
when copied or when using AutoFill.
Absolute Cell References
Situations arise
in which the cell reference must remain the same when copied or when using
AutoFill. Dollar signs are used to hold
a column and/or row reference constant.
Q107.What is function in excel?
Ans: A function
allows you to calculate a result such as adding numbers, or finding the average
of a range of numbers.
Q108.What are the common functions used
in Excel?
Ans: AVERAGE: Returns the average of its
arguments
COUNT: Counts how many numbers are in the
list of arguments
COUNTA: Counts how many values are in the list
of arguments
COUNTBLANK: Counts the number of blank cells
within a range
MAX: Returns the maximum value in a list of
arguments
MIN: Returns the minimum value in a list of
arguments
ROUND: Rounds a number to a specified number
of digits
SUM: Adds its arguments
COLUMNS: Returns the number of columns in a
reference
Q109.Which symbol is used in absolute
cell referencing?
Ans: $
Q110.What are IF functions?
Ans: Returns one
value if a condition you specify evaluates to TRUE and another value if it
evaluates to FALSE.
Use IF to
conduct conditional tests on values and formulas.
Q111.Which keyword shortcut is used for
searching in Excel?
Ans: Ctrl+F
Q112.What is Auto Fill in Excel
Ans: A very
handy feature in Excel is Auto Fill, which allows you to automatically fill
cells with preset data.
Q113.What is Freeze Panes in Excel?
Ans: When
working with very large spreadsheets headings located at the top and down the
left side of the worksheet often disappear if you scroll too far to the right
or down. Without the headings, it's hard to keep track of which column or row
of data you are looking at. To avoid this problem use Excel's freeze panes
feature. It "freezes" or locks specific columns or rows of the
spreadsheet so that they remain visible at all times.
Q114.what is html formatted file?
Ans: html
formatted file means it will be visible as web page either in world wide web or
on LAN/Intranet.
Q115.Difference between RTF file and TXT
file?
Ans: RTF stands
for rich text format. This is generic word processing file format. This format
is used to share word-processing between different word processors. RTF files
can be much larger than a word file if a lot of complex formatting is used.
TXT is used for
storing plain text.TXT can hold only text in it, it cannot hold image or other
formatting.
Q116.why file extension is important?
Ans: File
extension is important for windows operating system to determine which
application is needed to open a particular file and which icon to show.
Q117.What type of file we cannot rename?
Ans: Some types
of files are used by computer to run. If we rename them the system can crash or
be damaged. These files are: .exe, .com, .bat, .dll, ini, .sys etc.
Q118. What is temporary file?
Ans: 1) windows
or other applications create temporary files while working with them. 2) if the
system crashes or stops working or the power supply gets interrupted these
temporary files are not automatically deleted as normal. 3) some common
extensions of temporary files are tmp,temp,chk,old, etc.
Q119.How can we write protect a file?
Ans: To protect
a file: 1) right click on the file then select properties or select the file
and press Alt+Enter to view the properties dialog box. 2) in the Attributes
section tick the Read-only check box then click apply and OK; the file is now
write protected i.e. we can only read it but cannot write on it or change it.
Q120.Why do you use (various)
screensaver?
Ans: 1. To
change and blank the screen after certain period of activity. 2. when we use
our computer for long time we sometime keep the computer running idly
Q121.What is word Pad? what is the
benefits of using word Pad?
Ans: wordpad is
a small word processing application provided along with windows operating
system. It has the following advantages:
1. free to use
2. can change or
modify font and paragraph style.
3. it can be
used by other various applications
Q122.what is recycle bin?
Ans: it contains
files which have recently been deleted. we can restore file from recycle bin.
Q123.What is windows explorer?
Ans: It is a
window of windows operating system. It explores all aspects of computer system
using a hierarchical view.
Q124. What is Operator?
Ans : Operator
are those symbol which perform operation
on data.
Q125.what is drag and drop?
Ans: The term drag and drop basically means
picking up an item with mouse and dragging it to a new location.
Q126.What is the difference between
count and counta function?
Ans: The count function will count up the number
of cells which contain numbers.
counta function
is used to count the number of cells within a range that are not empty.
Q127.What is the syntax of If functions?
Ans: if(logical_test,
action_if_true, action_if_false)
Q128.In if function what operators are
used?
Ans: =(equal to)
, >(greater than , <(less
than) , >=(greater than equal to) , <=(less than equal to)
Q129.Why are selection techniques
important?
Ans: often when you want to do something within
excel you need to select an item first. this could involve selecting a cell or
multiple cells. it many need you to select a row, a column or even the entire
table.
Q130.what is virus disinfecting?
Ans: using a virus checker to detect and eliminate
viruses from a computer is called virus disinfecting.
Q131.What are Title Bar, Menu
Bar, Toolbar,
Status Bar and Scroll Bar?
Ans: 1) Title
Bar: the bar which is displayed on top of almost all programs is called Title
Bar.Title Bar may display the name/path of the file opened or the name of the
application.
2) Menu bar:
menu bar is normally displayed just under the title bar which contain a series
of drop down menus.
3) Tool Bar: It
contains a series of icons. THESE ICONS ARE like short cuts to certain menu
commands in the menu bar drop down list. It makes work fast and easy.
4) Status bar:
the bar which is displayed along the bottom of almost every program is called
status bar. It displayed information about the file or files opened or
selected.
5) Scroll bar:
when a document window is bigger than the physical screen size of the computer.
Bars may appear on the right and the bottom of the window to make the users see
all the information easily.
Q132.What is PCMCIA?
Ans: PCMCIA
stands for Personal Computer Memory Card International Association.
Q133.What is modem?
Ans: 1) Modem is
a device which is used to attach the computer to the telephone system through
which one can connect to the internet. 2) Modem converts data into sound which
sent over the telephone line. 3) The receiving modem turns the sound back into
data and the communication is established. 4) Modem comes from MODulate and
DEMODulate.
Q134.Why do we need to format a
disk?
Ans: 1) Formatting
a disk is like putting lines on a blank sheet of paper so that we can write on
that paper. 2) Formatting allows the operating system to read information
stored on the disk and also stored information on the disk. 3) We need to
format the disk before we can install OS into the hard disk. 4) We need to
format the disk after we have re-partitioned it 5) We need to format the disk
if we want to change the file system e.g. FAT to NTFS. 6) We need to format the
disk to get rid of viruses and malicious files.
Q135.What is GUI?
Ans: 1) GUI
stands for Graphical User Interface. 2) It is simply an additional part of the
operating system which displays windows and drop down menus and also enables us
to drive our computer using a mouse. 3) Windows and IBM’s OS/2 are examples of
OS which use GUI.
Q136.What are the advantages of GUI?
Ans: 1) All
programs look similar and they are easy to use even switched from one to
another. 2) Applications programs are similar to the operating system as a
result they are easier to use. 3) GUI allows programmers to easily write
consistent looking programs.
Q137. What is system development?
Ans: The way new
software is specified, written by programmers, tested and then delivered to the
user is referred to as system development.
Q138.What is system development cycle?
Ans: System
development cycle is defined in the following way: 1) Analysis : System Analysts ask the users exactly what they need and
then draw up plants to implement those on a computer based system. 2) Design : A possible design or outline
is drafted to make it real. 3) Programming
: Programmers convert the whole thing into actual computer codes. 4) Testing : Users are introduced to
the new system and asked whether any modification is needed.
Q139.What does client / server mean
?
Ans: 1) This
term relates to the type of network where resources are kept centrally on the
server and used locally by the client. 2) The server is usually a very powerful
PC or a group of PC’s while each workstation which the users have is less
powerful.
Q140.What is workgroup computing?
Ans: 1) The idea
of workgroup is that groups of people working together can share their
resources with each other. 2) People within the workgroup can share information
on their hard disks. 3) They also can share printers, modems and scanners. 4)
The workgroup in connected via a computer network. 5) The network may be a few
computers at a single location or of many computers connected globally. 6) The
networked nature of computers means that the physical distance between
workgroup members is fast becoming irrelevant.
Q141.What are the advantages of
workgroup computer?
Ans: 1) No reliance on central computer : As
there is no reliance on a central computer, there in less change of major
disruption if one computer goes down for a while. 2) Network administrator is not needed : Provided members of the
workgroup have the authoring and access rights. They can share data on a
temporary basis with colleagues. They don’t need help of a network
administrator. 3) Can be cost-saving :
If a dedicated network administrator is not needed in a small office it can
save a considerable cost.
Q143. What does FTP mean?
Ans: FTP means
File Transfer Protocol.
Q144.What is PSTN?
Ans: 1) PSTN
stands for Public Switched Telephone Network. 2) It is the technical name for
the public telephone system. 3) It is based on traditional ‘copper wire’
technology. 4) It transmits analogue voice data.
Q145.What is PSDN?
Ans: 1) PSDN
stands for Public Switched Data Network. 2) It is the technical name for the
telephone system in use today.
Q146.What is ISDN?
Ans: 1) ISDN
stands for Integrated Services Digital Network. 2) ISDN allows much faster
transfer rates than-when using modems. 3) It can transfer 64 or 128 Kb data per
second.
Q147.What is ADSL?
Ans: 1) ADSL
stands for Asymmetric Digital Subscriber Line. 2) It is a more recent
technology. 3) It allows more data to be sent over existing telephone lines. 4)
But it requires a special ADSL modem. 5) It can download data at a rate of 0.5
to 8 Mbps and upload at a rate of 16 to 640 Kbps.
Q148.What is DSL?
Ans:1) DSL
refers collectively to all types of Digital Subscriber Lines. 2) Its two main
categories are ADSL and SDSL. 3) DSL technology allows faster data transfer. 4)
It uses ‘copper wire’ not optic ‘fiber cables’.
Q149. What are the difference between
digital and analog?
Ans:
1) A digital
system uses 1 or 0 to transmit data or represent data.
2) An analog
does not use multiples of 1 or 0 rather uses full range of
Numbers, including fractions.
3) Analog clock
can display fractions of a second.
Q150.
What is baud rate?
Ans:1) The
sending and receiving speed of a modem is called baud rate.
2) Most modern modems have a maximum
baud rate of 56 Kb/s.
Q151.Identify where computer might be
more appropriate than people.
Ans: 1)
Repetitive tasks 2) Easily automated tasks. 3) Mathematical calculations. 4)
Dangerous Situations.
Q152.Identify where people might be more
appropriate than computer.
Ans: 1)
Imagination. 2) Emotions, feelings, love, real person talking. 3) Decision
making. 4) Nursing. 5) Planning. 6) Creativity. 7) Pattern recognition.
Q153.Name some of the uses of
large-scale computer applications.
Ans: 1) Business
administration system (ERP – Enterprise Resource Planning). 2) Airline booking
systems. 3) Insurance claims processing. 4) Online banking.
Q154.Name some of the uses of
large-scale computer applications in government.
Ans: 1) Census.
2) Vehicle registration. 3) Revenue collection. 4) Electronic voting.
Q155.Name some of the uses of
large-scale computer applications in healthcare.
Ans: 1) Patient
record system. 2) Ambulance control system. 3) Diagnostic tools and specialist
surgical equipment.
Q156.Name some of the uses of
large-scale computer applications in education.
Ans: 1) Student
registration and timetabling. 2) Computer Based Training (CBT). 3) Using the
internet as a homework resource. 4) Distance learning systems.
Q157.What are the advantages of distance
learning?
Ans: 1) One
trainer can train many people at many different locations. 2) The students can
have some flexibility regarding time and location as they can learn 24 hours a
day and 7 days in a week.
Q158.What is UPS?
Ans: 1) UPS
stands for Uninterruptible Power Supply. 2) It is a device which will guard
against power cuts. 3) It contains batters which will keep the computer alive
enough to use the shut down command.
Q159.Why do we need to backup our
computer?
Ans: The most
important thing we store on our computer is information. The information on a
hard disk can be of year’s age and high importance. If the hard disk stops or
the system fails it will cause loss of information. So to ensure the safely of
the information we need to backup our computer in a regular basis.
Q160.What are complete and incremental
backups?
Ans: 1) A
complete backup means which can backup all the data on the computer. Sometimes
complete backup is time consuming. 2) Incremental backup is an automatic
process to backup the data on the computer after a certain span of time e.g.
every night after the office hour. It can save time.
Q161.What is off-site storage?
Ans: The storage
which not directly attached the computer system rather is safe and secure
enough even from fire or any kind of external damage or loss is called off-site
storage.
Q162.How can we copy or move a file
using ‘drag and drop’?
Ans: 1) If we
simply drag a file using left mouse button and drop it to another location, the
file will be moved to the new location. 2) On the other hand, if we drag the
file while Control (Ctrl) key is depressed and drop it to another location, a
copy of the file will be created in the new location.
Q163. What are Start button and Start
menu?
Ans: 1) Start
button is located at the button-left corner on the taskbar. It allows the user
to access their works or applications with the least amount of difficulties. 2)
Start menu contains various categories of links to where applications and works
are stored in the computer. It also has sub-categories under each category to
make things easy.
Q164.How can we select multiple files?
Ans: 1) To
select multiple files randomly we select a file using left mouse button and
while keeping the Control (Ctrl) key depressed select other files
simultaneously. This will keep all the files selected. 2) To select multiple
files in a row we select the first file using left mouse button and while
keeping Shift key depressed select the last file in the row. All the files
between the two clicks will be selected. 3) We can also use Control key, Shift
key and Arrow keys in combination to select a range of files or folders.
Q165.What is the procedure to turn off
the computer?
Ans: 1) We have
to save all the files that wee were working on. 2) We have to close all open
applications. 3) While on desktop we can press Alt+F4 or click on ‘Turn Off
Computer’ of the Start Menu to open Turn Off Computer dialogue box. 4) Then
click Turn Off or press U on the keyboard to completely shutdown the computer.
Q166.How do we restart our computer?
Ans: 1) Click on
‘Turn Off Computer’ on the Start Menu to open Off Computer dialogue box. 2)
Then click Restart or press R on the keyboard; the computer will restart.
Q167.How can we shut down a
non-responding application?
Ans: 1) If an
application stops responding press Ctrl+Alt+del to open Task Manager. 2)Under
the applications tab select the not-responding application. 3) Click on End
Task or press Alt+E. Click End now if asked.
Q167.How do we see basic information
about our computer?
Ans: 1) Click
Start button Control Panel (Classic View) System. 2) On Start button
Control Panel (Category View) Performance and Maintenance See basic
information about your computer. 3) Under the General tab we can see Windows
version. CPU and RAM speed.
Q168.What is POST? Which component is
responsible for doing this?
Ans: 1) POST
stands for Power On System Test or Power On Self Test. 2) When we switch on our
computer some information regarding video memory, RAM and CPU are displayed on
a black screen on the monitor showing whether all the components of the PC are
loaded correctly or not. 3) A special chip called ROM-BIOS performs this test
namely POST.
Q169.How can change the Date and Time?
Ans: To change
the Date and Time: 1) Double click on the clock displayed on the rightmost side
of the taskbar to active the ‘Date and Time properties’. 2) Under ‘Date and
Time’ tab we can change time and date. 3) We can also change the Time Zone on
the next tab.
Q170.How can we set screen resolution
and color quality setting ?
Ans: To set
screen resolution and color settings : 1) Right click on the windows desktop
and select properties or go to Start Menu Control Panel Display. 2) On the
‘Display Properties’ dialog box select the ‘Setting’ tab. 3) In the ‘Screen
Resolution’ section, use the slider to increase or decrease screen resolution.
The more the resolution the more dots are on the screen and the more the
display is sharp. 4) In the ‘Color quality’ section, click on the drop down
list to select 16 bit or 32 bit. 32 bit will provide better display quality.
Q171.What the steps to format a flash
drive?
Ans: 1) Insert
the flash drive into the PC’s diskette drive. Make sure that the data n the
drive is backed up or not important; because formatting will erase all the data
permanently. 2) Press Windows+E to open Windows Windows Explorer. 3) On the
left portion of the window right click on the flash drive. 4) On the popup menu
click format. 5) On the next dialog box click start. 6) On the next
confirmation dialog box click OK; formatting will start. 7) On the ‘Format
Complete’ dialogbox click OK.
Q172.How can uninstall software?
Ans: 1) Most of
the application software put an uninstall shortcut in ‘All Programs’ group of
the ‘Start Menu’ along with executable shortcut. 2) We can use this link or we
can go to the Control Panel ‘Add Remove Programs’ to uninstall the software.
Q173.: What is computer virus? What are
computer virus infection issue? How to protect your computer from virus
infection?
Ans :Viruses are
small programs which hide themselves on disk. Computer virus infection issues
are as follows : 1. When computer start it will infect the system. 2. It can
spread from one computer to another via infected disk or computer network.
Protecting against computer infection issues are follows : 1. Not connect to
local area network. 2. Without using anti-virus software should not use
internet.
Q174. What is a firewall?
Ans : Firewall
is a system that secures network from access by unauthorized users its
implemented by software.
Q175. What are steps to take to prevent
data theft?
Ans : a) Use
user name and password always. b) Keep computer in physically secure place. c)
Do not let anybody use portable disk and memory sticks.
Q176. What is Ergonomics?
Ans : Ergonomics
covers the physical environment and designed of equipment to maximize the
quality of an employee’s well being.
Q177. What is freeware?
Ans : Freeware
means which can be copied or downloaded free and no need to by licence.
Q178. What is Shareware?
Ans: Shareware
means software for a trial period .After trial period it will either display
annoying message, asking to register software or stop working.
Q179. What is open source software
means?
Ans : Open
source software programming code of software is available to anyone who wishes
to enhance or develop code. For example : PHP.
Q180. What is data protection
legislation?
Ans : Data
protection legislation means data protection law. It can differ substantially
between countries. For example : 1)personal data shall be obtained fairly and
lawfully 2) personal data shall be processed fairly and law-fully. 3) personal
data should be accurate and if necessary kept up to date.
Q181. What is spyware?
Ans : Spyware is
software that installs itself on computer and then spies on computer activity.
It is used to collect marketing information. It can be uses as a criminal way
also.
Q182. What is cookies?
Ans : Cookies
are common used to allow visitors to a website to personalize their
relationship with the website cookies are text files stored in users machine.
This are often downloaded from a website when user visits the website.
Q183.What is database ?
Ans: A database
is a collection of information that is organized so that it can easily be
accessed, managed, and updated.
Q184.What is relational database?
Ans: A
relational database is a collection of data items organized as a set of
formally-described tables from which data can be accessed or reassembled in
many different ways without having to reorganize the database tables.
Q185. Differences between data and
information
Ans: Data:
Facts,
statistics used for reference or analysis.
Numbers,
characters, symbols, images etc., which can be processed by a computer.
Data must be
interpreted, by a human or machine, to derive meaning "Data is a
representation of information" *
Information:
Knowledge
derived from study, experience (by the senses), or instruction.
Communication of
intelligence.
"Information
is any kind of knowledge that is exchangeable amongst people, about things,
facts, concepts, etc., in some context." *
"Information
is interpreted data" *
Q186.what is field
Ans: A space allocated for a particular item of
information. A tax form, for example, contains a number of fields: one for your
name, one for your Social Security number, one for your income, and so on. In
database systems, fields are the smallest units of information you can
access.
Q187. At is record
Ans: A collection of fields is called a
record.
Q188. We can we use Print Screen
facility?
Ans:
1) If we want to
take a snapshot of our monitor’s current display we have to press the ‘Print
Screen’ key located just right to Allthe Backspace key. 2) To save the image
we can open Print from Start
Accessories and click Paste under Edit Menu or press Ctrl+V. 3) Click
Program Save under File Menu or Press Ctrl+S. 4) In the dialog box give a name
and at the ‘Save as type’ dropdown list, select a file format e.g. bmp or jpeg
then click Save or Press Enter on the keyboard. The file is saved. 5) To take a
snapshot only of the active window we just have to press All+Print Screen then
follow the procedure.
Q189.What
is drives?
Ans:
1) Drives are
partitioned space on the4 hard disk. 2) Drives are like separate rooms in a
flat. 3) If all the information is put into one single hard then it is likely
to be lost very easily if the OS stops working or crashes. 4) To make our
information safe and use them in an organized way we need several drives on the
hard disk.
Q190.How
can we create a new folder?
Ans:
To create a new
folder : 1) Right click on the blank space of the window where the folder is to
be created. 2) On the popup menu pause on new. 3) On the submenu click Folder.
4) Name the folder and press Enter or click outside; the folder is created.
Q191.What is file extension? Write ten
different extensions and their use.
Ans:
File extension
is something which windows use to determine the file type and to decide which
application is needed to open the file. For Example .doc is the extension for a
document file. file extension is placed at the end after each file name
separated by a dot called period. Ten different file extensions and their use:
.txt- Text files .rtf- Rich text format (WordPad) .doc-Document files (MS Word)
.xls- Spreadsheet files .ppt- Power Point Presentations .mbd- Database files
.exe- Executable files .jpeg- Image files .html- Webpage files .wav- Audio
files
Q192.Why is file extension
important?
Ans:
File extension
is important for Windows Operating System to determine which application is
needed to open a particular file and which icon to show. If we somehow change
file extension, windows will be confused as to what the file format is.
Q193.What is compressed file? why do we
compress a file or folder?
Ans:
1) Compressed
files are files which have been compress using a third party utility software
like WINZIP, WINRAR, AllZip, 7Zip etc. 2) In general compress files have a file
extension of .zip. 3) Windows has a built in zip utility namely iexpress. 4)
Files are compress to make them smaller to save disk space or to make the
transfer faster over a network or the internet.
Q194.How can we write protect a
file?
Ans: To write protect a file : 1) Right click on
the then select Properties or select the file and press Alt+Enter to view the
Properties dialog box. 2) In the Attribute section tick the Read-only checkbox
then click Apply and OK; the file is now write protected i.e. we can only read
it but cannot write on it or change it.
Q195.What is wildcard? Give four
examples of using wildcards?
Ans: When we
want to search a file or files and do not know the exact name, we use some
tricks to find them out. These are called wildcards. For example : 1) To search
for all files whose names start with a, we would search for a*. 2) To search
for all files whose names start with ma, we would search for ma*. 3) To search
for all files whose names start with ma and contains 5 characters, we would
search for ma???. 4) To search all document files whose names start with be and
contains 3 characters, we would search for be? .doc.
Q196.How can we
change the default printer?
Ans: To make a
printer default : 1) Go to Start menu Control Panel Printers and Faxes. 2)
Right click on the printer icon which we want to make default. 3) On the popup
menu click on ‘Set as Default Printer’.
Q197.What is Printer Manage?
Ans:
1) Printer
Manager is the window which is open when we double click on the printer icon.
2) Printer Manager enables us to pause, restart, cancel or delete any print
command which has been given already.
Q198.How much data can a CD- ROM
store?
Ans:
A CD - ROM can
store 650 MB data.
Q199.Give examples of uses of large
scale computer applications in business.
Ans:
i. Business
administration. ii. Airline booking systems. iii. Insurance claim processing.
iv. Online banking.
Q200.Write
down the types of storage media.
Ans:
Internal hard
disks, External hard disk, CDs, DVDs, Recordable CD and DVD drives, USB flash
drives, Memory cards.
Q201.What
are the types of communication methods?
Ans:
Electronic
mail(E-mail), Instant messaging (IM), Voice Over Internet Protocol (VOIP),
Really Simple Syndication (RSS) feeds, Blogging, Podscasts.
Q202.What is a Podscasts?
Ans:
The Term
“Podcasts” is combination of the words ‘’iPod” and “ broadcast”. A broadcast is
a way of providing contents such as radio programs in a form which can be
easily downloaded and listened to later on a PC or mobile device such as an
Apple iPod.
Q203.Write down different types of printer
name?
Ans:
Laser Printer,
Colour Laser Printer, Inkjet Printer, Dot Matrix Printer.
Q204.Write down list of electronics
world.
Ans:
E- commerce, E-
banking, E- government, E-learning, Tele-working.
Q205.What is the ICT? What are the terms
cover the ICT Field?
Ans:
ICT stands for
Information and Communications Technology. These terms cover the ICT field: i.
Installing and maintaining systems and applications. ii. Data management. iii.
Computer hardware maintenance. iv. Database and software design.
Q70.What is a site license?
Ans:
A site license
means that the companies purchasing the license can make a fixed numbers of
copies available to their staff via computer network.
.
Q71.What is a user license?
Ans:
A User license
allows to make copies and install software on each computer.
Q72.Write
the limitations of Anti-virus program.
Ans:
To detect only
known virus. · Unable to check new viruses. · Always to kept update via
Internet. · To use complex.
Q73.Write the Anti-virus precautions.
Ans:
· To install
authorized anti-virus. · It should be update on regular basis. · Make sure that
virus checker is well configured.
Q74.Why
do you need to back up?
Ans:
May be need data
for future. · If important data is corrupted. · Break down computer any time. ·
Storage device may be damage. · If break down the network system
Q75.6. Write Briefly – Firewall,
Internet Browser ?
Ans : Firewall
is a system combining hardware and software to protect computer from internet
fraudulence. Windows OS has a built in Firewall bundled with it. Internet
Browser is a software to browse or surf websites or web pages in internet
Explorer, Opera, Netscape Navigator, Safari(MAC) are examples of internet
browser
Q76.What does virus do?
Ans: It can
cause disruption or damage to the computer system. · Damage or destroy
important data, file, email etc. · To interrupt simultaneous work.
Q77.
7. Say some thing about absolute referencing and relative referencing .?
Ans:
Ans :Absolute
reference is used to make the reference fixed. The reference cell will not
change with the change of the cells in which we put the formula. F4 is used to
wake a cell reference absolute. A $ sign appears before both the column and row
number .e.g. $ A $1 relative reference is the reference which will change it we
copy the formula or reference to anther cell.
Q78.How
do you protect computer from attack?
Ans:
· Don’t connect
LAN or Internet. · To use User ID and strong Password. · Don’t use floppy disk
which is affected virus. · To install updated Anti-virus.
Q79.What
are the uses of computer applications within hospitals and the health care
system?
Ans:
· Patient record
systems · Ambulance control systems · Diagnostics tools and specialist surgical
equipment.
Q80.Where
computer might be more appropriate than people?
Ans:
Repetitive
tasks, Easily automated tasks, Mathematical calculations, dangerous
situations.
Q81.What
is the difference between WWW vs Internet?
Ans:
The world wide
web is a small part of the Internet. The Internet relates to all the hardware
and software involved as well as the WWW. It also includes FTP, email and
newsgroups. The WWW is basically the text and pictures which we can view using
web browser.
Q82.List some application software and system
software.
Ans:
· Application
software: Ms Word, Ms office 2007, Ms office XP, Ms Excel, Media player. ·
System software: DOS, MS Windows 95, Windows XP, Linux, Unix, IBM OS/2.
Q83.What
is formula?
Ans:
The formula
which will produce the result and can consists of operands, values, variables
any symbols which represent mathematical procedures.
Q84.Briefly discus about the terms primary key and foreign key ?
Ans:
Primary key is
used to index a table data within MS Access Database. we can easily find out
records by using primary key record data if we create relationship between two
tables in Access. the field in the second table other then primary key is
called a foreign key.
Q85. Briefly discus about the terms –master
slide ?
Ans : Master
Slide is a kind of template which we can use to change out apply formatting to
all the slides within the Power point presentation by changing the format only
of the Master slide there are three layouts within view master : master layout,
Handouts layout, notes layout.
Q86. Write two Mail Server and two
Internet browser name.?
Ans : Mail
Server : POP3, HTTP, SMTP. Internet Browser : Internet Explorer, Safari
(MAC)
Q87.Write Keyboard Shortcut
Ans:
Format Cell =
ctrl+1. Receiving all e-mail = F9. Run Slide Show = F5. High light Current
record = F5 , Spell Cheek = F7 , Save as = F12 , Open Dialog box = ctrl+o, Cut
= ctrl+x , Undo = ctrl+z, Hyperlink = ctrl+k, Paste = ctrl+v , Absolute
reference = F4, (Alt+Backspace ), New Slide = ctrl+m, Task manager = ctrl+alt+delete
Q88.Write
Briefly = CBT, RAM ?
Ans : CBT stands
for Computer Based Training. Computer Based Training is useful in remote
education where human contact is not possible sometimes CBT is expensive. RAM
stands for Random Access Memory. it is a primary memory. operating system and
other Application are Primary loaded into RAM – the more the RAM size the more
the Computer is Fast.
Q89.Write
Abbreviation of –CBT, DOS, UPS, USB, PSTN, FTP, ISDN, RSI,
Ans :CBT=
Computer Based Training. DOS= Disk Operating System. UPS = Un-interruptible
Power Supply. PSTN = Public Switched Telephone Network. FTP = File Transfer
Protocol. ISDN = Integrated Services Digital Network. RSI = Repetitive Strain
Injury.
Q90.Why
do we save a .doc file as different Word Version format?
Ans:
1) There are
several versions of Microsoft Word. So the use of the versions can very from
person to person. 2) To make the .doc file available and accessible to all we
need to save the document as different Word Version format. 3) For example if
we Microsoft Word 2007, we should save a document file as Word 97-2003
compatible to make accessible to older versions like XP or 2003.
Q91.What is HTML formatted file?
Ans:
1) HTML Stands
for Hyper Text Mark-up Language. 2) HTML is the file extension for web-page
files. 3) If we save or convert a Word Document file to HTML format, it will be
visible as web-page either in World Wide Web or on local LAN/Internet.
Q92.Discuss different Layout Views in
Word.
Ans:
Layout Views are
how see an opened MS Word document on the screen. Under View Menu there are
several layout views like Normal, Web, Print, Reading, Full screen etc. 1)
Normal View does not show additional information like headers and footers. 2)
Web Layout displays how the file will appear on the web. 3) Print Layout
displays multiple columns, headers, footers etc. It is close to the actual view
if the document is printed. 4) Reading Layout displays how the document will
appear as a book. 5) Fill screen does not display the bars and allows us to
type, edit or format the document.
Q93.Write the name of the (™, ®, ©)
three symbols.
Ans:
Copyright ©
Registered ® Trademark ™
Q94.Write
the procedure for adding Widows Extra Component(IIS) of your system.?
Ans:
Widows Extra
Component (IIS) which is open the computer click the start menu – click the
control panel –click the Add/ remove windows select the IIS program
Q95.What
is input and output device? Write the name of five input and output
devices?
Ans:
Ans: Input
Devices allow you to input information to the computer and include things such
as the keyboard, and Mouse, Output Devices allow you to output information from
the computer and include printer and the Monitor. The name of Input Device is
Mouse, Keyboard, Trackball, scanner, Touch pan, Digital Camera, Microphone, The
name of Output Devices are Monitor, Printer, Screen size, Computer presentation
projection Devices, Flat screen monitor,
Q96.How
can we change the User information and Default File Location of MS Word?
Ans:
To change User
information and Default File Location: 1) Click Options under the Tools Menu.
‘Options’ dialog box will appear. 2) Under ‘User Information’ tab we can change
Name, Initials and Mailing Address. 3) Under the ‘File Locations’ tab select
‘Documents’ in the ‘File Types’ section click on modify navigate to the
desired folder click OK.
Q97.Which
Factors affecting computer performance? Describe briefly.
Ans:
:Factors
affecting computer performance such as : # CPU Clock speed : The computer clock
speed governs how fast CPU will run. # RAM size : As a rule the more memory you
have the faster the pc will appear to operate. # Hard disk speed and storage :
Hard disks are also measured by their speed , # Free Hard disk space: To get
the most out of your Windows based PC, you not only need a fast hard disk but
also large hard disk with plenty of “spare space” # De-fragmenting Files : If
you are running Widows you may find that if you click on the start menu, select
the programs. # Multitasking considerations: Windows is a multitasking system,
which means that if can run more than one program at a time.
Q98.What
is Overtype text mode? How to insert overtype text in word document? How do we
know that we are in overtype mode?
Ans:
Overtype text
mode overwrites exiting text with any new text which is typed in. To type in
Overtype text mode, we have to change the default Insert mode by pressing
insert key once or by double clicking on the OVR indicator at the Status bar on
the bottom of the screen. We are using Overtype mode if OVR indicator at the
Status bar is highlighted.
Q99.How
can we insert a special symbol in a word document?
Ans:
To insert a
special symbol: 1) Position the cursor where to insert the symbol. 2) Under the
insert menu click Symbol. 3) Double click on the symbol in the Symbols, special
Characters or Recently used symbols; or select the symbol and click insert and
click Close.
Q100.How
can we change the AutoCorrect option?
Ans:
To change
AutoCorrect options we have to undo the auto changing by pressing Ctrl+Z.
AutoCorrect options are located under the Tools menu.
Q101.What is Net working? Describe briefly about LAN
, WAN, Client/Sever.
Ans:
Net working is
the individual PCs are connected together and information, Data transfer or
communication for company or organization. LAN : LAN (local area network) is a
system whereby individual PCs are connected together within a company or
organization . for instance if ten people are working together within an office
it makes sense for them all to be connected. WAN : (Wide Area Network) as the
name implies allows you to other computers over a wider area (i,e the whole
world). Client /server : This term relates to the type of network where
resources are Kent central on the server to connected
Q102.What is Format Painter? When do we
use Format Painter?
Ans:
Format Painter
is a tool to copy and apply format from a previously formatted block of text.
We use Format Painter when we want a particular block of text formatted like a
previously formatted block of text.
Q103.From where can we use magnifier to
document?
Ans:
Magnifier tool
is located in the Print Preview toolbar. We can use it from there to change the
view within the Print Preview.
Q104. What are Laptop and Palmtop
computer?
Ans:
Ans: Laptop is
the name impalas are small portable computers which can run on batteries as
well as main power they use special screens. Palmtops are even smaller
computers which can literally fit into the plan of your hand .
Q105.How can we set Indent and line
space in a paragraph?
Ans:
To set Indent
and Line space in a paragraph: 1) Put the cursor anywhere in the paragraph. 2)
Click Format Paragraph. 3) In the ‘Indentation’ section, set Left, Right or
Special indent. 4)In the ‘Spacing’ section, select line spacing from the
dropdown list of ‘Line spacing’.
Q106.How can we set border and shading to
paragraph?
Ans:
To set border
and shading to paragraph 1) Put the cursor anywhere in the paragraph. 2) Click
Format Border and Shading; the Border and Shading dialog box appears. 3)
Under the ‘Borders’ tab there are options like Style, Color, Width. 4) Under
the ‘Shading’ tabs there are options like Fill, Style and Color. 5)We can use
combination of them to apply border and shading to the paragraph.
Q107.Write
the name of all Header and Footer tools?
Ans:
There are
several tools on the Header and Footer toolbar like: Insert AutoText, Insert
Page Numbers, Insert Number of pages, Format Page Number, insert Date, Insert
Time, Page Setup, Show/Hide Document Text, Link to Previous, Switch Between
Header and Footer, Show Previous, Show Next and a Close button.
Q108.What
is PCMCIA? P.21
Ans:
Ans: Portables
by their very compact and require smaller then standard parts such as hard
disks and CD-ROM drives. Many portables are supplied with special adaptor
sockets which enable what are called PCMCIA compatible hardware to be connected
to them. PCMCIA components tend to be more expensive than standard computer
parts which are designed for more bulky desktop computers.
Q109.How
can we insert a picture /image / chart in a Word Document?
Ans:
To insert
picture / image or chart : 1) Put the cursor where we want to insert an image
or a chart. 2) Click Insert Picture. 3) Click ‘From File’ to select the image
file we want to insert and click insert button. 4) Click Chart to insert a
chart.
Q110.Write
the Keyboard Shortcut; Paste, Undo, Centre Alignment, Spell Check, Save as,
File Open, Close
File, Print, Select All, Find, Replace, Go To, Redo,
Cut, Copy, Task Pane, Hyper Link.
Ans:
Cut Ctrl+X Or
Shift+Delete (In MS Word) Copy Ctrl+C Paste Ctrl+V Undo Ctrl+Z Redo
Ctrl+Y Centre Alignment Ctrl+E Spell Check F7 Save as Ctrl+F12 File Open
Ctrl+O Close File Ctrl+F4 Print Ctrl+P Select All Ctrl+A Find Ctrl+F
Replace Ctrl+H Go To Ctrl+G or F5 Hyper Link Ctrl+K Save Ctrl+S
Q111.What
is table ,Record, Field, Data types?
Ans:
Ans : A Table
holds data about a particular item, such as products or suppliers. A Record is
a collection of information which relates to a particular item within your
database table. for instance a record in an address book may consist of the
first and second name of a person. A Fields are the individual items which make
up a record with your database. Field data types: A Field must have a specific
data type format. We will see more about this later, but for now the
illustration shows you the data types which are available within Microsoft
Access, including Text, Number, Currency etc.
Q112. What is Index? Why Index is
necessary for a table data?
Ans:
Ans : An index
allows Microsoft Access to work faster when finding and sorting records. They
work in a similar way to the way you would use an index in a traditional book,
i.e. Access uses the index to find the location of the required data. Indexes
can be created using a single field, or using multiple fields. Using Access you
normally set up a number of tables, such as Customers, Products, Orders,
Employees etc.
Q113.
Write the basic designing rules of a
table within a database
Ans:
: Basic design
rules of a table within a database, it will make your life much easier when
using the database. # Make each record unique. # Make each field unique. # Make
fields functionally dependent. # Ensure each field is independent. # Ensure
fields don’t contain calculated or derived data. # Ensure data is in its
smallest logical parts
Q114..
How would you create a table and specify field data types ?
Ans:
Create a table
and specify field data types , In the objects section on the main dailog box,
make sure that Tables selected. Double click on the Create table in Design view
option, which will open a dialog box allowing you to create a table. in the
Field Name section of the dialog box, enter the name of the first field. in this
example we have entered First name’.
Q115.How would you create a table and
specify field data types ?
Ans:
Ans : Create a
table and specify field data types , In the objects section on the main dailog
box, make sure that Tables selected. Double click on the Create table in Design
view option, which will open a dialog box allowing you to create a table. in
the Field Name section of the dialog box, enter the name of the first field. in
this example we have entered First name’
Q116. What is Key board short cut for moving to a
specific record?
Ans : Moving to
a specific record using the keyboard shortcut. Press F5 to highlight the record
number on the scroll bar, type the number on the record you want .press
Enter.
Q117. How many types of relationship in MS Access ? Describe .
Ans:
ANS : Click on
the tools drop down menu and select Relationships. if the show table dialog box
is not already displayed click on the show table icon on the Relationship
toolbar. Select the table you want to add button. select a second table from
the show table dialog box, click the add button. the relationships widow should
now resemble the illustration below. 1. What is Enforce Referential Integrity,
Cascade Update Related Fields, Cascade Delete Related Fields
Q118.7. Say some thing about absolute
referencing and relative referencing .?
Ans:
Ans :Absolute
reference is used to make the reference fixed. The reference cell will not
change with the change of the cells in which we put the formula. F4 is used to
wake a cell reference absolute. A $ sign appears before both the column and row
number .e.g. $ A $1 relative reference is the reference which will change it we
copy the formula or reference to anther cell.
Q119.What is the difference between the WWW
and Internet?
Ans:
The world wide
web is just a small part of the Internet as a whole. The WWW is basically the
text and pictures which can be viewed using web browsers. Internet is a
worldwide network of computers that can be accessed via the computer network.
Internet is a system of Internet servers that support especially formatted
documents. The documents are formatted in a language called Hyper Text Mark-up
Language (HTML). Internet relates to hardware, software, WWW, ITP, email and
newsgroups. Not all Internet servers are part of the World Wide Web.
Q120.Define the term:
HTTP:
Ans:
HTTP stands for
Hyper Text Transfer Protocol. HTTP is the language every web browser uses to
request pages and graphics from any web server. When we type in a web address
in the address bar and press Enter, http:// is automatically inserted to the
left of the address E. g. http://www.yahoo.com
Q121.Define the term:
URL:
Ans:
URL stands for
Uniform Resource Locator. Earlier it was called Universal Resource Locator. URL
is the unique address for a file that is accessible on the Internet. URL
contains two things: Resource and Pathname. Resource is a hierarchical
description that specific computer on the Internet. Pathname is a hierarchical
description that specifies the location of a file in that computer.
Q122.Define the term:
Hyperlink:
Ans:
Hyperlink can be
a piece of text or embedded graphic by clicking on which may take you to
another page within the same web site or to a page of another web page. It can
also be used to download any file such as document , video, audio or
pictures.
Q123.Define the term:
ISP:
Ans:
ISP stands for
internet Service Provider. To connect to the Internet we first need to have an
Internet connection. ISP provides the Internet connection to the users. ISP can
give Internet connection via telephone, Digital Subscriber Line (DSL), Local
Area Network (LAN) and Radio network.
Q124.Define the term:
FTP:
Ans:
FTP stands for
File Transfer Protocol. FTP is a way to transfer data from one place to another
via Internet. If we want to change or modify contents of a webpage we have to
use FTP. Internet browsers use FTP to download large size of files.
Q125.Define the term:
Website:
Ans:
Websites are
created by bunch of data and is stored on a server that is connected to
Internet and this data can be freely accessed by people surfing the Net. Every
site has its own web address called Universal Resource Locator (URL). To browse
a website we have to type in the URL of that site in the address bar of the web
browser.
Q126.Define the
term:
Web Browser:
Ans:
Web browser is a
sort of utility software that allows us to view and browse HTML documents or
websites stored on the Internet server. Microsoft Internet Explorer is a common
web browser that comes bundled with Windows OS. Some other browsers are:
Mozilla Firefox, Opera, Netscape Navigator, Safari (MAC) etc.
Q127.Define the term:
Search Engine:
Ans:
Internet Search
engines help users find web pages on a given subject. Search engines maintain
databases of web sites and use programs, often referred to as spiders or
robots, to collect information, which is then indexed by the search engine.
Sites have to get listed on search engines first in order to be found on search
result. Some examples of search engines are: Google, Yahoo, MSN, Hot Bot,
AltaVista etc.
Q128.Define the term:
Cookies:
Ans:
Websites
sometimes store hidden information about the user on his computer’s hard disk.
Cookies are small texts which is stored in small text files on the computer by
a website. Cookies hold information on the times an dates of visit, about
online purchases or validation for members-only websites. Cookies are also used
by some sites to identify the user.
Q129.Define the term:
Internet Cache:
Ans:
Cache is
information that is stored in a folder on the hard disk when the user visits a
webpage. This information may include text, pictures or even the entire webpage.
when the user visits the page next time the web browser loads the information
from the cache folder rather than reloading them from the Internet; thus it
saves time. We can periodically clear cache to regain hard disk space.
Q130.Define the term:
Digital
Certificate:
Ans:
A digital
certificate is a special kind of message that contains information about who it
belongs to, who it was issued by, a unique serial number or other unique
identification, valid dates and an encrypted fingerprint that can be used to
verify the contents of the certificate. Digital certificates are issued by
trusted third parties known as Certificate Authorities. It can be used to
create a digital signature for an email which identifies the sender. A digital
certificate is also an electronic credit card.
Q131.Define the term:
Encryption:
Ans:
Encryption is a
system that makes a message more secure. It is the method of rendering data
unreadable to everyone except the intended receiver. There is different level
of encryptions which defines different level of security. Such as 128 bit
encryption is much more secured then 32 bit encryption. Spy-Ware is software
that records the user’s activity and can therefore help hackers to get the
user’s information such as passwords, bank account or credit card information.
Along with antivirus software we have to install anti-spy-ware software to have
complete protection of our computer if we surf the Net frequently.
Q42.What is speard sheets?
Ans:
A table of
values arranged in rows and columns. Each value can have a predefined
relationship to the other value, therefore, you may need to change other values
as well.
Q43.How you can change the default work
sheet in the work book?
Ans:
From office
button excel option, popular tabs, when creating new wordbook, include this
many sheet.
Q44.What is Sort Data?
Ans:
Short data is a
procedure by which we can decorate the total data as numerical and alphabetical
value.
Q45.What is auto fit and auto
correct?
Ans:
Auto fit is an
automatic determination of the best width for a column or best height for a
row, based on its content. Auto correct is Text replacement, Replace as you
type or AutoCorrect is a software function commonly found in word processors
such as Microsoft Word. Its principal purpose is to correct common spelling or
typing errors, saving time for the user.
Q46.What is Digital signature?
Ans:
A Digital
signature is a code which is attached to an email to uniquely identify the
sender. It is like a traditional hand written signature. Digital signatures
employ sophisticated encryption techniques to ensure that cannot be
counterfeited.
Q47.What
is MS Outlook? What are the folders contained in Outlook?
Ans:
Microsoft
Outlook is a software bundled with MS Office Application Package. It is used to
read, send and manage email messages. The components of Outlook are organized
into folders. There are folders for messages, appointments, notes, tasks
etc.
Q48.What are the groups contained in
Outlook bar?
Ans:
We can open
folders by clicking the appropriate icon on the Outlook bar. The Outlook bar is
divided into three groups called: Outlook, My Shortcuts and Other Shortcuts.
The Outlook Shortcuts group is selected by default.
Q49.What are the fields contained in the
email message header?
Ans:
The message
header displays the details of the message in five fields. 1) From: the name of
email address of the person who sent the message. 2) To: the names or email
addresses of the recipients of the message are listed here, separated by a
semicolon. 3) Cc: the name or email addresses of persons receiving a copy of
the message are listed here, separated by a semicolon. 4) Subject: a short
description of the message topic. 5) Sent: the date message was sent.
Q50.How to remove/add an inbox
heading?
Ans:
To remove: open
the inbox folder →right click on the heading and select ‘Remove this Column’.
To add: open the inbox folder→right click on any of the current headings and
select the ‘Field Chooser’, available fields are listed in the centre of the
‘Field Chooser’ window; we can also choose other selection of column heading
from the dropdown list at the top of the window→drag and drop the desired
heading on top of the existing column heading→close the ‘Field Chooser’
window.
Q51. What is the benefit of using Flag
to email message? How can we set or remove flag?
Ans:
Flag is like a
mark which we can use to remind us to respond to the email in the inbox. To set
flags: if necessary open Inbox folder→double click on the message to display
the message dialog box→click the ;Flag for Follow Up’ icon on the Message
dialog box toolbar to display the ‘Flag Follow Up’ dialog box→select the flag
type from the ;Flag to’ dropdown list→set’ Due by’ date and ‘Flag color’ if
required→click OK—close the dialog box. To remove flags: open Inbox
folder→double click on the message to display the Message dialog box→click the
‘Flag for Follow Up’ on the Message dialog box toolbar to display the ‘Flag for
follow Up’ dialog box→click on ‘Clear Flag’ button→click OK→close the dialog
box.
TEACHER :
Q16.How can you hide images on a web
page?
Ans:
Tools → Internet
Options → Advanced tab → scroll down and find Show pictures check box under
Multimedia section → uncheck Show pictures → click Apply.
Q17.How can you delete the history trail from Internet
Explorer?
Ans:
Tools → Internet
Options → General tab → click Clear History within the history section.
Q18.How
can you add a web page to your Favourites?
Ans:
Favourites menu
→ Add to Favourite → from the dialog box displayed click on OK.
Q19.How
can you create a new folder within Favourites?
Ans:
Favourites menu
→ Organize Favourites → from dialog box displayed click on Create Folder →
enter a name → press Enter → click Close.
Q20.How
can you add a web page to a particular bookmark folder?
Ans:
Favourites menu
→ Add to Favourites → from the dialog box displayed click on ‘Create in’ button
→ select the folder in which the site to be added → click OK.
Q21.How can you delete or rename a
bookmark?
Ans:
Favourites menu
→ Add to Favourites → from the dialog box displayed select the item/items to be
deleted → click Delete / Rename (give a name and press Enter) → click OK.
Q22.How
can you download files from a web page to a document?
Ans:
Within the
Microsoft Internet Explorer right click on the source and select the ‘Save
Target As’ command → from the dialog box displayed select a location and click
Save.
Q23.How
can you print selected frames within a framed web site?
Ans:
File → Print →
Options tab → check the radio button as required: As laid out on screen/Only
the selected framed / All frames individually → click Print button.
Q24.What
is the structure of an email address? Discuss briefly.
Ans:
There are four
parts of an email address. Let’s take an email address for example:
random@gmail.com 1)The first part ‘random’ is the name of the owner or user of
the email. 2)@ symbol marks the end of the user name. 3)@ symbol is followed by
one or more sub-domains, separated by periods: in the example above ‘gmail’ is
the sub-domain. Sub-domains are registered by organizations or individuals to
give themselves an Internet identity. 4)At the end of the email address there
is TLD (Top Level Domain); in the example the TLD is ‘.com’ indicating an
international company. There are other TLDs such as ‘.net’, ‘.org’, ‘.biz’ and
‘.info’ designed to identify different types of organization.
Q25.What
are the advantages of using email?
Ans:
1) High speed :
we can send messages and files to anyone in the world almost instantly. 2)Low
cost: the cost of sending information by email is a fraction of that involved
when using the traditional mail system, especially when emailing to a different
country. 3)World-wide portability: once an email account is setup, it can be
accessed from anywhere that has an internet connection.
Q26.What are the simple rules/Netiquette
when sending emails?
Ans:
There are some
simple rules when sending emails: 1)Use short, accurate subject descriptions:
keep emails simple, short and to the point. 2)Avoid using all upper case can
letters in a message: upper case is considered as shouting within an email. All
upper / lower case can make the message difficult to read. 3)Be brief: people
tend to skim read email messages; too long message create chances of missing
important information. 4)Use the spell checker: spelling mistakes create bad
impression. 5)Respect privacy and confidentiality: leaking information via
emails can create huge problems regarding personal / official relationships.
6)Don’t ‘Flame’: never reply to unsolicited emails; just don’t respond- it is
called flaming.
Q27.How
should you handle spam or unsolicited emails?
Ans:
We have to be
very careful about opening files which are attached to email messages as they
may contain viruses. Even Microsoft Word documents can contain special types of
virus called macro viruses.
Q28.How
can you open an attached file?
Ans:
If necessary
open Inbox folder → double click on the message containing the attached file →
double click on the file icon displayed under the Subject line.
Q29.How
can you save a file attached to message?
Ans:
If necessary
open Inbox folder → double click on the message containing the attached file →
click File dropdown menu → select ‘Save Attachments’ → click ‘Save All
Attachments’ if there are more than one file → select the files from the ‘Save
All Attachments’ dialog box → click OK → select the folder click on the Save
button → close the dialog box.
Q30.How can you options to reply with or
without original message insertion?
Ans:
Open Inbox
folder → Tools → Options → Preferences tab → E-mail Options button → select
‘Include original message text’ or ‘Do not include original message’ from the
‘When replying to a message dropdown list’ → click on OK to close the E-mail
Options → click on OK button to close the Options dialog box.
Q31.What is the difference between Cc
and Bcc?
Ans:
Cc stands for
Carbon copy. In the Cc text box, we insert or select a person’s name or email
address to send a Carbon Copy of the message being sent. Bcc stands for Blind
Carbon Copy. In the Bcc text box we insert or select a person’s name or email
address to send a carbon copy of the message being sent. But the difference is
this copy is sent in select i.e. other recipients of the message will not know
that the selected person has received the message.
Q32.What
are the features included in spell checking within Outlook?
Ans:
Tools → Spelling
(F7); spell checking includes: Not in Dictionary, Suggestions, ignore, Ignore
All, Change, Change All and Add.
Q33.How
can you attach file to a message?
Ans:
After we have
finished entering the text of our message → Insert → File → select the file →
OK.
Q34.How
can you send message with high or low priority?
Ans:
Options → click
down arrow to the right of the Importance box in the ‘Message settings’
selection and select Low/Normal/High from the menu displayed → click Close.
Q35.What
are the techniques to manage emails effectively?
Ans:
There are four
basic techniques to manage emails effectively: Delete unwanted emails
immediately. Create folders with meaningful names and move emails to a relevant
folder. Delete outdated emails. Use email address lists.
Q36.How can you create a new address
book distribution list?
Ans:
Open the Inbox
folder → Tools → Address Book (dialog box) → File → New Entry (dialog box) →
select New Distribution List → Click OK, Distribution List window will be
displayed → type a name for the distribution list → click on add New button →
type the name of the person in the Display name text box → type the email
address of the person in the Distribution List window → close the Address
Book.
Q37.How
to set automatically emptying the deleted items folder when exiting
Outlook?
Ans:
Tools → Options
→ Other tab → select ‘Empty the Deleted Items folder upon exiting’.
Q38.How to save a table in Access?
Ans:
Before a table
can be used to store information , fields must be added to a table , named ,
given the correct data type and formatted appropriately. Fields are used to
separate and organize data into specific fields (columns), for example a first
name field would store the first name for every individual record entered, as
would Surname, Birth date fields, etc. Click on the Save button the Quick
Access Toolbar or press the Ctrl + S keys to save the table.
Q39.How to adds fields in design view in Access?
Ans:
• In the
Navigation Pane, right-click the table that you want to change, and then click
Design View on the shortcut menu.
-or-
On the Access
status bar, click Design View.
• In the Field
Name column, select a blank row and type a name for the new field.
• In the Data
Type column, next to your new field name, select a data type for the new
column.
• Save your
changes.
Q40.What
are the Steps to close table in Access
Ans:
a. Click on the
Office Button
b. Select the
close database command.
Q41.Steps to
rename table in Access:
Ans:
a. Select (but
not open) the table
b. Right click
on the table and
c. from the
popup list displayed select the Rename command
d. Now Edit the
table name and then Enter
42.
What are the Steps to edit data within a record in Access?
Ans:
a. Open table
b. Select the
Data to edit
c. Edit data and
then press Enter
Q43.What are Steps to delete data within a
record in Access
Ans:
a. Open table b.
Select the data to delete c. press Delete or the Backspace key to Delete the
data
Q44.How
to undo in Ms Access?
Ans:
press
Ctrl+Z
Q45.Describe
data type in acccess?
Ans:
data types in
acccess are as follows:
Text :
Alphaanumeric characters up to 255 charecters in length, can be used for text
or text and number that are not used in calculations.
Memo:
Alphanumeric characters (Maximum of 65535 Character’s \) and can store text
with rich text formatting (.rtf)
Number : Numeric
values including fractional or integers, used for numbers likely to be used in
calculations but should not be used in place of the currency data type
Date/Time Dates
and times values, Stores both a data component and a time component even when
only displaying one or the other.
Currency :
monetary values, (with or without a currency sysbol)
Auto Number : A
unique and sequential number inserted automatically each time a new record is
added
Yes/No: Yes?no,
True?Fales Value(ticked is Yes, Un0ticked equals No)
Ole object: Used
for storing OLE objects from others Microsoft windows application
Hyperlink Used
for storing hyperlinks to provide access to web pages or files using a single
click
Attachment
Pictures, Images Binary files, office files. Storage size limited to 700Kb
Lookup Wizard… :
Starts a lookup wizard to create a combo box to look up values.
Q46.In design view how to set data type
of a column
Ans:
To Set a data
type of column
1.Go to View
button to switch to Design view.
2. move the
pointer to the data type column
3. Click on the
down arrow to expand the drop down list of data type.
4. Select data
type as you desire.
Q47.How to move a column to re arrange
the column order.
Ans:
Move the mouse
pointer to a column filed name, such as price, When the pointer
changes to a
down arrow, click once to highlight, the column.
1 Click and hold
the Field Name. Use the thick dark line (Left of the highlighted
column) as a
guide to the new position.
2. Drag the
column until the guide line is between two columns.
3. Release the
mouse button.
Q33.what is filtering in access
Ans:
Filtering an
Access datasheet is a way to focus on specific records, rather than all the
records in a table. You can filter out records that aren't relevant to what
you're trying to do at the moment.
Q34.down the
steps inserting the row in a worksheet in excel?
Ans:
The Steps of
inserting row are given below.
Step 1: Select a
row in a worksheet.
Step 2: Right
click on the selected row.
Step 3: From the
popup menu click on the insert command.
Q35.Write
down the steps inserting the column in a worksheet?
Ans:
The Steps of
inserting column are given below.
Step 1: Select a
column in a worksheet.
Step 2: Right
click on the selected column.
Step 3: From the
popup menu click on the insert command.
Q36.Write down the steps deleting the rows in a
worksheet in excell?
Ans:
The Steps of
deleting the row are given below.
Step 1: Select
the relating rows in a worksheet.
Step 2: Right
click over the selected rows.
Step 3: From the
popup menu click on the delete command.
Q37.Write
down the steps deleting the columns in a worksheet?
Ans:
The Steps of
deleting column are given below.
Step 1: Select
the relating c in a worksheet.
Step 2: Right
click over the selected column.
Step 3: From the
popup menu click on the delete command.
Q38.Write
down the steps modifying column width in a worksheet in excell?
Ans:
The Steps of
modifying column width are given below.
Step 1: Select a
column in a worksheet.
Step 2: Right
click over the selected column.
Step 3: From the
popup menu click on column width.
Step 4: From
column width dialog box set the column width.
Q39.Write
down the steps modifying column width by using drag and drop in a worksheet in
excell?
Ans:
The Steps of
steps modifying column width by using drag and drop are given below.
Step 1: Move the
mouse pointer to the line between the head part.
Step 2: By
keeping pressed the mouse pointer move it left or right to make the column
narrow or wider.
Q40.How
to automatically resizing the column width to fit content?
Ans:
The Steps of
automatically resizing the column width to fit content are given below.
Step 1: Select
all the columns containing data.
Step 2: Double
click on the junction between one of the column header within the selected
columns.
Q41.Write down the step to open workbook, close work
book, step to create workbook steps to save in excel?
Ans:
1. To open
workbook in excel we follow.. Click on the ms office button and then click on
the open command/press ctrl + O,
2. To close a
workbook click on the MS office button and then click on the close command.
3. Closing the
application click on the close icon which the small cross displayed at the top
right of the excel screen/click on the ms office button+ exit excel button
4. Creating a
new work book –click on the ms office button + New create/Ctrl+N
5. Click on the
MS office button + save command + select file name file location +Select file
type save.
Q42.Why
CSV use in excel?
Ans:
CSV means comma
separated value. It is used to saves table data in such a form that can be used
by other’s programs.
Q43.How
to switch between workbook.
Ans:
Open 3 or more
work book and then to switch to a particular excel workbook. Click on the
relevant excel workbook in con displayed within the windows taskbar (across the
bottom of the screen) Or we can use alt+ tab to switch between open
program.
Q44.Why
index is used in access?
Ans:
To help locate
and sort information quickly
Q45.What
is Navigation Pane?
Ans:
The Navigation
pane displays all objects contained within the database including all tables
forms quaries and reports when working on large objects the Navigation pane can
be minimized by
Step-1.Clicking
on the (left pointing ) arrow button, top right of the pane.
Step-2. To
restor the pane to normal view click on the right pointing arrow button at the
top of pane.
Step-3:-Object
categories can also be minimized/maximized using the up/downward pointing arrow
buttons.
Q46.What is the difference between notepad and
WordPad?
Ans:
Both notepad and
WordPad are text editors that are included with the Windows operating system.
Notepad does not provide text formatting options. But WordPad provides text
formatting options.
Q47.What
is primary key?
Ans:
A primary key is
used as a unique identifier for each record in a database table and is
essential when working with relational tables.
primary key
cannot have duplicate entries and must be set on a field generating a unique
identifier.
Q48.Discuss
the field properties in Access?
Ans:
field size:
maximum number of characters or width
format: how the
field is to be displayed
input mask: a
template to allow ease of use in input
caption: another
name for a field which will be displayed
default value:
automatic value, may be overridden
validation rule:
logical expression which must be met by input data
validation text:
text which is displayed when the validation rule is not met
required: is
this field required to be filled
allow zero
length: allow zero length strings
indexed: should
this field be used as an index for quick sorting and selection
number of
decimal places: for numeric data, number of places to the right of the decimal
point
Q49.In
validation rule which comparison operators are used?
Ans:
> - greater
than
< - less than
= - equal to
>= - greater
than equal to
<= less than
equal to
<> - not
equal to
Q50.In
Access in field properties which logical operators are used? Describe
them?
Ans:
And - true both
conditions are true
Or - when anyone
of the two condition is true
Eqv - true when
both values are equal
Not - true when
condition is false and false when condition true
Xor - true when
anyone condition is true but not both
Q16.Steps
modifying row heights in Excel?
Ans:
1. Select one or
more rows and then right click over the selected row(s)
2. Select the
row height command from the popup displayed.
3. The row
height dialog is displayed allowing you to set the exact row height, as
required.
4. Save change
and close the workbook.
Q17.Steps
Freezing and column titles in Excel?
Ans:
1. Click on the
view tab and from within the window group on the ribbon.
2. Click on the
Freeze panes command.
3. From the drop
down list displayed, click on the freeze top row command.
Q18.Write
down the step to select a range of connecting cell in excel?
Ans:
If we want to
select the cells from C3 to G3, then we have to click on the first cell within
the range, i. e. C3. →Then press down the shift key & keeping it held down,
click on the cell G3.→release the shift key .Now the cell range is
selected.
Q19.Write
down the step to select a range of non-connecting cells in excel?
Ans:
If we need to
select multiple cells that are not beside each other, as example, where we need
to select C3, E3 and G3 .To do this click on first cell, I .e .C3.→then keeping
Ctrl key press click on the cell E3 and G3.→now release the Ctrl key, the cells
will remain selected.
Q20.Write
down the step to select a row cell in excel?
Ans:
To select a row,
click on the row number displayed down the left side of the worksheet .The row
will be selected.
Q21.Write down the step to select a range of
connecting rows in excel?
Ans:
to select a
range of connecting rows, as example if we want to select row number 5 to row
number 8, click the row number 5 (displayed down the left side of the
worksheet)→press down the shift key &keep it press click the row number
8.→release the shift key. The multiple rows remain selected.
Q22.Write
down the step to select a range of non-connecting rows in excel?
Ans:
To select a
range of non-connecting rows, as example: If we want to select row number 3, 5,
7, and 9. First click the row number 3 → and press down the Ctrl key and keep
it press, click on the row number 5, then row number 7 and finally row number 9
. → Release the Ctrl key. The rows will remain selected.
Q23.Write
down the step to select a column in excel?
Ans:
To select a
column, click on the column header .The column will be selected.
Q24.Write
down the step to select a range of connecting columns in excel?
Ans:
To select a
range of connecting column, as example: If we want to select the column C to F.
First select the column C. →then press the shift and keep it press select the
column F.→ release the shift key the column will remain selected.
Q25.Write
down the step to select a range of non-connecting columns in excel?
Ans:
To select a
range of non-connecting columns, as example: if we want to select the column C
, E and G. First select the column header C, → then press the Ctrl key and keep
it pressed, select column header E and then column header G. → release the Ctrl
key. The columns will remain selected.
Q26. What are
the Types of Table Relationships in access? Describe them?
Ans:
Types of Table
Relationships:
One-To-Many
Relationships
Many-To-Many
Relationships
One-To-One
Relationships
One-To-One
Relationships: In a one-to-one relationship, a row in table A can have no more
than one matching row in table B, and vice versa. A one-to-one relationship is
created if both of the related columns are primary keys or have unique
constraints.
Many-To-Many
Relationships: In a many-to-many relationship, a row in table A can have many
matching rows in table B, and vice versa. You create such a relationship by
defining a third table, called a junction table, whose primary key consists of
the foreign keys from both table A and table B.
One-To-Many
Relationships: A one-to-many relationship is the most common type of
relationship. In this type of relationship, a row in table A can have many
matching rows in table B, but a row in table B can have only one matching row
in table A. A one-to-many relationship is created if only one of the related
columns is a primary key or has a unique constraint. In Access, the primary key
side of a one-to-many relationship is denoted by a key symbol. The foreign key
side of a relationship is denoted by an infinity symbol.
Q27.What
is query in Access?
Ans:
Queries are the
primary mechanism for retrieving information from a database and consist of
questions presented to the database in a predefined format.
Q28.Why
Query is used in Access?
Ans:
1. used to
extract and analyse data within one or more tables
2. can be saved,
edited and reused.
3. Queries are
also capable of working with data across multiple tables.
Q29.What are
the types of query in Access?
Ans:
select query: is
the simplest type of query and because of that, it is also the most commonly
used one in Microsoft Access databases. It can be used to select and display
data from either one table or a series of them depending on what is needed.
Append Query:
takes the set results of a query and "appends" (or adds) them to an
existing table.
Delete Query: deletes all records in an
underlying table from the set results of a query.
Make Table Query: as the name suggests,
it creates a table based on the set results of a query.
Update Query: allows for one or more
field in your table to be updated
Q30.What is form in Access? Why it is
used?
Ans:
Forms provide an aesthetically pleasing window
to enter and display record information. Forms can be used to display and
maintain records within database. Forms can be designed to display fields from
multiple tables and also can be used to restrict what users have access to. In
addition buttons can also be added to provide automated functionally
Question:
- Describe
data type in excess? 415-416
Ans
: There are several data types to choose from and one or two i.e. text has the
ability to except and store most data input, however data output, searching
producing reports, calculating value, etc, will present a problem.
The
following data type table provides a description of the types of data each data
type can store, format and perform searches and calculation on
1.
Text : Alphaanumeric characters up to 255 charecters in length,
can be used for text or text and number that are not used in calculations.
2.
Memo Alphanumeric characters (Maximum of 65535 Character’s \) and
can store text with rich text formatting (.rtf)
3.
Number : Numeric values including fractional or integers, used for
numbers likely to be used in calculations but should not be used in place of
the currency data type
4.
Date/Time Dates and times values, Stores both a data component and
a time component even when only displaying one or the other.
5.
Currency : monetary values, (with or without a currency sysbol)
6.
Auto Number : A unique and sequential number inserted
automatically each time a new record is added
7.
Yes/No: Yes?no, True?Fales Value(ticked is Yes, Un0ticked equals
No)
8.
Ole object Used for storing OLE objects from others Microsoft
windows application
9.
Hyperlink Used for storing hyperlinks to provide access to web
pages or files using a single click
10.
Attachment Pictures, Images Binary files, office files. Storage
size limited to 700Kb
11.
Lookup Wizard… : Starts a lookup wizard to create a combo box to
look up values.
- In design
view how to set data type of a column. – 416-417
Ans
: To Set a data type of column
1.Go
to View button to switch to Design view.
2.
move the pointer to the data type column
3.
Click on the down arrow to expand the drop down list for the Par description
row.
4.
Select data type as you desire.
3. How to adjust column width in access.
Ans:
if you have used Microsoft excel then the same basic techniques can be used for
adjusting column width. In the datasheet view, the new fields are now displayed
across the top of the table, however not all the field names are clearly
visible.
- Move
the Mouse Pointer on the divider which is between two fields the shape
will change than Drag the mouse with pressing the left button.
- To
increase/Decrease t he width of all at the same time, place the pointer
over the left most (1st) field name cell. The pointer will
change to a down arrow.
4. How to move a column to re arrange
the column order.
Ans
: Move the mouse pointer to a column filed name, such as price, When the
pointer changes to a down arrow, click once to highlight, the column.
1
Click and hold the Field Name. Use the thick dark line (Left of the highlighted
column) as a guide to the new position.
2. Drag the column until the
guide line is between two columns.
3.
Release the mouse button.
0 comments:
Post a Comment