9th Class Computers Science Microsoft Excel Using Formulas and Calculations

  Using Formulas and Calculations

This feature enables you to perform complex calculations easily. Using formula you can performs arithmetic and logical operation. Generally, the formulas begin with an equal (=) sign.  

 To add the contents of a cell:

• Select the cells, which you want to add.
• Click Auto Sum  to open the dropdown list and select sum to add the values of a cell, the sum will be displayed on the next cell.  

  To count the selected cell: 

• Select the cells, which you want to count.
• Click AutoSum to open the dropdown list and select count to count the cell, the count will be displayed on the next cell.  

 MS Excel enables the following common functions:  

DAVE RAGE

Is used to find the averages of the values in a database that matches the conditions specified by you. The syntax is:

DAVERAGE (database, field, criteria)  

DCOUNT

Is used to count the cells containing numbers in a column of a list or database that matches specified conditions. The syntax is:

DCOUNT (database, field, criteria)  

DCOUNTA

Is used to count the non blank cells in a column of a list or database that matches the specified conditions. The syntax is:

DCOUNTA (database, field, criteria)  

DGET

Is used to retrieve a single value from a column of a list or database that matches conditions specified by you. The syntax is;

DGET (database, field, criteria)  

DMAX

Is used to retrieve the largest number in a column of a list or database that matches conditions specified by you. The syntax is:

DMAX (database, field, criteria)  

DMIN

Is used to retrieve the smallest number in a column of a list or database that matches conditions specified by you. The syntax is:

DMIN (database, field, criteria)  

DPRODUCT

Is used to multiply the values in a particular field of records that matches the criteria in a database. The syntax is:

DPRODUCT (database, field, criteria)  

DSUM

Is used to add the numbers in a column of a list or database that matches the specified conditions. The syntax is:

DSUM (database, field, criteria)  

DVAR

Is used to estimate the population variance based on a sample with the use of numbers in a column of a list or database that matches the specified conditions. The syntax is:

DVAR (database, field, criteria).  

 Printing Worksheet

Printing provides the hard copy of your document. Before taking print you can also view the preview of your document. For this click the Print preview button,  

  To print the document:

• Select Start -> Programs -> Microsoft Office -> Microsoft Office Excel 2003.
• Open the document that you want to print.
• Select File -> Print menu option to display the Print dialog box, as shown in the following figure:
• Select a printer name from the Name list. Click OK to print the document.