MS Excel (Microsoft Excel) E-Learning Day 2

 Tutor Chetan - Notes

Microsoft Office Package

MS Excel - Day 2

Day 2 - PDF File

# Logical Functions:

IF, AND, OR are known as logical functions in MS-Excel program.

 # IF Function:

This function is used, if only one condition is given. It may be either true or false.

 # AND function:

This function is used, if the all data range (field) names are given as a condition.

# OR Function:

This function is used, if more than one comparative condition is given as a condition. It checks the first condition, if the first condition is wrong it will check the second condition and gives the valuable result "True" or "False".

# Functions(Alt+=):

Functions are used to solve the numerical problems into the resulting cell.

=Sum(Range of cells)=>Returns the sum of selected cells.

=Max(Range of cells) =>Returns the largest value into the selected cells

=Min(Range of cells) => Returns the smallest value for selected cells

=Average(Range of cells) => Returns the average value of the selected cells

=SQRT(Number) >=Returns the square root of a number

=Power(Number,power) => Returns the power of a number.

=Int =>Returns the whole number without decimal place

=Today( ) => Returns the current system date only.

=Now( ) => Returns the current system date and time.