Hardware – Software & Excel

Hardware, Software,  Excel,   Hardware  Software, , Excel,  – Misty-Info

HARDWARE

next gen comp

The physical part of the computer is called hardware or we can say that the touchable part of the computer is called hardware.

There are two types of device categories comes under the hardware.

  • INPUT DEVICES
  • OUTPUT DEVICES

 

DEFINATION OF INPUT DEVICE

 

That devices which helps a user to enter the data in to the computer is called input devices.

 

There are two types of devices categories comes under the input devices.

  • Text input devices
  • Pointer input devices

 

 

TEXT INPUT DEVICES

 

Those devices which are used only to enter the text data in to

the computer is called text input devices.

 

POINTER INPUT DEVICES                         

 

Those devices which works on by click and used to point something is called pointer input devices for e.g. mouse, joystick etc.

 

OUTPUT DEVICES

That device which is used to take output. If the given input is called output devices the most common input devices in the computer system is “MONITOR” monitor is also known as VDU (visual display unit).

 

next gen comp

Hardware, Software,  Excel,   Hardware  Software, , Excel,  – Misty-Info

 

 SOFTWARE

 

The non touchable part of the computer is known as software.

Software is mainly of three types.

 

  • System software eg (Ms- Office)
  • Application software eg (Paint, Ms-word)
  • Utility software eg (Games, Anti-virus)

 

How many types of data?

  • Alphabetic data = A to Z
  • Numeric data = 0 to 9
  • Alphanumeric data = +, _

 

Which device looks like a typewriter?

Keyboard

 

Which is the largest key in the keyboard?

Spacebar key

 

UNITS         EQUIVALENT

 

1 Bit =         0, 1

1 Byte =        8 bit

1 Kilo byte = 1024 bits

1Mega byte  = 1024 K.B

1 Giga byte  = 1024 M.B

1 Tera byte  = 1024 G.B

1 Peta byte  = 1024 T.B

Hardware, Software,  Excel,   Hardware  Software, , Excel,  – Misty-Info

next gen comp

EXCEL

Column

Row

Worksheet

COLOUMN

Total colomn in a single sheet = 256

 Width of a colomn by default =8.46

Maximum width of a colomn = 255

Minimum width of  a colomn = 0

Go first line to last colomn = Ctrl+right arrow key

Go last to first colomn = Ctrl +left arrow key

Colomn is denoted by alphabets (A, B, C)

Its position is vertical.

ROWS

 

Total no. of rows in a single sheet =65536

 

 

Height of a single row by default = 12.75

Maximum height of a row = 409

Minimum height of a row = 0

Row is denoted by numerical (1,2,3……)

Go first to last row = Ctrl+down arrow key

Go last to first row = Ctrl +up arrow key

Hardware, Software,  Excel,   Hardware  Software, , Excel,  – Misty-Info

WORKBOOK

 

Group of sheets called workbook. By default there is 3 sheets in a workbook.

 

Maximum sheets insert in a workbook = 255

Minimum sheets insert in a workbook = 1

Range of a row in a page in portrait size by default = 1 to 51

Range of column in a page in portrait size by default = A to I

 

 

EXTENSIONS

 

Excel = .xls

Paint = .bmp (bitmap image)

Notepad = .txt (text editor)

Wordpad = .rtf (rich text format)

Ms-word = .doc (document)

Powerpoint = .ppt (PowerPoint presentation)

Hardware, Software,  Excel,   Hardware  Software, , Excel,  – Misty-Info

For this person whose like our website Please    Donate ….

 

 

Leave a Reply

error: This Plugins Block Your IP Address so don\\\'t copy