computer free courses

computer free courses MS Word , MS Excel , MS Access, InPage , Corel Draw , Windows Installation.

Monday, July 2, 2018

Bullets and Numbering

MS Word ,
Bullets and Numbering

Bullets and Numbering

With Word, you can make bulleted lists, numbered lists, or outlines.
Bullets and Numbering
Bullets and Numbering















In the Home command tab within the Paragraph group click Numbers or Bullets.
A list pull down.

Click the desired Bullet or Number format.




If my posts are useful for you، or if there is any reduction in them so kindly comment me.
Read more »
By di No comments:
Label:

Borders and Shading Options Dialog Box Option

MS Word ,
Borders and Shading Options Dialog Box Option

Borders and Shading Options Dialog Box Option

Select the paragraph(s) to which you want to add shading and/or border(s)
Borders and Shading Options Dialog Box Option
Borders and Shading Options Dialog Box Option















From the Ribbon, select the Home command tab
Within the Paragraph section, click BORDERS » select Borders and Shading...
The Borders and Shading dialog box appears



If my posts are useful for you، or if there is any reduction in them so kindly comment me.
Read more »
By di No comments:
Label:

IF Function in MS Excel

MS Excel ,
IF Function in MS Excel

IF Function

The IF function is used to make decisions. It returns one value if a specified condition evaluates to TRUE and another value if it evaluates to FALSE. For example, you can display a massage “Pass” if marks are more than 40 or “Fail” otherwise. The syntax for the IF function is:
If(condition, value_if_ture, value_if_false)
Condition is the value to be tested.
IF Function in MS Excel
IF Function in MS Excel














Value_if_true is the value that is returned if condition evaluates to TRUE.
Value_if _false is the value that is returned if condition evaluates top FALSE.
Insert marks of the student in A1.
Type IF(A1>40,”Pass”,”Fail”) in B1
Press ENTER
If the value of A1 is more than 40, “Pass” will be displayed in B1. Otherwise

“Fail” will be displayed





If my posts are useful for you، or if there is any reduction in them so kindly comment me.
Read more »
By di No comments:
Label:

Functions are used in MS Excel

MS Excel ,
Functions are used in MS Excel

Some commonly used Functions

There are most recently or commonly used functions are as followings.
Functions are used in MS Excel
Functions are used in MS Excel








Function Syntax                                             Purpose
=Sum(range)                                                   For addition of cells or values
=product(range)                                              For multiplication of cells / values
=average(range)                                              For average of cells or values
=max(range)                                                   For Maximum value of range
=min(range)                                                    For minimum value of range
=count(range)                                                 For counting of numeric values
=counta(range)                                               Count the numbers of cells that are not empty.
=countblank(range)                                        Count the empty cells in the range
=countif(range, criteria)                                 Count the number of cells within a range that meet the condition.
=today()                                                          Shows the today date
=now()                                                            Shows the current date with time
=days360(St_date,En_date)                           Return the number of days between two dates.
=day(date)                                                      Return the day from the date
=month(date)                                                 Return the month from the date
=power(value,power)                                    Calculate the result of number raised powers
=sumif(range, criteria,sum_range)                adds all numbers in a range of cells, based on a given criteria.

=If(condition,value_if_ture,value_if_false)  The IF function is used to make decisions.






If my posts are useful for you، or if there is any reduction in them so kindly comment me.
Read more »
By di No comments:
Label: