Q. What is Mail Merge? Write its uses.
Ans: A common word processing task, to produce periodic mailings to send to different people or agencies connected to you is called Mail Merge. The mailing features in Word can help you to organize your address data, get it into a document, and print it out in the desired format. The main uses of Word’s Mail Merge features are:
1. You can merge a list of names and addresses to a single letter that can be sent to different people in their names and addresses.
2. You can create categories, a single letter with variable information fields In it, or labels.
3. You can also produce merged document such as directory lists, invoices, print address lists, or print addressees on envelopes and mailing labels.
Q. Define Data Source.
Ans: It is a file that contains the names and addresses or any other information that vary with each version of a mail-merge document. For example, a list of names and addresses for a form letter you want to send to a list of clients or other people.
Q. Write down the steps to create Mail Merge.
OR
Q. Write the documents required in Mail Merge?
Ans: Mail Merge requires three steps:
1. Main Document: In a Mail Merge operation, the personalized document(such as, a standard letter or envelope or mailing label) is known as the main document. It is the document containing the next and graphics that stay the same for each version of the merged document. For example, the return address and body of a form letter.
2. Data Source: Data Source is a file that contains the names and addresses or any other information that vary with each version of a form letter you want to send to a list of clients or other people.
3. Merge Document: When you merge the main document with data source, a third document called merge document will be produced. The merge document can be merged to the screen to view letters along with addresses; or directly to the printer to print the letters along with addresses and print addresses on envelopes or labels; or save as some other file that can be used later for printing.
Q. What is the difference between main document and merge document in Main Merge?
Ans: In a Mail Merge operation, the personalized document(such as a letter) is called as the main document. When you merge the main document with data source, a third document called merge document with be produced.
Q. How do you create a data source using Word table?
Ans:
1. Start Word program. Open Blank Document.
2. Insert a table by selecting tab Insert Table command on the main tab bar and create a table.
3. Type the data field names on the top row of the table. Start typing the data records from the second row.
4. When you finish entering all the data records, save the table as a Word Document. Your data source document is ready.
Q. Write Steps in using Excel Worksheet as a data source for your Mail Merge.
Ans:
1. Start Excel program. Open Worksheet.
2. Type the data field names on the top row of the worksheet. Start typing the data records from the second row.
3. When you finish entering all the data records, save the worksheet.
4. Select the data field name and data record you typed in the worksheet and then click on copy button in the standard toolbar. Close the file and then exit Excel program.
5. Open Word program. Open a new document and then click on Paste button. The data will be copied to word document in a table form. Save the document. Your data source document is ready.
Q. Differentiate between the Charts and Pivot table.
Ans: Charts : It will help you in presenting a graphical representation of your data in the form of Pie, Bar, Line charts and more.
Pivot Table: It flips and sums data in seconds and allows you to perform data analysis and generating reports like periodic, financial statistical reports etc. You can also analysis complex data relationships graphically.
Q. Define the term Bar Chart?
Ans: Bar Charts are used to show comparisons between individual items. To make a bar chart the data should be arranged in the form of rows and columns on a worksheet.
Q. What is Pie Chart?
Ans: It is also called a circular chart. In a situation where one has to show the relative proportions or contributions to a whole, a pie chart is very useful. In case of pie chart only one data series is used. Small number of data points in a situation where one has to show the relative proportions or contributions to a whole, a pie chart is very useful. In case of pie chart only one data series is used.
Q. Explain the purpose of the following function with example: COUNTIF and SUMIF.
Ans: SUMIF(range, criteria, sum) : This form of sum function is used to add the cells with respective to a given criteria.
COUNTIF(range, criteria): Counts the number of cells within a range that meet the given condition.
Q. Define the Flow Chart.
Ans: A flow chart is a type of diagram that represents an algorithm or progress, showing the steps as boxes of variations kinds, and their order by connecting these with arrows.
Q. Define Auto Sum feature?
Ans: Auto sum feature will Add all contiguous numbers in a row or column. For example, if you want to sum a entire column or row follow these steps:
1. Click in the cell where you want the Sum.
2. Select the Formula tab
3. Click Auto Sum from the function library group
4. Select Sum
5. Press Enter.
Q. Write down the formula of Average function, Min function and Max function.
Ans: Average function() : It help to get the average of the numbers. It returns the average (arithmetic mean) of the arguments.
Syntax: AVERAGE(number, number2,………)
Min function() : It helps you to get the minimum of the numbers. Returns the smallest number in a set of values.
Syntax: MIN(number, number2,………)
MAX function() : It help you to get the maximum of the numbers. Returns the largest number in a set of values.
Syntax: MAX(number, number2,………)
Q. Write the steps how to Draw a Chart in Excel 2007.
Ans: Following steps are given to draw a Chart:
1. Enter data in the worksheet
2. Now select data range : By using the mouse, highlight the range of data you want to take.
3. Click Insert Tab and select a chart type from the chart group and also Select the sub type of chart.
4. Click on the chart title and write a title.
5. Give a name to X-axis
6. Give a name to y-axis
Q. What do you mean by Clip Art? Write the steps to insert a Clip Art.
Ans: A Clip Art is a single image, media file, including sound, animation, art or movie.
Steps to insert a Clip Art:
1. Click on Insert Tab
2. From Illustration Group, Click on Clip Art
3. Select a Collection and press Go Button
4. Click on a clip from the collection. Clip will be inserted in the worksheet
Q. Write Short Notes:
1. Stock Charts: Stock charts can be used to plot data arranged in column or rows in a particular order on a worksheet. As the name of self-explanatory, this chart is used to demonstrate the fluctuations with respect to stock market prices.
2. Surface Stock: Such type of chart is used in situations where both categories and data series are numeric values. This type of chart is useful in situations where the optimum combinations are found among the two sets of data. Data should be arranged in column or rows in a worksheet can be plotted in a surface chart.
3. Doughnut Charts: The conditions to draw doughnut charts are that the data has to be in the form of rows and columns. As in the case of a pie chart, the doughnut chart illustrate the relationship of parts to a whole, but it is able to get more than one data series.
4. Basic Shapes: It includes many two and three dimensional shapes, icons, braces, and brackets. Use the drag and drop method to draw the shape in the worksheet. When the shape has been made, it can be resized using the open box handles and other adjustments specific to each shape can be modified using the yellow diamond handles.
Q. What is input device? Write any five devices.Ans: Input devices accept data and instructions from the user. These are the common used devices:
1. Keyboard
2. Mouse
3. Light Pen
4. Scanner
5. Track Ball
2. Mouse
3. Light Pen
4. Scanner
5. Track Ball
Q. Define keyboard and mouse as an input device.
Ans: Keyboard: It is the most common input device. The most common keyboard use QWERTY combination of keys. A standard keyboard has 104 keys. These are numeric keys, arrow keys, special keys, alphabetic keys and function keys.
Mouse: A mouse is an electro mechanical, hand held device and used as a pointer in a computer system.
Q. Define scanner and track ball.
Ans: A scanner translates printed image into an electronic format that can be stored in a computer’s memory. Some examples of scanner are:
1. OCR(Optical Character Recognition)
2. MICR(Magnetic Ink Character Recognition)
3. OMR(Optical Mark Reader)
2. MICR(Magnetic Ink Character Recognition)
3. OMR(Optical Mark Reader)
Track Ball: It is also printing device like mouse but to move the pointer you have to rotate the ball with your thumb or your fingers. Track ball is stationary and it can be place on any type of surface unlike mouse.
Q. What is output device? Write any five output devices.
Ans: Output devices return the processed data as information, back to the user. Some common output devices are:
1. Monitor
2. Printers
3. Plotters
4. Speakers
2. Printers
3. Plotters
4. Speakers
Q. Define printer and some most common printers.
Ans: Printer is a most common output device which prints the output on paper as desired. Some of the most commonly used printers are:
1. Laser Printers: It is an extremely fast and quiet Printer but costly. It produces High Quality print than any other printer. The fastest laser printer can print up to 200 Pages/Minute in black and white and up to 100 in colour.
2. Ink Jet Printers: Ink Jet printers create image directly on paper by spraying ink by the tiny nozzles. The image quality of inkjet is high but speed is low.
3. Dot Matrix Printers: It is the most popular printer at one point of time. It is less expensive than any other printer but it is very slower and produces lower print quality.
4. Line Printers
2. Ink Jet Printers: Ink Jet printers create image directly on paper by spraying ink by the tiny nozzles. The image quality of inkjet is high but speed is low.
3. Dot Matrix Printers: It is the most popular printer at one point of time. It is less expensive than any other printer but it is very slower and produces lower print quality.
4. Line Printers
Q. Define monitor and type of monitors.
Ans: It is the most important output device also known as V.D.U.(Visual Display Unit). Information processed within the CPU is needed to be visually displayed, in the same manner as a television displays information, monitor uses the same technique to display information as T.V. There are two types of monitors:
1. C.R.T.
2. L.C.D.
CRT: It stands for Cathode Ray Tube Monitor. It is like typical monitor that looks like a T.V. screen. It has a large vacume tube called cathode ray tube.
2. L.C.D.
CRT: It stands for Cathode Ray Tube Monitor. It is like typical monitor that looks like a T.V. screen. It has a large vacume tube called cathode ray tube.
LCD: It stands for Liquid Crystal Displays Monitor. It also called Flat Panel Monitor. These days LCD monitors are very popular.
Q. What is software? Identify the various types of software.
Ans: Computer is a machine which cannot do anything without instructions from the user in order to do any specific job you have to give a sequence of instructions the computer. This set of instruction in a proper sequence is called a computer program. Software refers to the set of computer programs that cause the hardware(computer system)to function in the desired manner. A complete set of instructions written to solve a problem on a computer is called software.
Types of Software: Computer software is normally classified into two broad categories:
1. System Software
2. Application Software
2. Application Software
Q. What is Assembly Language? Explain its advantages and disadvantages.
Ans: In the 1950s, to reduce programming complexity and provide some standardization, assembly language were developed Assembly languages, also known as symbolic languages using abbreviations or mnemonic code- codes more easily memorized to replace the 0s and 1st of machine languages an assembly language program to be executed, it must be converted to machine code. The assembly language program to be executed, it must be converted to machine code. The assembly language program is referred to as a ‘source program’ whereas the machine language programs an ‘object program’.
Q. What is High Level Language?
Ans: High Level Language is almost English like language, used by human beings for writing programs. These are easier to learn require less time to write programs, provide better documentation and easier to modify.
The main advantages of high level language its portability i.e., any high level language program can be used and executed in almost all computers with little or no change.
A program written in high level language is also called as source program and cannot be understood by the computer it has to be translated in to machine understandable form.
Q. Write any four example of High Level Language.
Ans: BASIC: It stands for beginners all purpose symbolic instruction code. It is easy to learn general purpose language like BASIC.
COBOL: It stands for common business oriented language. It is used for commercial applications.
FORTRAN : It stands for formula translate. It is developed for solving mathematical and scientific problems.
Q. What is machine language?
Ans: It is the lowest level of programming language, in which instruction is represented in the form of binary numbers as ‘0 and 1’. Its execution is very fast and efficient because the computer can accept the machine code as it is. A programmer must keep track of a tremendous amount of details. It is very tedious and time consuming.
Q. Differentiate between the Charts and Pivot table.
Answer:
Charts: It will help you in presenting a graphical representation of your data in the form of Pie, Bar, Line charts and more.
Pivot Table: It flips and sums data in seconds and allows you to perform data analysis and generating reports like periodic, financial statistical reports etc. You can also analysis complex data relationships graphically.
Q. Define the term Bar Chart?
Answer: Bar Charts are used to show comparisons between individual items. To make a bar chart the data should be arranged in the form of rows and columns on a worksheet.
Q. What is Pie Chart?
Answer: It is also called a circular chart. In a situation where one has to show the relative proportions or contributions to a whole, a pie chart is very useful. In case of pie chart only one data series is used. Small number of data points in a situation where one has to show the relative proportions or contributions to a whole, a pie chart is very useful. In case of pie chart only one data series is used.
Q. Explain the purpose of the following function with example: COUNTIF and SUMIF.
Answer:
SUMIF (range, criteria, sum) : This form of sum function is used to add the cells with respective to a given criteria.
COUNTIF (range, criteria): Counts the number of cells within a range that meet the given condition.
Q. Define the Flow Chart.
Answer: A flow chart is a type of diagram that represents an algorithm or progress, showing the steps as boxes of variations kinds, and their order by connecting these with arrows.
Q. Define Auto Sum feature?
Answer: Auto sum feature will add all contiguous numbers in a row or column. For example, if you want to sum a entire column or row follow these steps:
1. Click in the cell where you want the Sum.
2. Select the Formula tab
3. Click Auto Sum from the function library group
4. Select Sum
5. Press Enter.
Q. Write the steps how to draw a Chart in Excel 2007.
Answer: Following steps are given to draw a Chart:
1. Enter data in the worksheet
2. Now select data range: By using the mouse, highlight the range of data you want to take.
3. Click Insert Tab and select a chart type from the chart group and also Select the sub type of chart.
4. Click on the chart title and write a title.
5. Give a name to X-axis
6. Give a name to y-axis
Q. What do you mean by Clip Art? Write the steps to insert a Clip Art.
Answer: A Clip Art is a single image, media file, including sound, animation, art or movie.
Steps to insert a Clip Art:
1. Click on Insert Tab
2. From Illustration Group, Click on Clip Art
3. Select a Collection and press Go Button
4. Click on a clip from the collection. Clip will be inserted in the worksheet
Q . Mention the steps
for connecting to a website:-
1. Types a URL for a
website in browser say www.nios.ac.in.
2. Your browser attempts
to make a connection and sends the request to Web Server.
3. The Web Server
receives and processes the request.
4. The Web Server
responds to the request with the home page of the website.
5. The webpage is
displayed by your browser and the connection between the server and your
browser is closed
Q. Steps to
rename a worksheet
1. To rename a
worksheet follow the steps as
2. Right click on
the worksheet tab which you want to rename
3. Select rename
from the Pop Up menu
4. Type new name
for the Worksheet
Q. Insert blank cells on a worksheet
Select the cell
or the range (range: Two or more cells on a sheet. The cells in a range can be
adjacent or nonadjacent.)of cells where you want to insert the new blank cells.
Select the same number of cells as you want to insert.
On the Home tab,
in the Cells group, click the arrow next to Insert, and then click Insert
Cells.
You can also
right-click the selected cells and then click insert on the shortcut menu.
In the Insert
dialog box, click the direction in which you want to shift the surrounding
cells.
Q. Insert rows on a worksheet
1. Do one of the
following:
To insert a single row, select the row or a cell in the row above which you
want to insert the new row. For example, to insert a new row above row 5, click
a cell in row 5.
To insert multiple rows, select the rows above which you want to insert
rows. Select the same number of rows as you want to insert. For example, to
insert three new rows, you need to select three rows.
To insert nonadjacent rows, hold down CTRL while you select nonadjacent
rows.
2. On the Home
tab, in the Cells group, click the arrow next to Insert, and then click Insert Sheet
Rows.
Q. Steps to AutoFit
Columns
1.
Click on Column Header/or
any other cell in the column
to change its
width
2.
Click Home tab
3.
Select format from the
cells group on the ribbon.
4.
Click on AutoFit Column
Width
Q. Steps to Unprotect worksheet
You can unprotect
your worksheet to edit it.
Steps to
unprotect worksheet
1.
Select Home tab.
2.
Click Format in cells
group.
3.
Choose Unprotect sheet
from Drop Down Menu. Un protect sheet dialog box will appear. Enter password to
unprotect sheet. Password must be same as used for protecting the worksheet.
Press OK.
Q. Difference between Compiler and
Interpreter
Answer:
Compiler: The
software (set of programs) that reads a program written in high level language
and translates it into an equivalent program in mae chine language is called as
Compiler.
Interpreter: The software (set of programs) that reads a program written in assembly
language and translates it into an equivalent program in machine language is
called as Assembler.
Q.
Difference between CRT & LCD.
Answer:
CRT: Cathode Ray Tube Monitor is the typical
monitor that you see on a desktop computer. It looks a lot like a television
screen, and works the same way.
LCD: This type of
monitors are also known as flat panel monitor. Most of these employ liquid
crystal
displays (LCDs) to render images.
Q. Difference between Web Page and Website
Web Page: A web page is an electronic document written in a computer language called HTML. Web pages can contain text, graphics, video, animation, and sound, as well as interactive features, such as data entry forms.
Website: A website is one or more web pages, belonging to a particular company, institute, government or an individual. The first page is called the home page, which acts like an index.
Q. Difference between URL and IP
URL: Every page on the web has a unique address, called Uniform Resource Locator, URL. A URL indicates where the web page is stored on the Internet.
IP
(Internet Protocol) Address: Computers do not understand letters or symbols
that humans use to communicate effectively. Computers understand
numbers-specifically, 1s and 0s. Thus every host (a computer linked to the Internet)
on the Internet has a unique host number. This number is called the Internet
Protocol address, or IP address.
Compiler:
The software (set of programs) that reads a program written in high level
language and translates it into an equivalent program in machine language is
called as Compiler.
Assembler:
The software (set of programs) that reads a program written in assembly
language and translates it into an equivalent program in machine language is
called as Assembler.
A keyboard is the most common input device. Several kinds of keyboards are available, but they resemble each other with minor variations. The keyboard in most common use is the QWERTY board. Generally standard keyboard has 104 keys. In these keyboards, the cursor control keys are duplicated to allow easier use of the numeric pad.
Light Pen is an input
device that utilizes a light-sensitive detector to select objects on a display
screen. A light pen is similar to a mouse, except that with a light pen you can
move the pointer and select objects on the display screen by directly pointing
to the objects with the pen.
These devices are used for automatic data collection. The devices
of this category completely eliminate manual input of data. For example, the
bar-code reader is actually just a special type of image scanner.
