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.
