Module- 01 Concepts of IT
1.What is Hardware andAns: Hardware: The term hardware refers to the physical components of our computer that we can
physically touch. Such as the system unit, mouse, keyboard, monitor etc.
2. Write the types of some computers.
Mainframe, PC, Mac, Laptop, Palmtop, PDA, Notebook.
Mainframe computer: Mainframe computers are the big, powerful, expensive computers used in the
background by most large organizations.
PC: PC means Personal Computer. A personal computer (PC) or micro-computer is any general
purpose computer whose size, capabilities, and price make it useful for individuals and which is
intended to be operated directly by an end user
Mac: The apple Mac is a PC. It uses different operating system, and requires special versions of
application programs.
Laptop/Notebook & Tablet PC: are small portable computers which can run on batteries as well as
mains power.
Palmtop: A small computer that literally fits in your palm. Palmtops are limited, but practical for certain
functions such as phone books and calendars.
PDA: PDA means Personal Digital Assistant. . PDAs are used for sorting and retrieving information. They
have many built in features such as calculator, clock and calendar. PDAs can be used for sending
and receiving mail, browsing the web, video calling, word processing, scanning bar codes,
accessing GPS, playing games and so on.
3. What is CPU speed?
Ans: CPU speed is the measurement of the data processing capacity of the CPU. CPU speed is measured
in Megahertz or Gigahertz.
4. Whics Factors are those affect computer performance?
Ans: That can affect the performance of your computer.
I. CPU speed
II. RAM size
III. Type of graphics card processor and memory
IV. Numbers of running applications.
5.What is computer memory?
Ans: Computer memories are the devices. They store information temporarily/virtually or
permanently/physically.
6.What is RAM, ROM, ROM-BIOS?
Ans: RAM : Random Access Memory (RAM) is the main 'working' memory used by the computer. When
the operating system loads from disk when we first switch on the computer, it is copied into RAM.
ROM: Read Only Memory (ROM) as the name suggests is a special type of memory chip which holds
software which can be read but not written to.
ROM-BIOS: The 'Read Only Memory-Basic Input Output System' chip is a chip located on the computer's
system (mother) board, which contains software. When we first switch on the computer the ROM-BIOS
software performs a self-diagnostic to check that the computer is working OK.
7. What is an input device?
Ans: Input devices: Input devices allow you to input information to the computer.
Some Input devices: Keyboard, Mouse, Scanners, Tracker balls, Touch pads, Joysticks, Web cams, Digital
cameras, Microphones.
8. What is an output device?
Ans: Output Devices: The devices which allow to output or display information from computer is
called output devices.
Some Output Devices: Monitors, Speakers, Headphones, Printers are the example of Output devices.
9. What is modem?
Ans: A modem is device which works as medium to connect to the internet. It is a two way
communication device because it works both as an input and output device. A modem downloads and
uploads data via the Internet.
Modem and Touch Screen Device are Input Output Devices
10. What is software?
Ans: Software is the collection of instructions which makes the computer work. A software is basically
as collection of instructions which makes the computer perform a certain task.
11. What is the difference between “operating system” and “application software”?
Operating System: The operating system is a special type of program which loads automatically when
we start our computer. That talk to the computer how to do the work.
Application program: The application programs sit above the operating system, and make use of the
functionally built into the operating system. They are specific to a particular task.
12.What is the types of Network?
Ans: The types of Network are as follows: LAN, WLAN, WAN, Client/Server Network, Internet, Intranet,
Extranet:
13. What is LAN?
Ans: A LAN or Local Area Network is a computer network system whereby individual PCs are connected
together within a company or organization. A LAN is useful for sharing resources like files, printers,
games or other applications.
14. What is WLAN?
Ans: wireless local area network. Allows to connect two or more computer within LAN without cables.
15. What is WAN?
Ans: Allows connecting to other Computers over a wider area.
16. What is Client/Server Network?
Ans: An arrangement where some programs, files or other resources are located on a powerful
computer, called the server, but are available to other users via the network. Clients rely on
servers for the resources, such as files, devices, and even processing power.
17. What is Internet, Intranet & Extranet?
Internet: The Internet is a global network of interconnected networks. The Internet relates to all
the hardware and software involved, as well as the WWW. It also includes FTP, Email and
Newsgroups.
Intranet: An intranet is a smaller, closed version of Internet, which can only be accessed by
authorized members of an organization.
Extranet: An extranet is an Intranet which is partially accessible to authorized outsiders. Extranet
allows outsiders to gain limited access to information held on a company network.
18. What does Information and Communication Technology (ICT) mean?
Ans: ICT stands for Information and Communications Technology. ICT covers computer related fields
including:
I. Installing and maintaining computer systems and applications
II. Designing, installing and maintaining computer networks
III. Data management
IV. Computer hardware maintenance
V. Database and software design
19. How can ICT enhance our everyday life?
Ans: ICT can enhanced lives by improving timely distribution of information through the media
and improved communications in homes and work places through social networks, emails, etc.
Importantly, ICT has tremendously improved the quality of human life, especially on the social
front.
20. Write about the future of IT in Bangladesh
Ans: At present Information Technology (IT) is a subject of widespread interest in Bangladesh.
The Government has declared IT as a thrust sector. ICT based services are taking place to the traditional
office management System. From Offices to Medical services, Education to Industries everywhere
service or production is becoming ICT dependant. So the future of IT in Bangladesh is immense
bright as will be the widespread demand of IT professionals in the coming days.
21. What is e-commerce? How can we be benefitted by it?
Ans: E-Commerce: The phrase e-commerce is a buzzword which relates to buying or selling via
the Internet.
Benefit: E-commerce can be highly beneficial. It allows us to shop via the internet 24 hours a day, 7 days
a week and 365 days a year. It has large stock range and ability to compare price.
22. What are the advantages and disadvantages of e-commerce?
Advantages are:
I. Services available 24 / 7.
II. Large stock range.
III. Detailed product information.
IV. Ability to compare prices.
V. Equal delivery to town and country.
VI. Right to return defective goods.
Disadvantages are:
I. Possible Credit Card fraud
II. Suspicion regarding the originality of the website
III. Uncertainty about the return of faulty goods
IV. Customer service not guaranteed
V. Website may not be genuine.
VI. Barrier of international laws regarding overseas shopping (How are you covered when you
purchase goods from another country?)
23. What is e-banking? What are the advantages of e-banking?
E-banking : The phrase e-banking relates to managing your money online using internet.
Advantages:
For Bank, operating costs is reduced
For customers, 24-hour access to services
For customers, e-banking is easier as compared to banking at branches.
Disadvantages:
No physical person to make complain.
Poor security of online system may loose user bank balance.
Create many jobless in the Banking sector.
24. What are the usages of computer at the bank area?
Ans: The computer technology has many different uses in the banking sector. They are
i. Use of automated teller machines (ATMs)
ii. Use of computerized telephone and Internet banking services
iii. Use of computerized smart cards
iv. Computer has also made it easy to store and retrieve customer data
25.what are the advantages of E-government?
Ans: i. Census ii. vehicle registration. iv. Revenue collection v.
Electronic voting
26.What is E-learning? What is its advantages or disadvantage?
Ans: E-Learning: E-learning refers to learning via the Internet or working through a disk based tutorial
Advantages:
i. Distance learning system.
ii. Can use internet as homework resource
iii. Cheaper
iv. Learning facilities is available 24/7
v. One trainer can train many people at many different locations at a time.
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.
iv. You may have to pay for the connection time, by the minute.
27.what is tele-working? What are the advantages or disadvantage?
Ans: Tele-working means 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 one 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.
28. 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.
29. What is IM?
Ans: Instant messaging (IM) provides a mechanism for real-time communication between two or more
people sending text messages via their computers.
30. What is VoIP?
Ans: Voice over Internet Protocol, (VoIP pronounced voyp), is a technology
that allows us to talk with other people via the Internet.
31. What is podcast?
Ans: The term "podcast" is a combination of the words "iPod" and "broadcast". It is a way of providing
content 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.
32. What are the uses of computer in Hospital area?
Ans: The use of computers in hospitals are as follows:
i. Use in accurate 'tests' and medical examinations
ii. Use in faster medical alerts, which are more accurate time-wise
iii. Use in enhanced data about a patients medical history
iv. Use in Diagnosis of diseases
v. Use in Patient’s Billing
vi. Use in automated updating of medical history
33. What is ergonomics?
Ans: Ergonomics covers the physical environment and design of equipment to maximize the quality of
an employer’s well-being. This covers everything from the design of the computer, the computer desk,
the chair and even the design of the lighting within a room.
34. What does ‘Data Protection and Privacy Issues’ mean?
Ans: Data Protection and Privacy Issues relate to holding and dealing with personal information about
people within computer. There are legal and moral duties to store, to preserve privacy about
personal data about individuals.
35. What do you know about password policies?
Ans: Points to remember about password policies:
i. Choose a password which cannot be easily guessed by other people
ii. A password should be at least 8 characters long & contain a mixture of words and numbers
iii. Change your password regularly
iv. Never share password with others
36. What is virus?
Ans: Viruses is one kind of small self active Programs. That can install automatically into computer
system.
37. How does virus work?
Viruses are small Programs which hide themselves on a disk. When the disk is accessed, the virus
program will start and infect computer. The worst thing about computer virus is that it can spread form
one computer to another, either via the use of infected disk, or even a computer network.
38. How can you protect against computer virus infection?
I. The ways to protecting computer against computer virus:
II. Making computer stand-alone - not connecting to LAN or Internet
III. Making computer password protected and the password is long enough
IV. Using antivirus software
V. Making sure that antivirus is always updated
VI. Making sure that all 'security patches' from Microsoft are applied.
39. What does ‘Updating anti-virus programs’ mean?
Ans: As new computers viruses are emerging constantly, the antivirus scanning program and its virus
recognition list are updated regularly. Updating anti-virus means making antivirus program and its virus
definition files are changed to latest version so that it can detect new viruses.
40.What do you understand by copyright law?
Ans: A copyright is a form of intellectual property law that provides protection for original works
of authorship. Copyright law prevents the unauthorized copying of any data or program without the
prior permission from the producer.
41. What are the definitions for freeware and shareware?
Ans: Freeware: Freeware is a software which is made freely available and free to use. The user doesn’t
have to pay the producer for the use.
Shareware: Shareware is a software which is freely available for a trail (limited) period. After this
period, the user must legally remove it, or pay the producer an amount for the further use of the
software.
42. What is Open Source Software?
Ans: The Open-source software is computer program with its source code made available to anyone
and give right to the copyright holder provides to study, change, develop and distribute the software
to anyone and for any purpose.
43. What do you understand by site license?
Ans: A site license is a software license that allows the client to make a fixed numbers of copies available
for their staff, normally via the company’s network. Many large companies who need a large
number of copies of certain software/application buy site license.
44. What is an end user license agreement?
Ans: An end-user license agreement or software license agreement is the contract between the licensor
and purchaser, establishing the purchaser's right to use the software. Every proprietary software
branch has an end-user license agreement which the user have to agree in order to install and use the
software. The license may define ways under which the copy can be used, in addition to the rights of the
buyer.
45. What are application (executable) files?
Ans: An executable file is a file that contains a program that is capable of being executed or
run as a program in the computer. An executable file can be run by a command or double click.
46. What is storage media? Write the names of a few commonly used storage media.
Ans: Storage media are devices that store application and user data permanently for later
retrieval.
There are a range of storage media including:
i.Internal hard disks
ii.External hard disks
iii.CDs/DVDs
iv.USB flash drive
v.Memory card
vi.Network drives
47. How can you examine ‘the end user license agreement’ within Office 2007?
Ans: Click Office Button→ Click Word Options → Click Resources → Click About Button → Click ‘View
the Microsoft Software License Terms.
This will display the end user license terms in a dialogue box.
48. What is firewall?
Ans: A firewall can help prevent hackers or malicious software (such as worms) from gaining access to
your computer through a network or the Internet. A firewall can also help stop your computer from
sending malicious software to other computers.
Or, A firewall is a software program or piece of hardware that helps screen out hackers, viruses, and
worms that try to reach your computer over the Internet.
Module -02 Using the Computer & Managing Files
Path Desktop:
My computer → system drive <C:> → users folder → log on current user <R25> →
desktop.
Windows
1. How can you view your computer’s details?
Or, How can we display the system properties of the computer?
Ans: Start Button → Control panel from Start menu → System and Security → System
2. How can you view/ Display Getting Start Window?
Ans: Start Button → All programs from Start menu → Accessories → GeJng Start.
3. How can you run a program using start menu?
Ans: Start Button → All programs from Start menu → Accessories →Select Required Program.
4. How can you run Notepad/ Wordpad using start menu?
Ans: Start Button → All programs from Start menu → Accessories →Select Notepad/ Wordpad.
5. How can you open a fill within a program?
Ans: Click Fill/ Office Button → Open → Type fill name into Fill name Box→ Click Open.
6. How can you close a not responding fill/ application?
Ans: Press Ctrl+ Alt + Del → Start Task Manager → select not responding fill/ applicaMon → → Click
End Task.
7. How can you customize your Desktop?
Ans: Right Click on empty part of desktop → Personalize.
8. How can you customize your Desktop Background wallpaper Picter?
Ans: Right Click on empty part of desktop → Personalize → Desktop Background → Select a picter →
Click save Changes → then close PersonalizaMon window.
9. How can you customize your Desktop Background Colour?
Ans: Right Click on empty part of desktop → Personalize → Desktop Background → Click solid Colour →
Click save Changes → then close PersonalizaMon window.
10. How can you customize Window Aero themes?
Ans: Right Click on empty part of desktop → Personalize → Select one from Aero themes → Click save
Changes → then close PersonalizaMon window.
11. How can you set a Screen saver ?
Ans: Right Click on empty part of desktop → Personalize → Select Screen Saver → Click Down arrow→
Select Ribbons → Put Mme into Wait Box → Ok → then close PersonalizaMon window.
12. How can you set your Screen resolution?
Ans: Right Click on empty part of desktop → Click Screen resoluMon → Adjust resoluMon from
resolution Box → Click ok.
13. How can you modify date and time of your computer?
Ans: Click Start Button → Click Control panel from Start menu → Click Clock, Language and Region →
Click Set Date and Time from Date and Time section → Click Change date and Mme → modify date and
time → Click Ok.
14. How can you set the computer sound volume?
Ans: Click Start Button → Click Control panel from Start menu → Click Hardware And Sound → Then
adjust sound system.
15. How can you uninstall a Program?
Ans: Click Start Button → Click Control panel from Start menu → Click Uninstall a Program → Then
Double Click on the selected Program→ Click Finish.
16. How can you see the printer that is available in your computer?
Ans: Click Start Button → Click Control panel from Start menu → Click Hardware and Sound → Click
Devices and Printers.
17. How can you install a printer in your computer?
Ans: Click Start Button → Click Control panel from Start menu → Click Hardware and Sound → Click add
a Printer → Click add a local Printer → Click Next → Select Printer Model → Click Next→ Click Next→
Finish.
18. How can you change the default printer of your computer?
Ans: Click Start Button → Click Control panel from Start menu → Click Hardware and Sound → Click
Devices and Printers. → right Click on the desired/required Printer → Click set as default Printer.
19. How can you remove a printer from your computer?
Ans: Click Start Button → Click Control panel from Start menu → Click Hardware and Sound → Click
Devices and Printers. → right Click on the Printer icon → Click Remove printer.
20. What is file compression? What are the benefits of file compression?
Ans: File compression means making file smaller.
i. Make the file size smaller.
ii. Saves disk space.
iii. Transfers data faster.
iv. Number of files or a folder can be attached to a email as a single file and in reduced size.
21. Discuss about various types of drives.
Hard drives: We save data to hard drives. Operating system, software are also installed on hard drives.
Hard disk drives on Windows are labelled with C, D and so on.
CD/DVD drive: CD/DVD are used to read Compact Disk or DVD disk and we use these to
installsoftware, games, movies etc. and labelled with available letter after hard drives.
Removable drive: These are plugged into USB port and used to carry data. Removable dirves are
labelled with available letter
Network drives: If the computer is connected to network, it can use space located within a
different computer on the network.
22. How can you use Searching option to search files on your hard disk?
Ans:The searching allows to customize searching in following ways:
Searching by date: Search files created/modified on, before or after a certain date
Searching by file content: Search file containing certain phrase or word
Searching by partial name and location: In a location file name contains certain word
Searching by wildcard: Part of file name or file name has some pattern
23. What is desktop? What is taskbar?
Desktop: The desktop is the primary user interface of a computer Operating System. It is the
background image of a display screen, on which windows, icons of files, folders and other graphical
items appear in the graphical user interfaces. Icons on a computer desktop can be arranged like the real
objects on a real desktop.
Taskbar: The taskbar is a movable, concealable icon bar that is set on the very edge of the graphical user
interface (GUI) desktop and serves as a launching pad for applications as well as a holder for icons
indicating running programs.
24. What are folders in Microsoft Windows?
Ans: In graphical user interfaces such as Windows OS environment, a folder is an object that can
contain multiple documents. Folders are used to organize data.
Or, Files are Stored on a disk in Folder. A Folder is a container on a disk where files can be stored.
25. What are computer files?
Ans: A computer file is a resource for storing information, which is available to a computer program and
is usually based on some kind of durable storage. A file contains data saved permanently on disks and
which can be opened or run later as we wish once it is saved.
26. What are file details? How can you view file details?
Ans: Information about a file like name, type, last modified date, size etc is collectively known
as file details.
To vies file details: Right Click on file icon → select ProperMes.
This will show the file details.
27. What does ‘Drag and drop’ mean?
Ans:The concept of selecting an item , and then moving it while keeping the mouse button pressed is
often called ‘dragging’ or ‘Drag and drop’. We easily move an item to a new location by using Drag
and Drop technique.
28. What is the Recycle bin? What are the uses of Recycle Bin?
The Recycle bin is a Desktop Icon which contains files which have been deleted recently. Uses of recycle
bin:
• Restore files and folders from the recycle bin.
• Empty recycle bin to delete data (You will be lost all data forever).
29. What is operating system?
An operating system (OS) is a collection of software that manages computer hardware resources
and provides common services for computer programs. Application programs usually require an
operating system to function.
30.What is Virus, Spyware and Cookies?
Virus: Viruses are small programs written so that they can jump from one computer to another via disk
or network, which can cause disruption or damage to the computer system.
Spyware: Spyware is a software that installs itself on computer and then spies on the computer
activity of the user.
Cookies: Cookies are hidden information about the user saved in the hard disc in the text file
format. Cookies personalize the relationship of the user with the visited website.
31. Write down the process to shut down a computer.
Ans: Click on Start Button → Click on the Right poinMng arrow → Click on Shutdown
This will shutdown the computer.
Module- 03 Word Processing
1. What is mail merge? Why do you need to mail merge?The mail merge is used to insert variable data intoa fixed format by combining two files into one file.
2. Write the steps to create and save a new document in MS word 2007.
Click on the Office Button →Press the New command from the popup menu→.This will display a New
Document page.
To save the MS Word file, click on the Office Button → select Save command. → The document will be
saved.
3. Briefly describe any five formats of MS word document.
Five formats of MS Word document are as follows:
i. Word Document-Standard Microsoft Word 2007 format. -File name extension is .docx
ii. Word 97-2003 Document- File name extension is .doc
iii. Plain Text-File name extension is .txt
iv. Rich Text Format-Generic word-processing file format. File name extension is .RTF
v. Word Template-Saves the document as a template. File name extension is .dotx
4. What is mail merge?
The mail merge is used to insert variable data intoa fixed format by combining two
files into one file.
5. How can you insert a picture from clipart in a document?
Click on Insert tab →in the IllustraMons group, click Clip Art→ In the Clip Art task
pane, in the Search for text box, type a word or phrase that describes the clip art that we
want →In the list of results, click the clip art to insert it.
What will be the keyboard command for cut and copy command?
Cut= Ctrl+X and Copy= Ctrl+C and Paste = Ctrl+V
6. What is toolbar? What contains in toolbar?
A toolbar is a vertical or horizontal row of clickable icons that perform specific operating system or
application functions.
7. How you insert special characters in your word document?
Click where we want to insert the special character →Click on the Insert tab, in the Symbols group, click
Symbol →then click More Symbols →Click the Special Characters tab→ Click the character that we want
to insert→ then click Insert→ Click Close.
8. What is the windows clipboard?
The windows clipboard is an area of memory used moving and copying items from one place to another.
9. How to copy text within a document
Select → press Ctrl+C →click at the end of the document →press the Enter key to insert a space →press
Ctrl+V.
10. How to create a Header and Footer?
Click on the Insert tab → in the Header & Footer group, click Header or Footer Click the header or footer
design that we want. The header or footer is inserted on every page of the document.
11. What is text formatting?
Text formatting relates to formatting characters and words within a document and covers the font type,
font size, font Colour and font attributes such as bold, italic or underlining.
12. Write down the steps of inserting special symbol.
Click where we want to insert the special symbol →Click on the Insert tab, in the Symbols group, click
Symbol →then click More Symbols →Click the symbol that we want to Insert →then click Insert →Click
Close.
13. What is the percentage range of Zoom?
10% to 500%.
14. How can you enable over typing mode?
Click the Microsoft Office Button →then click Word OpMons →Click Advanced →Under EdiMng opMons,
check the Use overtype mode check box.
15. How will you switch between open documents?
Click on the view tab →In the window group, click on the Switch windows icon →then from a drop down
list select a document to open.
16. What is Ribbon?
Ribbon is an interface where a set of toolbars are placed on tabs in a tab bar.
17. What are the steps of mail merge wizard?
Click on Mailings tab →in the Start Mail Merge group click on Start Mail Merge icon →then click Step by
step Mail Merge Wizard.
18. How to insert a smart art?
Click on Insert tab →in the IllustraMons group, click smart art icon choose a smart art graphic →ok.
19. What is hyphenation?
Hyphenation allows words to break lines between the syllables of words.
20. How can you insert a chart?
Click on Insert tab →in the IllustraMons group, click chart icon →choose a Chart →ok.
21. What are the keyboard shortcuts for the following tasks?
To make selected text bigger=Ctrl+]
To make selected text smaller=Ctr+[
To make selected text bold=Ctrl+B
To make selected text italic=Ctrl+I
To move selected text underline=Ctrl+U
To move to the next cell of the table=Tab
To move to the previous cell of the Table= Shift+tab.
To do spell checking=F7
select the entire document=Ctrl+A
22. What are the tabs/tab stops used in word and used for what purpose?
The tabs/tab stops used in Word 2007 are as follows-
1. Left Tab stop: into this tab stop location.
2. Centre Tab stop: This tab stop as you type in text.
3. Right Tab stop : This tab stop it will move to the left.
4. Decimal Tab stop: This is used to align numbers around a decimal point.
5. Bar Tab stop: This displays a vertical bar at the tab stop location.
6. Indent First Line: Indent the first line of that paragraph there.
7. Hanging Indent: indent all the lines after the first line of the paragraph.
23. Write the steps to add picture bullet into a word document.
Home tab → click on the down arrow next to Bullets icon.
24. what is subscript and superscript?
Subscript is create small letters below the text base line. Superscript is create small letters above the
line of text.
25. what is strike through?
draw a line through the middle of the selected text.
26. what is shrink font and grow font?
shrink font is decrease the font size and grow font is increase the font size.
27. what is find and replace?
find and replace are that which we can find and replace text in the existing document
28. what is shading?
shading is that we can color the background behind the selected text or paragraph.
29. what is wrap text?
wrap text means we are able to make all content visible within a cell by displaying it on multiple lines.
30. what is text box?
insert a text box that can be positioned anywhere on the page.
31. what is drop cap?
drop cap is the tool. which is create a large capital letter at the beginning of a paragraph.
32. what is watermark?
watermark is the tool. which allows us insert ghosted text behind the content on the page.
33. what is lines spacing?
line spacing is that which change the line spacing between lines of text.
34. what is text alignment?
text alignment means where the text will stay. there are four types of alignment.
i. Left alignment ii. right alignment iii. centre alignment iv. justify alignment
35. what is tab?
In office 2007 menu items of menu bar are called tab. such as 1) home tab 2)insert tab 3)page layout
tab etc.
36. what is group?
group is a collection of similar (related) tool in the ribbon. such as 1)clipboard 2)font 3)editing etc.
37. format painter?
copy formatting from one place and apply it to another.
Double click the button to apply the same formatting to multiple places in the documents.
38. write the printing steps in m/s word?
First click office button – click print from the office button – from printing dialog box -- select printer
name – select page range – select number of copies – select page per sheet – click ok
39. How can we insert the column?
In excel sheet select the column and press right button and from the pop up menu press insert. The
column will be created automatically.
40. How can you copy a column into a row?
Select the existing document from the column – click right button on the selected document – copy –
select the row – click right button on the selected row -- past special -- click transpose – click ok .
41. write the steps to create and save a new document in MS word 2007?
open MS word – click office button – save – file name on the file name box – save as type on the save as
type box – save
42. write the steps to add picture bullet into a word document ?
home – bullets – define new bullet – symbol / picture bullet – ok
43. write the steps to add border and shading into a word document?
select the existing text – home – border and shading of the group of paragraph – border and shading –
select border style and shading color – ok
44. write the steps to change the document orientation and paper size?
page layout – page orientation – click the portrait/landscape
page layout – page size – click the page size
Module- 04 Spreadsheets
1. What is a workbook?
Ans: An excel workbook is a collection of worksheets and charts. By default, each workbook contains
three worksheets.
2. What is a worksheet?
Ans: A worksheet is a large table which consists of rows and columns. Each worksheet contains 1048576
rows and 16384 columns.
3. What is sorting? How can you sort a cell range in MS Excel?
Ans: Sorting means arranging items in order from smallest to largest (ascending) or from largest
to smallest (descending).
To Sort: Select range →Data tab →iii. In the Sort & Filter Group →Click Sort A to Z or Z to A icon.
4. What are the two orders in which you can sort your data? If you want to sort a name
column in an alphabetical order then which sort order should you choose?
Ans: The two orders for sorting data are smallest to largest (ascending) or from largest to
smallest(descending).
To sort a name column in alphabetical orderi.
Select range →Data tab →iii. In the Sort & Filter Group →Click Sort A to Z or Z to A icon.
5. What is a Function in MS Excel? What function is used for counting the number of cells in a
range?
Ans: A function allows us to calculate a result such as adding numbers together, or finding the average
of a range of numbers.
To count cells functions available:
COUNT: counts cells containing numbers.
COUNTA: counts the cells that are not empty.
COUNTBLANK: counts empty cells.
6. How can you select a range of cells not next to each other?
Ans: Select first cell → Press Ctrl key → Select next cell and so on.
7. How can you rename a worksheet?
Ans: Double-click on sheet name → Write new name → Press Enter
8. What is Numbers & Date formatting? How can you apply that in your MS Excel Worksheet?
Ans: Number formatting sets how to show number enter in a cell. Date formatting sets how to show
date value entered in a cell.
To Set Number format: Right click on cell → Click Format Cells → Select Number → select a Style
→Press OK.
To Set Date Format: Right click on cell → Click Format Cells→ Select Date → Select a format → Press
OK.
9. What is the default text and number alignment in MS Excel?
Ans: By default:
Text is aligned to left within a cell
Numbers are aligned to right within a cell
10. What is Chart in MS Excel? Name three types of charts?
Ans: Charts are visual representations of worksheet data which makes it easier to understand the data
in a worksheet because users can easily pick out patterns and trends difficult to see. Three type
of
chart:
i. Column chart
ii. Line Chart
iii. Pie Chart
11. What is AutoFill in MS Excel 2007? What is the extension of an excel file.
Ans: Auto fill is a feature of Excel to identify and fill a series of text or numbers, automatically, in a given
range. The extension of an Excel file is .xlsx.
12. What is a function in MS Excel? How can you display the maximum value within the range
C4:C9?
A function allows us to calculate a result such as adding numbers together, or finding the average of a
range of numbers.
To display Maximum value: Select cell where to display > Click Formulas tab > Click down arrow at right
of AutoSum > Click Max > Adjust Cell Range to C4:C9 > Press Enter.
13. How can you move the contents of a cell or a range of cell between worksheets (in
different workbooks)
i. Open both workbooks;
ii. Go to the workbook from where to move;
iii. Select the cell or range → Press Ctrl + X;
iv. Go To View Switch Tab > Click Switch Windows > Click the destination workbook name
v. Click on cell > Press Ctrl + V
14. Why do you use the absolute cell referencing?
If we use absolute cell reference in a formula, Excel will not adjust the cell reference while copying the
formula.
15. How many rows and columns are there in a single worksheet?
There are 10,48576 Rows and 16384 Columns in MS Excel 2007.
How can you make Column items into row?
To make the column items into rowi. Select the range of columns;
ii. Place the cursor to the cell of the target row;
iii. Click on the down arrow down to the Paste icon in the Home tab;
iv. Select Paste Special; Paste Special dialogue box appears;
v. Check the Transpose box;
vi. Click OK, this will paste the column items into the row.
16. How should you copy a column heading of a list from one sheet and paste it as a row
heading in another sheet?
i. Select the Heading list and Press Ctrl+C
ii. Place the cursor to the target cell of other sheet;
iii. Click on the down arrow down to the Paste icon in the Home tab;
iv. Select Paste Special; Paste Special dialogue box appears;
v. Check the Transpose box;
vi. Click OK, this will copy the column heading of a list from one sheet and paste it as a row
heading in another sheet.
17. Suppose cell A1 contains “JAN” and you want to print the rest of the series in the column
then how should you do it?
To print the rest of the series in the columni. Move the Mouse pointer to the bottom-right corner of the
cell A1; the mouse pointer shape
will change to the shape of a small black cross.
ii. Keeping the mouse button pressed, drag to the cell A12,
iii. Now, release the mouse button; This makes Excel auto fill the series with the rest of the
months, namely January to December.
18. How to change time format of an excel sheet?
i. Select the cell, range, row or column of date;
ii. Right click on the selected item;
iii. From the pop-up menu, select Format Cell command;
iv. Click on Date section; Select the desired date format;
v. Click OK, This will change the date format of a excel sheet.
19. How can you copy a content in excel worksheet?
i. Select the cell, range, row or column;
ii. Press Ctrl+C to copy the selected item to the clipboard;
iii. Click at the location where to paste;
iv. Press Ctrl+V; This will copy and paste the content of an excel sheet.
20. Write about #REF!, ####, #NAME?, #DIV/0!
#REF! indicates that the cell reference is invalid, often seen when the cell is deleted after applying
the formula.
#### indicates that the contents of the cell can not be displayed correctly as the column is too
narrow.
#NAME? indicates that Excel doesn’t recognize the text contained within formula.
#DIV/0! indicates that a number is tried to be divided by zero.
21. How can you change date format from 9-Jan-12 to 09-01-12? in MS Excel?
To change the date formati. Right click on the cell>Select Format Cell; Format Cell dialogue box appears;
ii. Click on Date section; Select the Date format as 09-01-12;
iii. Click OK, this will change the date format from 9-Jan-12 to 09-01-12.
22. How can you copy formula in Excel?
To copy formula in Exceli. Click the cell containing the formula we want to copy.
ii. Click and drag the cell’s fill handle across or down the number of cells to which we want to
copy the formula.
This makes Excel copy the formula into each cell we drag over.
23. What are operators in Excel?
Operators specify the type of calculation that we want to perform on the element of a formula.
Operators are- + (Plus)
- (Minus)
/ (Divide)
(Multiply)
% (Percentage)
24. What are ‘IF Functions’ in Excel?
Ans: The IF function checks to see if the specified condition is true or false. If the condition is true,
it returns the specified result, if not returns the other.
25. How can you print titles on every page when printing in MS Excel?
To print titles on every page when printingi. Click on the Page Layout tab;
ii. Click on Print Titles in within the Page Setup group; Page Setup dialogue box appears;
iii. Click Rows to repeat at top box; click the top row;
iv. Click OK; this command closes the dialogue box.
Now the Titles will be printed at the top of every printed page.
26. How can you print Excel row and column headings?
To print the Excel row and column headingsi. Click on the Page Layout tab;
ii. Within the Sheet Options group, click on the Print check box under the Headings;
This will print the Excel row and column headings.
27. write the steps to add a pie chart in the excel document ?
select the document on excel sheet – insert – pie chart – click the pie
28. write the step at add header and tooter in the excel document ?
open excel sheet – insert – header and footer
29. How can you copy a column into a row?
select the existing document from the column – click right button on the selected
document – copy – select the row – click right buton on the selected row -- past
special -- click transpose – click ok .
30. How can we insert the column?
In excel sheet select the column and press right buton and from the pop up manu
press insert . the column will be created automatically.
31. How can you filter in m/s excel?
In m/s excel it is easier to analyze the arranging data. you can sort the selected
data in ascending or descending order or you can temporarily filter out spicific
values.
32. what is funtion?
a funtion allows you to calculate a result such as adding numbers, or finding the
average of a range of number.
33. write use iF funtion?
Return one value if a condition you specify evaluates to TRUE and another value if
evalutes to FALSE. use if to conduct conditional tests on values and formulas.
34. Auto correct option?
open excel sheet → click office buton → click excel options→ click proofing
option →click auto currect options button.
35. Excel formulas?
we need to create a formula that will calculate the value of the stock for that
particular component.
36. Auto fill?
auto fill means to copy increment data entry.
37. what is freeze panes?
freeze panes is that which is able to keep a portion of the sheet visible while the
rest of the sheet scrolls
38. what is text box?
insert a text box that can be positioned anywhere on the page.
39. what is bar chart?
bar chart are the best chart type for comparig multiple values.
40. what is pie chart?
pie chart display the contribution of each value to a total. use it when values can
be added together .
41. what is line chart?
line chart are used to display trends over time.
42. What is a sorting? How can you sort a cell range in Ms excel?
Ans: Sorting arrange the data within a table into Alphabetical or numerical order. Ex: book, address are
sorted alphabetically from A-Z and calendar are sorted by data order.
43. 14.How can you select a range of cells not next to each other ?
An : Sometimes we need to select multiple cells that are not next to each other. To do this click on the
first cell, i.e.C3 then while keeping the ctrl key pressed click on the cell G3.
44. 15.How can you rename a worksheet ?
Ans : We can rename a worksheet at bottom left corner of excel window and write down new name than
press enter.
45. 16. What is Numbers & Date formatting? How can you apply that in your MS Excel
Worksheet?
Ans: Number formatting store number values with decimal places.
46. Date format holds date in a cell.The format can be user specific. We can apply number and date
formatting by selecting a cell and then from the keyboard press Ctrl+1. From the format cell
window we can select our desired cell format.
47. What is the default text and number alignment in MS Excel?
Ans: Default text alignment is left and default number alignment is right.
48. How can you move the contents of a cell or a range of cell between worksheets (in different
workbooks)?
Ans: Select the cells/range of cells and cut ( ctrl + X) it to place it to the clipboard.
Select the destination worksheet and Click at the location we wish to paste the data and press Ctrl+ V.
49. . How can you select a range of cells located next to each other?
Ans: Select the first cell-> shift + Click to the last cell to select the range of cell.
50. What is wrap text ? How to do it ?
Ans : When text exceeds a column width, it is possible to manually or automatically wrap the text.
Procedure :
1. In a worksheet, select the cells that we want to format.
2. On the Home tab, in the Alignment group, click Wrap Text.
51. What is paste special ? How to use paste special ?
Ans : This allows us several choices of how the text will be formatted when pasted. In the same way, we
can use this command in Excel or Calculation to copy formulas and calculations when pasting data into
cells.
Procedure :
• Click the Home tab;
• Get into the Clipboard group;
• Click the drop down symbol under Paste button;
• Then you will get the Paste Special.
Module 05 Database
1. What is database? What are the major advantages of databases?Ans: Database: A database is a structured collection of related data about one or more subjects.
Or, The word, database is a computer term for a collection of information concerning a certain topic or
business application.
Advantages:
i. Reduced data redundancy;
ii. Reduced updating errors and increased consistency;
iii. Greater data integrity;
iv. Improved data access to users through the use of host and query language;
v. Improved data security;
vi. Reduced data entry, storage and retrieval costs.
2. Where are the uses of database?
Ans: Databases are used to group and format data and then extract information from that data.
Examples of databases usages include:
i. A phone directory
ii. Criminal databases used by the police to keep track of known criminals
iii. Patient records in health management system
iv. Tax details in government database
3. Write the common uses of large-scale database.
Ans: i. Airline booking systems.
ii. Government records
iii. Band account records
iv. Hospital patient details
4. Write the different types of access database object.
Ans: Data, Record, Field, Table, Forms, Query, Reports, Macros, Modules.
5. What is the difference between data and information?
Ans: Data: Data is made up of text, numbers and images and in some cases sounds which a computer
can store.
Information: Information is interpreted data that give us a meaningful message.
6. What is a field or a record?
Field: Fields are the individual items/ data, which make up a record within database.
Record: A record is a collection of information, which relates to a particular item within the database
table.
7. What is table? Why do we create table in Database?
Ans: A Table is a combination of certain rows (records) and columns(fields).
We create tables to
i. Store data in a structured and organized format;
ii. Organize information about a single topic into rows and columns;
iii. Retrieve information easily in the form of Query and Report.
8. What are forms? And write the types of forms view?
Ans: Forms are data entry screen to input data in a table.
Or, Forms provide a quick and easy way to modify and insert records into database.
Types of forms view: Form view, Layout view and Design view.
9.How can you create a MS Access Form?
Ans: Select table or query from navigation pane → Go to Create tab → Click Form bu]on (Forms
sections)
10. What are queries? And how can you add criteria to an MS Access query?
Ans: Queries are used to remove and analyze data within one or more tables.
Add criteria to an MS Access query:
Ans: Click Create tab → Click Query Design (Other group) → Click Add for Adding Table → Select
required field →Write criteria expression→ Click Run.
11. Write the different types of Query.
i. A select query.
ii. An update query.
iii. A delete query.
iv. An append query.
v. A make table query.
12. What are reports?
Ans: A report is a summary generated from information in a table or query.
13. What is Macro? Why use macros?
Ans: A Macro is a symbol, name or key that represents a list of commands, actions or keystrokes.
Eliminate wasted time and the risk of error that occur when performing repetitive tasks.
14. Why we use access?
Ans: Access provides a powerful way of storing, sorting, manipulating data and retrieving data.
15. What is the use of Design View in MS Access?
Ans: In MS Access, the Design View of an object is used to configure its properties. The efficiency of the
database and the way it handles data input /output are controlled by the properties configured in
Design View.
16. What are the available Data types in MS Access 2007?
Ans: There are 11 data types available in MS Access 2007:
i. Text ii. Memo
iii. Number iv. Date/Time
v. Currency vi. AutoNumber
vii. Yes/No viii. OLE Object
ix. Hyperlink x. Attachment
xi. Lookup Wizard
17. What is a relational database? What is a primary key?
Ans: Relational Database: A relational database stores data in multiple tables. In this way, it reduces
duplication of data, improves performance and removes anomalies.
Primary Key: A primary key is a unique identifier for each row in a database table. Primary key is
essential when working with relational database.
18. Write the most common relationship between tables and Describe them.
Ans: One to Many; One to One; Many to Many.
One-to-many relationship : The relationship where one entity can relate to one or more entities of
other type is called one-to many relationship. For \example a Customer can place many Orders. So
it is a “one-to-many” relationship exists between Customer and Order.
One-to-One relationship: The term One-to-One relationship refers to relationships of two items in
which only one can belong to another.
Many to Many: The relationship where one more entities can relate to one more entities of other type
is called many to many relationship.
19. Write the steps of deleting relationships.
Ans: Click on Database tools → Select RelaMonships →Right Click on desired Relationship line → Press
the delete key → Click yes bu]on to confirm deleMon.
20. What are queries in MS-Access? Name two types of queries?
Ans: Query is an object in MS Access that analyze and extract data from one or more tables in an orderly
fashion. Queries are used as the way of retrieving information from database, it retrieve data from
underlying table when we run it.
Two types queries: Select Query, Delete Query.
21. What are the fields attributes?
Ans: Format, Decimal Places, Input Mask, Caption, Default Value, Validation Rule,
Validation Text, Required, Indexed, Smart Tags, Text Align.
22. What is Input mask?
Ans: An input mask is a set of literal characters and mask characters that control what users can and
cannot enter in a field. For example, an input mask can require users to enter dates or telephone
numbers that follow the conventions for a specific country/region.
23. What is a Validation rule? Write about validation text.
Ans: Validation Rule: A validation Rule is the limit or control of the type and amount of data that the
users can enter in a table field.
Validation Text: Validation Text is the prompt message displayed to the user when the entered data
fails to meet the conditions specified within the Field Properties of Validation Rules.
24. What is an index?
Ans: An index allows Microsoft Access to work faster when finding and sorting records.
25. What is the advantage of using index in your database?
Ans: Indexes help to locate and sort information quickly. An index stores the location of records based
on the field or fields that we choose to index. Using that index database can then quickly find the
location of the data.
26. What are uses of Reports in MS Access?
Ans: A report is a summary of data generated from a table or query. A report presents data in an
organized, meaningful and print-ready format.
27. What are Wildcards?
Ans: Wildcards are special characters that we can use within a query to specify or exclude certain
characters.
28. What is an XML file?
Ans: XML is short for ‘Extensible Mark-up Language’. It is a general-purpose mark-up language that
allows to share data created by different hardware and software via the Internet.
29. What does exporting data mean?
Ans: Exporting data means saving the data in a different format.
30. What does importing data mean?
Ans: Importing data means saving the data in Microsoft Access format from a different format.
31. Define filter?
Ans: Filter is basically simple queries but they only apply to open table.
Or, Filters are best used for temporarily viewing of the data in a table.
Module -06 Presentation
1. What is Slide Sorter view in MS PowerPoint?Ans: Slide sorter view in PowerPoint is a window that displays thumbnails (Small) versions of all our
slides, arranged in horizontal rows/grids. It allows to easily rearrange the order of slides within a
presentation.
2. What is the Slide Show view in MS PowerPoint?
Ans: Slide Show view is the view used for presenting to an audience.
The slide show view fills the whole screen and we can advance to the next slide by clicking the mouse
button. It is the view that is used for presentation.
3. What is a Slide Master?
Ans: A Slide master contains the underlying content and formatting information used by a slide
in a presentation. we can easily editing slide by the slide master.
4. What is an organization chart?
Ans: An organization chart is used to show a structure such as the management levels within a company
or an organization.
5. What is Slide Transition? How can you apply the same slide transition to all the slides at a time?
Definition: A slide transition is the visual motion when one slide changes to the next during a
presentation.
OR, Slide Transitions means moving from slide to slide in a PowerPoint presentation.
Step: Animation Tab → Click on down arrow in TransiMons Style → Click desired transiMon→ Click on
“Apply to All”.
6. Write the steps to change background colour on all the slides within a presentation.
Ans: Go to Design tab → Background style → Format Background → Select Fill → Select a color →
Click Apply /Close button.
7. How can you apply automatic slide numbering in your Presentation?
Ans: → Insert Tab→ Click on Header & Footer bu]on → Click Slide Number→ Press Apply to All.
8. How can you insert dates into the footer in a Power point presentation?
Ans:Go to Insert tab → Click Header & Footer bu]on→ Click Date & Time check box → Click Apply or
Apply All.
9. Write the steps for inserting slides with a particular slide layout.
Ans: Home Tab→ Click New Slide bu]on (slides group)→ Select desired layout.
10. How can you insert a picture (clipart) into a master slide?
Ans: Go to View Tab→ Click Slide Master (presentaMon views Group) → go to Insert Tab→ Click Clipart (
Illustrations group)→ Type relevant word in Search For box → Click Go → Select desired clipart.
11. How can you add Slide show animation effects to text?
Ans: Select text e →Click Animate secMon (within the AnimaMon tab) → select any of the available
animation options
12. How can you apply a theme to a presentation?
Ans: Click Design tab →select one type of Form from Themes secMon→ Click Applied to All .
13. How can you move slides between presentations?
Ans: Open the presentation that we want to copy slide from →
Click View → Click Slide Sorter icon → Select required Slide and press: Ctrl+X → Switch to other
presentation and go to slide sorter view→Now press: Ctrl+V
14. How can you insert a shape into a master slide?
Ans: Go to View Tab→ Click Slide Master (presentaMon views group) → then go to Insert Tab → Click
Shapes (Illustrations group) → Select desired shape(mouse pointer changes to a small cross) → Now,
drag and draw the shape.
15. How can you remove graphics from a master slide?
Ans: Go to View Tab→ Click Slide Master (presentaMon views group) → Select (graphics) → Press Del
key.
16. How can you change the background color in a Chart?
Ans: Click Chart → Right Click on empty part of Chart → Click Format Plot Area → Select Fill → Select
Solid Fill→ select Colour from Colour secMon → Click Close Bu]on.
17. What are the good practice when creating slide content?
Ans: Good Practice when creating slide content:
i. Keep paragraph as short as possible.
ii. Use short concise phrase.
iii. Use bullet or numbered list. This makes it much more easier to read.
18. How can you apply a shadow to an Illustration in Power point?
Ans: Select picture→ Right click on picture → select Format Picture →Click
Shadow → Select one of presets shadow→ Click Close
19. How can you hide a slide? How can you display a hidden slide?
Ans: View Tab → Click Slide Sorter view (PresentaMon Group) → Right Click on the desired slide→
Select Hide Slide from popup menu.
Display hidden slide:
i. Display the first slide and run the slide show (Press F5) .
ii. Right click over the slide that is displayed in slide show layout> a pop up menu appears.
iii. From the pop up menu, select the Go to Slide command and click on the hidden slide.
This will show the hidden slide.
20. What is the use of Outline View in PowerPoint?
Ans: In Outline view, PowerPoint displays your presentation as an outline made up of the titles and main
text from each slide. Working in Outline view is particularly handy if we want to make global edits, get
an overview of the presentation, change the sequence of bullets or slides, or apply formatting changes.
Module -07, Web Browsing & Communication
01. What is Internet, Intranet & Extranet?Internet: The Internet is a global network of interconnected networks. The Internet relates to all the
hardware and software involved, as well as the WWW. It also includes FTP, Email and Newsgroups.
Intranet: An intranet is a smaller, closed version of Internet, which can only be accessed by
authorized members of an organization.
Extranet: An extranet is an Intranet which is partially accessible to authorized outsiders. Extranet allows
outsiders to gain limited access to information held on a company network
02. What is World Wide Web (WWW)?
Ans: The World Wide Web (WWW) is just a small part of the Internet as a whole. Basically it is the text
and pictures that we can view using our Web Browser
03. What is Web site and URL (Uniform Resource Locator)
Ans: Web site: A Web site is simply a group of files and folders which are stored on a WWW server and
which can be freely accessed by people 'surfing the Web'.
URL: The URL (Uniform Resource Locator) is just another name for a Web address.
e.g. a URL of http://www.Google.com
04. What do you know about “Web Browsers”? What is the default browser?
Ans: Web Browser: The “Web Browser” allow you to view Web page. Web Browsing application include
Internet Explorer, Opera and Firefox.
i. Google Chrome ii. Mozila Firefox iii. Apple’s Safari
iv. Opera v. Internet Explorer
Default Browser: Default Browser means the browser that comes pre-installed with the OS and is used
to browse/open the sites when clicked any bookmark. Internet Explorer is the default browser in
Windows Operating System.
05. What is search engine?
Ans: A search engines holds information about pages on websites throughout the internet. It has only
information about websites which have been to it, or ones that it has found out about automatically. Ex:
Google, Bing, Yahoo etc.
06. What are hyperlinks?
Ans: A hyperlink is a piece of reference text or picture on a web page, which when clicked on will
automatically
i. take to a different part of the same page;
ii. take to a different page within the website;
iii. take to a page in a different website.
07. What is ISP and RSS feeds?
Ans: ISP: If we want to connect to the Internet, we need to subscribe via an Internet Service Provider.
RSS: RSS (Really Simple Syndication) is a method used to publish information that needs to be
frequently updated. Such as news headlines, tickertapes or podcasts.
08. What is Podcast?
Ans: The term "podcast" is a combination of the words "iPod" and "broadcast".
A podcast is a way of providing content such as radio programs in a form which can be easily
downloaded and listened to later on a the PC or mobile devices such as an Apple iPod.
09. What is digital certificate?
Ans: A digital certificate is used to encrypt information for secure transmission across the Internet. A
digital certificate can be used to create a digital signature for an email; the signature guarantees the
identity of sender.
10. What is a Digital Signature?
A Digital signature is a code which is attached to an email to uniquely identify the sender.
11. What is Encryption?
Ans: Encryption is a means of 'scrambling' a message or web page. It is used to make a transmission
more secure, so that only the intended recipient of the message will be able to read the message.
12. What are worms?
Ans: A computer worm is a self-replicating computer program that sends copies of itself to other
computers via a network. It can copy itself from computer to computer without user’s knowledge.
Round -25 Round -25 Round -25 Round -25 Round -25 Round -25 Round -25 Round -25 Round -25 Round -25
13. What is spam or unsolicited email?
Ans: Email spam, also known as junk email or unsolicited bulk email. Clicking on links in spam email may
send users to phishing web sites or sites that are hosting malware.
14. What is Malware?
Ans: Malware: The word Malware is a combination of the words "malicious" and "software". Malware is
software designed to install itself and run without user’s consent and knowledge. Sometimes they may
sending user’s credit card details to criminals intending to steal from user’s computer.
15. What is firewall?
Ans: A firewall can help prevent hackers or malicious software (such as worms) from gaining access to
your computer through a network or the Internet. A firewall can also help stop your computer from
sending malicious software to other computers.
Or, A firewall is a software program or piece of hardware that helps screen out hackers, viruses, and
worms that try to reach your computer over the Internet.
16. How can you set any URL as home page?
Ans: Open Internet Explorer→ Click Tools menu→ Select Internet Options → General tab → Type URL
name into homepage box → Click OK;
This will set the newly added URL as homepage in Internet Explorer.
17. Write the process to clear the Browsing History?
Ans: Open Internet Explorer→ Click Tools menu→ Select Internet Options → General tab → Click
Browsing History → Click Delete History → Click Delete.
18. How can you set a browser as default Browser?
Ans: Ans: Open Internet Explorer→ Click Tools menu→ Select Internet Options → Click Programs tab →
Click on Make Default → Click Ok.
19. What is Pop Up?
Ans: Pop-ups are annoying little windows or messages that pop-up when we visit certain sites. They are
mostly used for marketing purposes but sometimes may be used for surveys or other purposes.
20. What is cookie? Why is cookie used?
Cookies: Cookies are hidden information about the user saved in the hard disc in the text file
format.
Why are cookies used: Cookies personalizes the relationship of the user with the visited website?
Cookies stores user’s preferences about a web-site. When the user re-visits the site, the user’s
Preferences are accessed automatically.
21. What is internet cache? What is the actual advantage of internet cache, explain.
Ans: Internet Cache: Internet cache is the saved copy of the visited web-sites via the internet browser.
Each time user display a Web site within Web Browser, a copy of the information (both text and
pictures) is saved on user’s hard disk.
Advantage: The reason for this is that the next time user wants to re-visit the site; the information is
quickly loaded from the copy on user’s computer hard disk, rather than slowly from the actual Internet
site.
22. What is Toolbar?
Ans: In Graphical User Interface, a toolbar is a GUI widget on which on-screen buttons, icons, menus, or
other input or output elements are placed.
23. How can you Installing Add‐ons?
Ans: click on Tools button → click on Manage Add‐ons → click on Find more Add‐ons →Then Select one
from The available Software.
24. What is Hyperlinks?
Ans: If we point to certain Hyperlinks (text or pictures) the mouse pointer changes to the shape of a
small hand. When we click on a hyperlink you will jump to a new location.
25. How can you Add a Web page to your favourites?
Ans: click on Add to Favourites icon → display the Add a Favourite dialog box→ click Add Bu]on.
26.There are codes that our need to insert into the Header or Footer box to display or format
particular information.
&w: Displays the title of the Web page.
&u: Displays the Web page address URL address.
&d: Displays the date in a short format.
&D:Displays the date in a long format.
&t :Displays the time.
&T: Displays the time using a 24-hour format.
&p :Displays the current page number.
&P: Displays the total number of pages printed.
&b :Aligns text to the right.
&b : Let’s you centre text and must be placed before and after the text you want to centre.
&&: Displays a single ampersand (&) sign.
Note: If this all looks like too much trouble, just use the default settings offered by the Internet Explorer.
27. What are the full forms of the abbreviations: HTTP, FTP, WWW,TLD, SMS,W3C,URL, VoIP,IM?
Ans:
HTTP: Hyper Text Transfer Protocol.
FTP: File Transfer Protocol.
WWW: World Wide Web.
TLD: Top-level Domain.
SMS: Short Message Service.
W3C: The World Wide Web Consortium.
URL: Uniform Resource Locator.
VoIP: Voice over Internet Protocol.
IM: Instant messaging.
28. What is VoIP? What are the Benefits of VoIP?
Ans: Voice over Internet Protocol (VoIP) is a technology that allows us to talk with other people via the
Internet. we can talk for free to other people using VoIP on our computers.
Benefits:
I. We can search for contacts, worldwide.
II. We can combine speech with video when we use a Webcam.
III. Portable, people can contact we on the move as long as we have an Internet connection.
IV. This is especially useful when travelling internationally.
29. What are the advantages of using email?
Ans:
I. Fast: Can be sent with file attached instantly.
II. Low Cost: Cost does not vary with distance.
III. Access from anywhere: Can be accessed any location if internet is available.
IV. Web-based: Web-based interface does not require any special software.
30. What are the issues to consider when sending file attachments in your email?
Ans: Issues when sending file attachments:
i. Keep the file size smaller;
ii. Avoid sending executable file as attachments;
iii. Do not send too many attachments at the same time;
iv. Do not send large file attachments.
31. What do you mean by Phishing?
Ans: The fraudulent practice of sending emails purporting to be from reputable companies in order to
induce individuals to reveal personal information, such as passwords and credit card numbers within
online.
32. What are bookmarks?
Ans: In the context of World Wide Web, bookmarks are Uniform Resource Identifier (URI) to websites
that makes easy to get back to that website.
33. What is RSS Feed?
Ans: Really Simple Syndication (RSS) is a method used to publish information that needs to be updated
frequently. Such as- news headlines, tickertapes or podcasts. A RSS document is called a ‘feed’ or
‘channel.’
34. What is Microsoft Outlook? How can you Starting Outlook?
Ans: Microsoft Outlook is a personal information manager from Microsoft, available as a part
of the Microsoft Office suite. Although often used mainly as an email application, it also
includes a calendar, task manager, contact manager, note taking, journal, and web browsing.
Starting Outlook:Click on Start button → Click All Programs→ Click Microsoft Office → Click Microsoft
Office Outlook 2007.
skype: sabbir.ahmed419
Comments
Post a Comment