computer free courses

Monday, July 2, 2018

Bullets and Numbering

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

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.

Borders and Shading Options Dialog Box Option

Muhammad Adnan MS Word ,

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

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.

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

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.

Functions are used in MS Excel

Muhammad Adnan MS Excel ,

Some commonly used Functions

There are most recently or commonly used functions are as followings.

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.

Paragraph Shading in MS Word

Muhammad Adnan MS Word ,

Adding Shading

Select the paragraph(s) to which you want to add shading

Paragraph Shading in MS Word

Open the Borders and Shading dialog box

Select the Shading tab

From the Fill pull-down list, select the desired fill effect

Click OK

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Paragraph Border in MS Word

Muhammad Adnan MS Word ,

Adding Borders

From the Ribbon, select the Home command tab Within the Paragraph section, the Shading and Border options are available.

Paragraph Border in MS Word

Select the paragraph(s) to which you want to add shading and/or border(s)

To add a border, click BORDERS » select the desired border option

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Absolute Cell References in MS Excel

Muhammad Adnan MS Excel ,

Absolute Cell References

Situations arise in which the cell reference must remain the same when copied or when

using AutoFill. Dollar signs are used to hold a column and/or row reference constant.

Absolute Cell References in MS Excel

Summary of absolute cell reference uses:

$A1

Allows the row reference to change,

but not the column reference.

A$1

Allows the column reference to

change, but not the row reference.

$A$1

Allows neither the column nor the row

reference to change.

Example:

In the example below, when calculating commissions for sales staff, you would not want

cell B10 to change when copying the formula down. You want both the column and the

row to remain the same to refer to that exact cell. By using $B$10 in the formula, neither

changes when copied.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Relative Cell References in MS Excel

Muhammad Adnan MS Excel ,

Relative Cell References

This is the most widely used type of cell reference in formulas. Relative cell references are basic

cell references that adjust and change when copied or when using AutoFill.

Relative Cell References in MS Excel

Example:

=SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the

next cell.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

computer free courses

Monday, July 2, 2018

Bullets and Numbering

Bullets and Numbering

Borders and Shading Options Dialog Box Option

Borders and Shading Options Dialog Box Option

IF Function in MS Excel

IF Function

Functions are used in MS Excel

Some commonly used Functions

Sunday, July 1, 2018

Paragraph Shading in MS Word

Adding Shading

Paragraph Border in MS Word

Absolute Cell References in MS Excel

Absolute Cell References

Summary of absolute cell reference uses:

Example:

Relative Cell References in MS Excel

Relative Cell References

Example:

Search This Blog

Blog Archive

Post Top Ad

Categories

Popular Tags

Contact Form