0
443

# Sum-Min-Max-Average Formula MS-Excel 2007

Ans.

## SUM Formula:

It is used to find out the sum of some values or a specific range of cells.

Syntax: =SUM(A1:A10)

The above formula is used to find out the sum of cell range from A1 to A10.

## MIN Formula:

It is used to find out the min value from some values or a special range of cells.

Syntax: =MIN(A1:A10)

The above formula is used to find out the min value from A1 to A10.

## MAX Formula:

It is used to find out the max value from some values or special range of cells.

Syntax: =MAX(A1:A10)

The above formula is used to find out the Maximum value from A1 to A10.

## Average Formula:

It is used to find out the average value from some special cells or a range of cells.

Syntax: =AVERAGE(A1:A10)

The above formula is used to find out the average of special cell A1 to A10.

## What is Chart and Graphics in MS-Excel?

Ans. Charts and Graphics makes the data effective, interesting, easy to understand, easy to analyze and compare. Excel helps you to create two dimensional and three dimensional.  Charts allow you to present data entered into the worksheet in a visual format using a variety of graph types. Before you can make a chart, you must first enter data into a worksheet.

Ans.

## Column Chart:

The column charts compare distinct item. In this chart category axis is horizontal (X-Axis) and value axis is vertical (Y-Axis). It is important to keep the number of stories in a column chart to a minimum. Too many series cause the column to become too narrow and difficult to analyses. We can use column charts to compare the results.

## Pie Chart:

These Charts show the proportion of each component value to the value in a data series. Pie charts are useful for showing proportional sales figures, or representation of different categories of population like male/female, adult/children, workers/non workers etc.

## How to insert an image into MS-Excel with Image Control and More/Less Contrast?

Ans. Follow these steps to add a photo or graphic from an existing file:

• Click on the Insert Tab. A list of option will appear into the ribbon bar.
• Click on the Image option into ribbon bar.
• An insert image dialog box will appear on the screen. Choose location where you want to add an image.
• Open Location and choose file name and click on Insert Button. Your image or graphics will be inserted on the selected place.

Image Control: allows to make the image gray scale, black and white, or a watermark.

More/Less Contrast: modifies the contrast between the colors of the image.