9th Class Computers Microsoft Excel Using Formulas and Calculations

Using Formulas and Calculations

Category : 9th Class

*  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.


You need to login to perform this action.
You will be redirected in 3 sec spinner

Free
Videos