1.
What are the advantages of e-commerce?
E-commerce:
The phrase e-commerce is buzzword which relates to buying or selling via the
internet.
Advantages
of e-commerce:
- Services available 24/7
- Large stock range
- Detailed product information
- Ability to compare prices
- Equal delivery to town and
country
- Right to return defective goods
2.
What does Information and Communication Technology (ICT) mean?
Ans.
ICT stands for Information and Communication Technology. In the Australasia
region the term IT & T is often used instead of ICT. This stands for
Information Technology and Telecommunications.
These
terms cover are wide range of computer related fields including:
- Installing and maintaining
computer system and application
- Designing, installing and
maintaining computer networks
- Data management
- Computer hardware maintenance
- Database and software design
3.
How can you protect against computer virus infection?
Ans.
The safest way to use a computer is to not connect it to a Local Area Network
or the Internet. This is called a ‘stand-alone’ computer, providing that you do
not use disks on that PC which have been used in other computers this type of
computer is virtually immune from any form of intrusion.
- Always make sure that all
computers require an ID and password to access them. Make sure that all
relevant security patches from Microsoft have been applied.
- Make sure that the password is
long enough, contains a random mixture of numbers and letters, and that
the passwords are changed on a regular basis.
4.
How can you view your computer’s details?
Move
the mouse pointer to the item within the Welcome Center window called View
Computer Details. Click once using the left hand mouse button.
You
will see details of your computer displayed within the window.
5.
What are folders in Microsoft Windows?
Files
are stored on a disk in folders. A folder is a container for your files. Every
file is stored in a folder or a sub-folder (a folder within a folder). You can
access all your folders by clicking Computer in the navigation pane (the left
pane) of any open folder.
6.
What is the Recycle Bin? What are the uses of Recycle Bin?
A
recycling bin (or recycle bin) is a container used to hold
recyclables before they are taken to recycling centers. Recycling bins are a
common element of municipal collection programs, which frequently distribute
the bins to encourage participation.
Uses
of Recycle Bin: Managing
your computer's files means knowing where they are when you need them. It's
also important to know how to delete them safely and effectively when you no
longer need them. The Recycle Bin is a temporary folder that stores any files
that are intended for deletion. These files are not deleted until prompted.
This gives you the option of changing your mind in case you accidentally delete
the wrong file.
7.
What does ‘Updating anti-virus programs’ mean?
Computer
viruses, worms, and other threats to computers are frequently created by
malicious users, and to help your computer from becoming infected, antivirus
companies develop definition, identity, or pattern file updates that enable the
antivirus program identify and prevent new viruses, worms, and other threats
from attacking your computer.
If
your computer and antivirus scanner is not updated it will be vulnerable to any
computer virus or worm that has been released since your last update. This
could mean if you have not updated your antivirus program in over a month that
your computer could be infected or have the potential of being infected by
dozens of different viruses and worms. (Source: Internet)
8.
How can you replace multiple wrong words with correct ones at a time in MS
Word?
Within
the find what section (Find & Replace dialog box) type in the text you
writs to search for, in this case type in the word internet (wrong word)
click on the find Next button. The next occurrence of the word Internet will be
found and highlighted within the document. When find any wrong word then click
Replace all will causes all wrong word will replace with the correct word at a
time. Close the Find and Replace dialog box.
9.
Write down the keyboard shortcut for the following functions:
a)
Making fonts size bold
:
CTRL+B
b)
Making fonts
underlined
: CTRL+U
c)
Making font’s
italic :
CTRL+I
d)
Increasing font size :
CTRL+] or Ctrl+Shift+>
e)
Making paragraph right aligned: CTRL + R
10.
What is procedure of inserting Symbols in an MS Word document?
First
go to the insert tab. Then go to the symbol group. Then choose the correct
symbols.
Insert
Tab>Symbol or click drop down menu to get more symbol.
11.
How can you add automatic page numbering in the header of an MS Word documents?
First
go to the insert tab. Then go to the header & footer group. Then select
Page Number. Then select top of the page. Here we can find many samples. Just
choose any type of the samples and it creates automatic page numbering in the
header of an Ms Word documents.
Insert
tab> page number> top of the page. Select any samples.
12. What
is shorting? How can sort a cell range in MS Excel?
Sorting
is procedure to rearrange the data by ascending, descending or any custom
choice.
First
select the column. Then go to the Home ribbon tab. Then go to the editing group
and select ‘sort & filter’. Here we can sort whole selected column by
ascending, descending or any custom choice.
13.
What is a Function in MS Excel? What Function is used for counting the number
of cells in a range?
A
function allows to calculate a result such as adding numbers together, or
finding the average of a range of numbers.
‘COUNT’
function is used for counting the number of cells in a range.
14.
How can you select a range of cells not next to each other?
Press
down the Ctrl key and select a range of cells. Release the Ctrl key. In this
way we can select a range of cells not next to each other.
15.
How can you rename a worksheet?
Double
click the worksheet name or right click of the mouse and select rename option.
16.
What is advantage of using index in your database?
Access uses indexes much like the table of contents. There are some advantages
are:
- To help locate and short
information quickly.
- An index store the location of
records based on the field or fields.
- It can retrieve the data by
moving directly to the correct location.
17.
How can you create a MS Access From?
First
select the table that you want to make a form. Then select Create tab and
select form icon on the from section.
Select
table> Create tab>Form
18.
Describe the “One-to-many relationship” in MS Access?
Consider
a Parts sales database that includes a Customers table and an Orders
table. A customer can place any number of orders. It follows that for any
customer represented in the Customers table, there can be many orders
represented in the Orders table. The relationship between the customers
table and the Orders table is therefore a one-to-many relationship.
19.
What is use of Design view in MS Access?
Design
view displays the working behind the objects, as seen by the database designer.
The efficiency of the database and the way it handles data input/output are
controlled by the properties configured in Design view.
20.
What is Slide Show view?
In
Slide Show view the slide will be displayed as a slide show and fill the whole
screen. Click the mouse button to advance through the slide show. To stop slide
show at any point, press the Esc key.
21.
What is a Slide Master?
Slide
master contain the underlying content and formatting information used by a
slide within a presentation. You can easily edit your slide masters. If you
have a company logo, you could edit the slide master within your presentation
so that the logo is embedded within the slides and each time you create a new
slide, that slide will automatically display your company logo.
22.
How can you insert Dates into the footer in a PowerPoint presentation?
Open
a presentation. To Insert a date into a footer first click on the Insert Tab
and from within the Text section, click on the Header & Footer button.
Click on Date and Time check box. The Date and time option now will be
activated. Click apply (for single slide) or Apply all (for all slides)
23.
What are Web sites and URLs?
Web
sites:
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’. From the
Web sites you can download information and software.
URLs: The address of a Web site is given
by something called its URL (Uniform Resource Locator). The URL is just another
name for a Web address. The URL consists of the name of the protocol followed
by the address of the computer you want to connect.
24.
What is Firewall?
A
firewall is a system that secures your network from access by unauthorized
users. A firewall can be implemented via software, hardware or by a combination
of the two. If you are using broadband for Internet access, it is vital that
some sort of firewall is in place to stop people trying to hack into your
computer.
25.
What is Spam or Unsolicited Email?
Spam
is the bulk sending of unsolicited and often fraudulent email messages,
normally trying to sell a commercial product or service. There are companies
which will sell lists of email addresses by the million. Your will receive more
and more spam emails, offering you and increasingly bizarre range of products
and services! In many countries the sending of spam is now against the law!
26.
What is the difference between the “operating system” and “application
software”?
The
operating system works closely with the hardware that you have installed within
your computer. It interprets the input via the mouse or keyboard and outputs
data to the screen. For example: Windows XP, Windows Vista, Windows7 etc.
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. For Example: MS.Word, MS.Excel, MS.Access etc.
27.
What does “Data protection and Privacy issues” mean?
If
your computer system holds information about individual, then you have a moral
and legal duty to treat that information with respect. Doctors, government
departments and credit agency often hold vast amount of information about the
general public, which is both sensitive and private. In a free society you have
the right to ensure that the information held about you is not abused. In many
countries, this right is enshrined under data protection law.
28.
What do you know about password policies?
Your
password is the only thing which prevents someone else logging into a computer
using user ID and impersonating you.
- It is important to choose a
password which cannot be easily guessed by other people.
- Ideally a password should be at
least 8 characters long & contain a mixture of words and numbers.
- You have to change your
password regularly.
- Some computer system will
require you to change your password periodically.
- Never share your password with
others.
29.
What does “Drag and drop” mean?
The
concept of selecting an item and then moving it while keeping the mouse button
pressed is often called “dragging” or “Drag and drop” . It is called this
because you drag an item to a new location, and then drop it at the new
location.
30.
How can you customize your Desktop?
Customize
the Desktop: Right
click on an empty part of the Desktop and you will see a popup menu. From the
popup menu click the personalize command. This will display a dialog box. Now
you can use this dialog box to customize elements of your computer system.
Or,
Click right button on Desktop----> click Personalize.
A
dialog box will be appeared. Now you can customize your Desktop.
31.
Discuss about various types of drives?
There
are various types of drives. Such as Hard Disk Drive, CD or DVD drive, Flash
drive or USB drive, Floppy disk drive, Network drive etc.
HDD: When you save a data file you
normally save into in your hard disk. This disk is contained within your
computer & you cannot normally see it. By convention of hard disk is called
‘Drive C’.
CD
or DVD drive:
We can play CD or DVD disk into this drive.
USB
drive: You
can plug removable hard disk , USB Memory sticks and USB devices.
Floppy
disk drive:
You can use it for diskettes. Now a day it’s not in use.
Network
drive:
If you are connected to a network, your network administrator may have set you
up with additional Network drives.
32.
How can you use Searching option to search files on your hard disk?
Click
on the Start button and then click on the Search command. This
will display the Search dialog box. Type the name of the file into the dialog
box what you want to search. Click on the Search in File content icon. Double
clicking on the file will display the file contents.
33.
What are the uses of Header and Footer in MS. Word?
If
you are planning to print a document, it is a good idea to add a footer or
header to the document, especially if it is a long document. You can insert
page number, Date, notes etc in Header and Footer area.
How
to use Header and Footer: Click
on the Insert tab and from the Header and Footer section click on
the Header icon. A drop down list will be displayed. Select the Edit
Header command. The Header area will be displayed. Type in your Header
text. Close the Header and Footer Tools.
To
insert footer, click on the Footer icon and select the Edit Footer
command. Type in your Footer text. Close the Header and Footer Tools.
34.
How can you correct the spelling and grammatical mistakes in MS Word?
A
wavy red underline show in the wrong spelling word. Click right button of the
mouse of that word.MS Word suggest something close to that word. Just select
the appropriate word and correct the spelling mistake.
A
wavy green underline shows in the wrong grammatical mistakes sentence. Click
right button of the mouse of that sentence.MS Word suggest something close to
that sentence. Just select the appropriate sentence and correct the grammatical
mistakes.
35.
How can you add columns to an existing table in MS Word ?
Select
the second column within your table and right click over the selected column.
You will see a popup menu displayed. Click on the Insert command and you
will see a submenu displayed. You can insert a column to the left or o the
right of the column you selected. In this case insert a column to the
right of the selected column.
36.
Describe the keyboard methods for navigating between the cells in a table in MS
Word document?
Click
within the first cell in the table. Type some word. To move to the next cell
press the TAB key. To move previous cell Press Shift+tab key.
37.
What is Numbers & Date formatting? How can you apply that in your MS Excel
Worksheet?
Open
any workbook. Click on any cell. Click on the down arrow next to the Number
Format control. You will see a drop down menu from which you can select the
format. Select Number or Date. This tells Excel that the data
contained within this cell should always now be treated as a number, rather
than say text or a date.
38.
What is the default text and number alignment in MS Excel?
The
default text alignment with in a cell in MS Excel is left, while numbers are
aligned within the cell to the right.
39.
How can you move the contents of a cell or a range of cell between worksheets
(in different workbooks)?
Open
a workbook called book1. Open a second workbook called book2. Select a cell,
range, row or column to move. Press ctrl+X to cut(move). Switch
to the second workbook called book2. Click at the location you wish to past the
data. Press the Ctrl+V key at paste the date from the clipboard.
40.
Why do you use the absolute cell referencing?
open
a worksheet that contains some data. Click on cell where you input data. Start
inputting formula with (=) then select the cell what is want to
calculate. After selecting specific cell then press F4 from key board. That
will display ($D$4). This Dollar sign make D4 cell absolute cell
reference. ( Give more suggestion about this Ans )
41.
What is the difference between data and information?
Data: Data refers to discrete items. In
contrast, information involves linking together two or more items of data provide
an item of knowledge or meaning. Facts, statistics used for reference or
analysis. Numbers, characters, symbols, images etc which can be processed a
computer is data. Data must be interpreted, by a human or machine, to drive
meaning.
Information
: Information
Is interpreted data. Data that has been processed to produce meaning.
Information build of data.
42.
What is query/are queries in MS-Access? Name the different types of Query?
A
query is/Queries are similar to filtering and shorting tables but much more
powerful. Unlikely filters, multiple criteria can be used in one or more fields
to be highly specific about the information you wish to extract from a table.
Different
types of queries:
- Simple Query
- Crosstab Query
- Find Duplicates Query
- Find Unmatched Query
43.
What are uses of Reports in MS-Access?
Uses
of Reports:
- Present the data in an
organized
- Present the data meaningful
- Present the data easy to read
layout.
44.
What is a relational database?
A relational database is able to
store and manipulate data across multiple tables unlike a single table
database. By utilizing multiple tables, a relational database reduces
unnecessary duplication of data. For example, for a large database to store
customer information, only the unique address needs to be recorded each time
when we add a new customer.
45.
Write the steps for inserting slides with a particular slide layout?
Start
PowerPoint and open a desire presentation, display the last slide
within the presentation, click on the Home tab within the slides section, click
on the bottom part of the New Slide button.
This
displays the new slide.
46.
How can you insert a picture (clipart) into a master slide?
We
can insert a picture or ClipArt into a master slide by following this steps:
Click View Tab. Then Click Slide Master within the Presentation view section.
To
Insert Picture Click Insert Tab and click Picture icon within the illustration
section. Now you can insert picture from your location.
To
Insert Clip Art Click Insert Tab and click ClipArt icon within the illustration
section. This will display a clipart pane down the right side of the screen.
Search a ClipArt within the search for section and Click on an item of clip
art. It will be displayed within the slide master.
47.
What is Slide Transition? How can you apply the same slide transition to all
the slides at a time?
Slide
Transition allows you to add special effects that will be displayed as you move
from slide to slide within the Transition to The Slide section.
To
do this click on the Animations tab. Click on the down arrow within the
Transition to this slide section. Click on a transition effect of your choice,
Click Apply to all.
48.
What do you know about Web Browsers?
The
Web Browsers allows you to view Web pages. Web Browsing application include
‘Internet Explorer’ (from Microsoft), Opera and Firefox. In each case there are
many different versions, you will find that the later version offer more
versatility, as well as a better range of built-in features. Another example is
the Apple Safari web browser.
49.
What are the advantages of using email?
The
advantages of using email:
- Fast
- Low cost
- Worldwide portability
- Time Zone friendly
- Web-based Email
50.
What is the digital signature?
A
digital signature is a code which is attached to an email to uniquely indentify
the sender. Like a traditional hand written signature the purpose of the
digital signature is to guarantee that the sender of the message is who he or
she claims to be. Digital signatures employ sophisticated encryption techniques
to ensure that they cannot be counterfeited.
51.
What is storage media? Write the names of a few commonly used storage media.
52.
What are the definitions for freeware and shareware?
Freeware:
This is software which can be copied or downloaded free. It is often fully functional.
Examples may include software developed by organizations such as Universities,
where the aim was not to profit from the software.
Shareware:
This is where you can use software for a trial period. Sometimes the shareware
version may be fully functional, but after a time period will either start to
display an annoying message, asking you register your software.
53.
What are the advantages of e-banking?
The
advantages of e-banking are:
¾
We can pay our bills online and move money from one place to another.
¾
Some Online banks have no physical branches at all.
¾
Bank cost can be reduced.
¾
The customers benefit from 24-hours access to banking service.
54.
Describe how you can close an application that is not responding.
We
need to press Ctrl+Alt+Del keys simultaneously. A list of options will be
displayed. Select the Start Task Manager option. This will display the Task
Manager dialog box. Select the non-responding application from the list
displayed and click on the End Task button.
55.
What are computer files?
Once
a program such as a word processor is loaded into RAM you can use it to create
a document. When we save a copy of this document to a storage media, that is
called a file. Basically there are two types of file, Program files and Data
files
56.
What is file detail? How can you view file details?
We
can view the file name, date modified, file type and file size from file
detail.
Right
click
on the selected file and from the popup menu displayed select the properties
command. This will display the Properties dialog box for the selected file,
displaying even more detailed information about the file.
Click OK button to close the dialog box.
57.
What is file compression? What are the benefits of file compression?
File
compression lets you make the size of file smaller. This is useful when you
need to save space on a disk or when you are sending a file as an email
attachment and you want to keep the size of your attachments as small as
possible.
58.What
is mail merge in MS Word?
The
mail merge feature is used to insert variable data into the a fixed format by
combining two files into one file. Two files need to be created before you can
merge them, there are data file and main document file.
59.Discribe
how you can custom margins and paper size for an MS Word document.
Custom
Margin: Click on the page layout tab. From the “page setup“ section click on
the margin button. To create your own custom margin, click on the “custom
margin” command displayed at the bottom of the margin drop down list. From the
page set up dialogue box displayed ,we can personalize by using top, bottom,
left and right section.
Paper
size: Click on the page layout tab. Then within the page setup section click on
the “size” icon. you can click on an item within the drop down list to change
the page size.
60.How
can you insert a picture (available as file in the computer)in a MS Word
document?
Click
on the insert tab-then click on the picture icon. This will display a insert
picture dialogue box. Then double click on a sample picture –then single click
on the picture and click on insert
61.
How can you insert a picture (available as file in the computer)in a MS Word
document?
(a)
ctrl + o (b) ctrl +s,
(c) ctrl + p (d) Ctrl + F4
62.
What is chart in MS Excel?
I.
Column chart
II. Line
chart
III. Pie chart
63.
How can you select a range of cell located next to each other ?
A
range of connecting cells: We want to select the cells from C3 to G3.
To do this click on the first cell within the range, i.e. C3. Then press
down the shift key (and keep it held down). Click on cell G3. When you release
shift key the cell range will remain selected.
A
range of non-connecting cells: Sometimes we need to select multiple cells
that are not next to each other, as in the example below, where C3, E3 and G3
have been selected.
64.
What is auto fill in MS Excel 2007?
Auto
full option gives us to fill some general requirement fill automatically. Just
need to input starting data then auto fill option will helps you fill
automatically. Open any work book. Click on any cell. Write 1, then click down
next cell, write 2. Then select two cells. Move the mouse pointer to the
bottom-right corner of this cell and the mouse pointer shape of a small black
cross. When the mouse pointer changes shape, press the mouser left button and
move slowly down to page. When you release the mouse button you will see that
Excel has Auto filled the range you dragged across with the Auto numbers
65.
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 number together or
finding the average of a range of numbers. Maximum value:Max(C4:C9)
66.
What are available data types in MS Access 2007?
There
are 11th available data types in MS Access 2007, they are:
