Showing posts with label Computer Tutorial. Show all posts
Showing posts with label Computer Tutorial. Show all posts

18 Nov 2012

What Are Input Devices?

Computer Devices
Any machine capable of representing information from a computer. This includes display screens, printers, plotters, and synthesizers.

Input Devices
Any machine that feeds data into a computer. For example, a keyboard is an input device, whereas a display monitor is an output device. Input devices other than the keyboard are sometimes called alternate input devices. Mice, trackballs, and light pens are all alternate input devices.
 
Keyboard
A keyboard is the set of typewriter-like keys that enables you to enter data into a computer. Computer keyboards are similar to electric-typewriter keyboards but contain additional keys. The keys on computer keyboards are often classified as follows:
alphanumeric keys -- letters and numbers
punctuation keys -- comma, period, semicolon, and so on.
special keys -- function keys, control keys, arrow keys, Caps Lock key, and so on.
QWERTY, AZERTY, Dvorak and Other Keyboards

The standard layout of letters, numbers, and punctuation is known as a QWERTY keyboard because the first six keys on the top row of letters spell QWERTY. The QWERTY keyboard was designed in the 1800s for mechanical typewriters and was actually designed to slow typists down to avoid jamming the keys. The AZERTY keyboard is the French version of the standard QWERTY keyboard. AZERTY keyboards differ slightly from the QWERTY keyboard.

Another keyboard design, which has letters positioned for speed typing, is the Dvorak keyboard. Unlike the traditional QWERTY keyboard, the Dvorak keyboard is designed so that the middle row of keys includes the most common letters.
Computer Keyboard Standards

There is no standard computer keyboard, although many manufacturers imitate the keyboards of PCs. There are actually three different PC keyboards: the original PC keyboard, with 84 keys; the AT keyboard, also with 84 keys; and the enhanced keyboard, with 101 keys. The three differ somewhat in the placement of function keys, the Control key, the Return key, and the Shift keys.

In addition to these keys, IBM keyboards contain the following keys: Page Up, Page Down, Home, End, Insert, Pause, Num Lock, Scroll Lock, Break, Caps Lock, Print Screen.

There are several different types of keyboards for the Apple Macintosh. All of them are called ADB keyboards because they connect to the Apple Desktop bus (ADB). The two main varieties of Macintosh keyboards are the standard keyboard and the extended keyboard, which has 15 additional special-function keys.

Mouse
A device that controls the movement of the cursor or pointer on a display screen. A mouse is a small object you can roll along a hard, flat surface. Its name is derived from its shape, which looks a bit like a mouse, its connecting wire that one can imagine to be the mouse's tail, and the fact that one must make it scurry along a surface. As you move the mouse, the pointer on the display screen moves in the same direction. Mice contain at least one button and sometimes as many as three, which have different functions depending on what program is running. Some newer mice also include a scroll wheel for scrolling through long documents.

Invented by Douglas Engelbart of Stanford Research Center in 1963, and pioneered by Xerox in the 1970s, the mouse is one of the great breakthroughs in computer ergonomics because it frees the user to a large extent from using the keyboard. In particular, the mouse is important for graphical user interfaces because you can simply point to options and objects and click a mouse button. Such applications are often called point-and-click programs. The mouse is also useful for graphics programs that allow you to draw pictures by using the mouse like a pen, pencil, or paintbrush.

There are three basic types of mice:

Mechanical: Has a rubber or metal ball on its underside that can roll in all directions. Mechanical sensors within the mouse detect the direction the ball is rolling and move the screen pointer accordingly.
Input Devices - Keyboard, Keyboard - An Input Device
Input Devices - Keyboard
Optomechanical: Same as a mechanical mouse, but uses optical sensors to detect motion of the ball.
optical: Uses a laser to detect the mouse's movement. You must move the mouse along a special mat with a grid so that the optical mechanism has a frame of reference. Optical mice have no mechanical moving parts. They respond more quickly and precisely than mechanical and optomechanical mice, but they are also more expensive.

Mice connect to PCs in one of several ways:

Serial mice connect directly to an RS-232C serial port or a PS/2 port. This is the simplest type of connection.
PS/2 mice connect to a PS/2 port.
USB mice.

Cordless mice aren't physically connected at all. Instead they rely on infrared or radio waves to communicate with the computer. Cordless mice are more expensive than both serial and bus mice, but they do eliminate the cord, which can sometimes get in the way.

Trackball Mouse
A pointing device. Essentially, a trackball is a mouse lying on its back. To move the pointer, you rotate the ball with your thumb, your fingers, or the palm of your hand. There are usually one to three buttons next to the ball, which you use just like mouse buttons.

The advantage of trackballs over mice is that the trackball is stationary so it does not require much space to use it. In addition, you can place a trackball on any type of surface, including your lap. For both these reasons, trackballs are popular pointing devices for portable computers.

Lightpen
An input device that utilizes a light-sensitive detector to select objects on a display screen. A light pen is similar to a mouse, except that with a light pen you can move the pointer and select objects on the display screen by directly pointing to the objects with the pen.

5 Nov 2012

What Is Computer?

In this tutorial I will describe about what is computer? As we all are aware that Computer is an electronic device which is used to convert raw data into meaningful infomation. So, I would like to explain about comptuer here. 

Computer
Computer

Definition of Computer: Computer is an electronic device that is designed to work with Information. The term 'computer is derived from the Latin term 'computare', this means to calculate. Computer can not do anything without a Program. It represents the decimal numbers through a string of binary digits. The word 'Computer' usually refers to the Centeral Processor Unit and Internal memory.

Computer is an advanced electronic device that takes raw data as input from the user and processes these data under the control of set of instructions (called program) and gives the result (output) and saves output for the future use. It can process both numerical and non-numerical (arithmetic and logical) calculations. The basic components of a modern digital computer are: Input Device,Output Device,Central Processor. A typical modern computer uses LSI Chips.

Charles Babbage is called the "Grand Father" of the computer. The First mechanical computer designed by Charles Babbage was called Analytical Engine. It uses read-only memory in the form of punch cards.

Four functionalites about computers are:

  1. Accepts Data             Input
  2. Process Data             Processing
  3. Produces Output       Output
  4. Stores Results           Storage
Input (Data):
Input is the raw information entered into a computer from the input devices. It is the collection of letters, numbers, images etc.
 
Process:
Process is the operation of data as per given instruction. It is totally internal process of the computer system.
 
Output:
Output is the processed data given by computer after data processing. Output is also called as Result. We can save these results in the storage devices for the future use.

21 Oct 2012

Microsoft Excel 2007 Shortcuts

In this tutorial, I am going to tell you about Microsoft Excel Shortcuts which will let save lots of time for your family and friends also save your time in office work and in your school projects. In your daily computer work you may be using lots of word, excel or PowerPoint shortcuts. Here, I am going to describe lots of excel shortcuts 2007 that will really make good at working on excel 2007. You can also use these excel shortcuts in other versions of Microsoft Excel.
Excel Shortcuts
Excel Shortcuts
Select the whole column
Selection
CTRL + SPACE

Select the whole row
Selection
SHIFT + SPACE

Select table
Selection
SHIFT + CTRL + SPACE bar

Save
Selection
CTRL + s

Select visible cells only
Selection
ALT + ;

Select entire region
Selection
CTRL + A

Select range from start cell to far left
Selection
SHIFT + Home

Select range from start cell to end in direction of arrow
Selection
SHIFT + End + arrow

Select a continuous range of data (e.g. pivot), no matter where your cursor is.
Selection
CTRL + *

Select blank cells
Selection
F5 + ALT + S + K + ENTER

Select all cells with comments
Selection
CTRL + SHIFT + O

Select all cells that are directly or indirectly referred to by formulas in the selection
Selection
CTRL + SHIFT + {

Select all cells with formulas that refer directly or indirectly to the active cell
Selection
CTRL + SHIFT + }

Selects all the way to a1 from cursor position
Selection
CTRL + SHIFT + HOME

Select cells in the direction of arrow
Selection
CTRL + SHIFT + Arrow

Previous sheet
Navigation
CTRL + Page Up

Next sheet
Navigation
CTRL + Page Down

Launch GO TO Dialog (from here you can select special or jump to a cell or range)
Navigation
F5

Go to top left (will go to top left of freezed pane if set)
Navigation
CTRL + Home

Go to last non-blank cell
Navigation
CTRL + end

Go to previous sheet
Navigation
CTRL + PgUp

Go to next sheet
Navigation
CTRL + PgDn

Print
Navigation
CTRL + p

Toggle between workbooks in a given session of excel.
Navigation
CTRL + TAB

Change the type of cell reference from relative to absolute or semi-absolute
Formulas
F4

Repeat whatever you did last
Formulas
F4

Debug portions of a formula (select and press)
Formulas
F9

Sum range
Formulas
ALT + =

Enter array formula
Formulas
CTRL + SHIFT + Enter

Select array formula range
Formulas
CTRL + /

Display range names (can be used when typing formulas)
Formulas
F3

Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)
Formulas
ALT + TUF

Copy a formula from above cell and edit
Formulas
CTRL + '

Display the formula palette after you type a valid function name in a formula
Formulas
CTRL + A (while writing a formula)

Alternate between displaying cell values and displaying cell formulas
Formulas
CTRL + ` (Single Left Quotation Mark)

Calculate formulas
Formulas
F9

Select all precedent cells
Formulas
CTRL + [

Select all dependent cells
Formulas
CTRL + ]

Format Selection (cells, objects, charts)
Formatting
CTRL + 1

Bold a cell’s content
Formatting
CTRL + B

Format Painter – Paste formats from selection
Formatting
ALT + EST

Format as number with 2 dp
Formatting
CTRL + SHIFT + 1

Format as local currency
Formatting
CTRL + SHIFT + 4

Format as percentage with 0 dp
Formatting
CTRL + SHIFT + 5

Hide row
Formatting
CTRL + 9

Hide column
Formatting
CTRL + 0

Unhide row
Formatting
CTRL + SHIFT + 9

Unhide column
Formatting
CTRL + SHIFT + 0

Display the style command format menu
Formatting
ALT + '

Sets/removes strikeout in current cell
Formatting
CTRL + 5

Show/hide the top bar when you have a group
Formatting
Crtl + 8

Single border around selected cells
Formatting
CTRL + SHIFT + 7

Sort
Formatting
ALT + DS

Insert hyperlink
Formatting
CTRL + K

Freeze panes
Formatting
ALT + WFF

Remove grid lines or (alt+t)ov(alt+g)[enter]
Formatting
ALT + WVG (2007+)

To wrap lines
Formatting
ALT + HW (2007+)

Save as
Excel Options
F12

Collapse the ribbon (press again to expand)
Excel Options
CTRL + F1

Opens print preview
Excel Options
CTRL + F2

Maximize the current window
Excel Options
ALT + SPACE X

Activate next window
Excel Options
ALT + TAB

Activate previous window
Excel Options
ALT + SHIFT + TAB

Close an excel workbook
Excel Options
crtl + F4

Split screens
Excel Options
ALT + W + S

Create a pivot table in new sheet (of course after selecting the range)
Everything Else
ALT + DPF

Create a pivot table in the same sheet.
Everything Else
ALT + DPN

Show visual basic editor
Everything Else
ALT + F11

Macro dialog
Everything Else
ALT + F8

Apply/remove filter
Everything Else
ALT + DFF

Keep filter on columns, but show all rows
Everything Else
ALT + DFS

Insert pivot table
Everything Else
ALT + NVT

Turn filter on or off
Everything Else
CTRL + SHIFT + L

Paste values only
Editing
ALT + ESV

Edit a cell, place cursor at the end
Editing
F2

Show in-cell drop down with previously entered values
Editing
ALT + Down arrow

Fills down value from cell above
Editing
CTRL + D

Add a comment or Edit comment
Editing
SHIFT + F2

Insert new sheet
Editing
SHIFT + F11

Insert row
Editing
CTRL + +

Delete row
Editing
CTRL + -

Copy
Editing
CTRL + C

Paste
Editing
CTRL + V

Cut
Editing
CTRL + X

Undo
Editing
CTRL + Z

Get a line break inside the cell
Editing
ALT + Enter (while editing the cell)

Clear all contents
Editing
ALT + EAA

Copy
Editing
CTRL + insert

Paste
Editing
SHIFT + Insert

Make chart/pivot chart
Editing
F11

Edit a cell in Apple Macs
Editing
CTRL + U

Copy the value from the cell above the active cell into the cell or the formula bar
Editing
CTRL + SHIFT + "

Copies whatever is in the cell to the left of it.
Editing
CTRL + R

Delete box (cell, row, column)
Editing
ALT + ED

Insert box (cell, row, column)
Editing
ALT + IE

Enter current date
Auto Complete
CTRL + ;

Enter current time
Auto Complete
CTRL + :

I hope all these excel 2007 shortcuts help you in your excel work. I hope you will also love all these Microsoft Excel shortcuts. If I left some excel shortcuts here, you can post them in comments and soon I will include them in this tutorial.