Excel formula and function practice session, practical

NUMBER SYSTEM :

Types of Number System -

There are various types of the number system in mathematics.

The four most common number system types are:

1. Decimal number system (0 to 9) -  [Base - 10]
2. Binary number system (0, 1) - [Base - 2]
3. Octal number system (0 to 7) - [Base - 8]
4. Hexadecimal number system (0 to 9 and A to F) - (Base - 16)

Decimal number system has base 10 because it uses ten digits from 0 to 9. In the decimal number system, the positions successive to the left of the decimal point represent units, tens, hundreds, thousands and so on. This system is expressed in DECIMAL NUMBERS. The base of the decimal is 10. This shows that there are ten symbols, 0 to 9. 

Every position shows a particular power of the base (10).

For example :

The decimal number 1567 consists of the digit 7 in the units position, 6 in the tens place, 5 in the hundreds position, and 1 in the thousands place whose value can be written as -

(1×1000) + (5×100) + (6×10) + (7×1)

(1×10³) + (5×10²) + (6×10¹) + (7×1)

1000 + 500 + 60 + 7

1567

Binary Number System (Base 2 Number System) :

The base 2 number system is known as the BINARY NUMBER SYSTEM, wherein, only two binary digits exist, i.e., 0 and 1. Specifically, the usual base-2 is a radix of 2. The figures described under this system are known as binary numbers which are the combination of 0 and 1. For example, 110101 is a binary number.

We can convert any system into binary and vice versa.

For Example, to write (24)₁₀ as a binary number.

Solution:

∴ (24)₁₀ = (11100₎₂

Octal Number System (Base 8 Number System)

Octal numbers are commonly used in computer applications. In the OCTAL NUMBER SYSTEM, the base is 8 and it uses numbers from 0 to 7 to represent numbers. Converting an octal number to decimal is same as decimal conversion and is explained below using an example.

Example: Convert (259)₈ into decimal.

Solution:

  2    1      0

(2     5      9)_{8 =}     

= 2 × 8²  +  5 × 8¹  +  9 × 8⁰

= 2 × 64  +  5 × 8   +  9 × 1

= (177) ₁₀

Hexadecimal Number System (Base 16 Number System)

In the hexadecimal system, numbers are written or represented with base 16. In the hex system, the numbers are first represented just like in decimal system i.e. from 0 to 9. Then, the numbers are represented using the alphabets from A to F. The below-given table shows the representation of numbers in the Hexadecimal Number System.

                                 

            

             

                              

             

5) Decimal Number to Hexadecimal Number :

Q. (234)10 = (?)16

Q. (945)10 = (?)16

Ans. -

(234)10 = (EA)16

(945)10 = (3B1)16

 

6) Hexadecimal  Number to Decimal  Number :

Q. (EA)16 = (?)10

Q. (3B1)16 = (?)10

Ans. -

(EA)16 = (234)10

(3B1)16 = (945)10

   

Note: 10=A, 11=B, 12=C, 13=D, 14=E, 15=F