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

0
443

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


Microsoft Word 2007 Hindi Notes and Sum-Min-Max-Average Formula MS-Excel 2007 Advance Excel 2016 Notes PDF Download. Download Sum-Min-Max-Average Formulas. Today we are discussing about “Microsoft Word 2007 Hindi Notes and Sum-Min-Max-Average Formula MS-Excel 2007 Advance Excel 2016 Notes PDF Download”. Download Sum-Min-Max-Average Formulas.

Sum-Min-Max-Average Formula MS-Excel 2007 || Advance Excel 2016 Notes PDF || Microsoft Word 2007 Hindi Notes:


How to use Sum, Min, Max and Average formula in MS-Excel?

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.

Microsoft Excel 2007 Sum Formula
Microsoft Excel 2007 Sum Formula

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.

Microsoft Excel 2007 Min Formula
Microsoft Excel 2007 Min Formula

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.

Microsoft Excel 2007 Max Formula

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.

Sum-Min-Max-Average Formula MS-Excel 2007 || Advance Excel 2016 Notes PDF || Microsoft Word 2007 Hindi Notes
Sum-Min-Max-Average Formula MS-Excel 2007 || Advance Excel 2016 Notes PDF || Microsoft Word 2007 Hindi Notes

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.

What is Column and Pie Chart?

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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here