Pages

Ads 468x60px

Featured Posts

Saturday, 13 September 2014

Terminology - Access time

Terminology 


Access time - Time taken for a particular information to becoome available.

Accumulator -  A working register.

Adapter - A device used to control or interface a piece of hardware to the computer.

Add-on - The process of increasing the memory capacity, modifying the architecture, or upgrading a computer system's performance capabilities by adding circuitry or components to the system. 

Address - A number that identifies a single location in computer memory.


Monday, 25 August 2014

How to Calculate Average Run Per Over in A 20-20 Over Cricket Match


Over                       Run
1st                      12
2nd                        5
3rd                        2
4th                        8
5th                        6
6th                        3
7th                      10
8th                        3
9th                        4
10th                        6
11th                      12
12th                        6
13th                        8
14th                        9
15th                        9
16th                      10
17th                      15
18th                      12
19th                      11
20th                      18

               169(=SUM(B3:B22)) 

(1) - Calculate Average Up to 5 Over >Type >  

=   AVERAGE(B3:B7)

 

(2) - Calculate Average All Over        >Type >  

 =  AVERAGE(B3:B22)

See This Picture >



Saturday, 23 August 2014

Terminology

If you already have a computer, the lesson will you make understand  

 

Access time - Time taken for a particular information to become available.

Accumulator - A working register.

Adapter - A device used to control or interface a piece of hardware to the computer.

Add-on - The process of increasing the memory capacity, modifying the architecture, or upgrading a computer system's performance capabilities by adding circuitry or components to the system.

Friday, 22 August 2014

Formula in Excel begin with an equal sign ( = )

What is happening with the visitors when the read some solution on the net. World trend is Technical Experts. People inventions complete come true on the computer.

This again read here Formula >


Formula in Excel begin with an equal sign ( = )

For Example >   


=A1+A2+A3+A4+A5 is a formula to add the contents of cells A1, A2, And A3

Reading the directory of the disk

Almost next generation will keep hand book instead of P/T.


More knowledge keep in the drive disk is very safety for attack  the computer virus.

 
The computer knows the location of each piece of information on a disk drive by reading the directory of the disk. The disk directory is similar in concept to the label on a LP record. The label tells you which song is located where on the record.

Download > Latest Concept For The Drive

Wednesday, 20 August 2014

Excel Calculation make man perfect

Excel Calculation is very easy. Correct calculation always give us rewards. So more learm and get more rewards. Here some lesson for learner.

It is very helpful for Pay Calculation.

If we have a these numbers .


25                 50       10                 30                4               20
10               450       45                 10                2                 4
300               10         5                  4                 6               10
900                 5         2                  4                 2                 4
10                 15        10               10               10                 2

25                 60        10               10                 3                 3
100               65        15                 2                 2                 5
150               40          2                 3                 1                 2
1520           695        99               73               30               50
 

Ad A2 to A9 ; Formula =SUM(A2:A9) and then Enter


It is appear in A10
 

The same Formula For Column B, C, D, E, F………….
 

Click in Result Column A10 and Drag Cursor to next column.
 

Then we will get result of B, C, D, E, F………… 

 

Monday, 18 August 2014

How to calculate Pay and Allowances in Excel

How to calculate Pay and Allowances 

 

When we work in a office, there are many information need calculation and that time we can use Excel Book

 

For Example 

 

DA Rate is 85% ,              HR Rate is 10%

                                                                Allowances 

                                    C7

S.No.                                 Month                 Pay          DA            HR               Total
 
1 Jan-14                             12400               10540 
                                                              (=C7*85/100)
 


2 Feb-14
 
3 Mar-14
 
4 Apr-14
 
5 May-14
 
6 Jun-14
How to Manage Month, it is auto apply by excel .
 
There is no need to type again and again.

Just like Jan, Feb, March. If you drag the cursor as like above

First we type Jan 2014 and then we drag down it will automatically

Feb, March, April, May………….. 

This picture will be more helpful for you

 

 

Sample text

Sample Text

Sample Text

 
Blogger Templates