Using Formulas and Calculations
Category : 9th Class
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:
To count the selected 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:
You need to login to perform this action.
You will be redirected in
3 sec