indian tutor ms office tutorials

Type Here "What Are You Looking For"?

shortcut to open Different application of Ms-office with Run Command

shortcut to open Different application of Ms-office with Run Command

Shortcut to open Different applications of Ms-office with Run Command



press window key with R or go to start menu and select RUN option from right hand side .

you will see a run command dialog box type there then you can press ok,cancel or browse

  • Ms-Word : Type winword in the Run Dialog Box
  • Ms-Excel:  Type excel in the Run Dialog Box
  • Ms-Powerpoint: Type powerpnt .

...
Parts of C.P.U

Parts of C.P.U

Parts of C.P.U

C.P.U  is Central Processing Unit, It has 3 man parts:

  • ALU(Arithmetic and Logic Unit): This unit carries out all mathematical and logical operations.

  • CU(Control Unit): This unit controls the transfer of information form one part of the C.P.U to the other.

  • MU(Memory Unit): This unit stores the data in the computer.


...
Why we say Centrally processing unit not controlling unit to C.P.U???

Why we say Centrally processing unit not controlling unit to C.P.U???

Why we say Centrally processing unit not controlling unit to C.P.U???


C.P.U: The full form of C.P.U is Central Processing Unit not Control Processing Unit although we all know that the C.P.U is the brain of the computer.This is where the computer does all its Processing work.It is very important hardware device. It controls all the working

but the Reason Behind Central Processing Unit is that:

computers works in three steps that is I.P.O.
  1. input
  2. processing
  3. output
first we have to give input to the system to work upon then the system goes it in its 2nd stage that is processing which is done by C.P.U and after processing done by c.p.u it further forwarded to the monitor to display or we can say for output 
as monitor is an output device.


...
Selecting text with the Keyboard

Selecting text with the Keyboard

Selecting text with the Keyboard

  • One word: Place the cursor at one end of the word.Then press Shift, and move the cursor with the help of the arrow keys to the other end of the word.
  • More than one word: Similar to selecting one word.
  • More than one line: After selecting one line, keep pressing the Down arrow key along shift key.
  • Whole document (entire text): Press Ctrl+A

...
Selecting text with the Mouse

Selecting text with the Mouse

Selecting text with the Mouse

  • One Word: Double-click on the word.
  • More than one word: Click and drag the mouse till the end of the text.
  • More than one line: Click and drag the mouse up or down.
  • Paragraph: Triple-Click on the first word of the paragraph.
  • Selecting a range: Place the cursor at the end, press Shift, and click at the beginning.

...
Keyboard

Keyboard

Keyboard

Computer receives most of its input from the user via keyboard that is very similar to a typewriter.

Keys:

Backspace Key: Deletes the character just to the left of the cursor and moves the cursor to that position.

Delete Key: Deletes the character at the current cursor position or to the right of the insertion point or deletes the selected content.

Arrow Key: Four Arrows keys for moving the cursor or insertion point right,left,up or down.Moving the arrow keys doesn't delete any character on the screen.

Caps Lock Key: A toggle key that, when activated ,causes all alphabetic character to be uppercase.

Home Key: Moves the cursor to the top left corner of the screen or tho the beginning of the file.

End Key: Moves the cursor to the end of the line, the of page.

Enter: Used to enter commands or to move the cursor to the beginning of the next line.

Esc: Short for Escape. This key is used to send special codes to the device or to exit.

Function Key: Special keys labeled F1 to F12 each key perform different functionality according to the application we are using.

Ctrl Key: Short for control.This key is used in conjunction with other keys to produce control characters.

Alt Key: Short for Alternate. Same as Control key.

Pageup and Pagedown: Moves the cursor up of down and abbreviated as PgUp or PgDn.

Numeric Keypad: A separate set of keys on some keyboards that contain the numbers 0 to 9 and decimal with some operators like
+,-,*,/.

to use from this area Num Lock Must Be ON.


...
BookMark

BookMark

BOOKMARK

Bookmark is a tool that helps to identify or locate us to the position where we set our Bookmark in a document to reach the same position where we stop our work.

How to Apply :
Set your cursor position and go to insert menu select bookmark option and save your bookmark 

Next time if you wish to go to that position go to home menu in the right hand side ending of the ribbon you will see editing option or press Ctrl+G
Select GoTo option from the three(Find,Replace, GoTo) 
Drop down the list till you get the bookmark option.
Type your Bookmark name you have saved earlier. 

Then your cursor will be start blinking on that position where you have set your cursor earlier.


...
Hyperlink(Ctrl + K)

Hyperlink(Ctrl + K)

HYPERLINK

Hyperlink is a technique by which we can make a bunch of related files by applying link on any file to reach another file bye just hitting a click with a conjunction with a control key i.e. Ctrl.

HOW TO APPLY:
This option comes in insert menu 
  • Open any file and select the content , word, image, table, etc. to which you wanted to elaborate or explain better

  • Then go to Hyperlink it will show you the files to select then save your file/document 

You will see the content will change into Blue-Color with an underline.
When you move around the cursor on that portion you will see your pointer change into  Hand tool shape and a message showing to follow "Ctrl + Click"

then you will be on the document you have set earlier.


...
Cover Page,Page Break,Blank Page

Cover Page,Page Break,Blank Page

COVER PAGE,PAGE BREAK,BLANK PAGE

 All options comes in the menu of Insert


  • COVER PAGE: It gives a attractive starting to your document.By custom setting you can edit the cover page and it is automatically comes to the First Page. 
  • Page Break: It breaks your page into two parts according to cursor position content will be shifted to the another page.
  • Blank Page: It gives a blank page whee the cursor is blinking.
suppose you are making a file and forgot to add one page, set the position of the cursor and go to insert menu from left hand side you can select Blank Page, Now you can edit any thing in that page.


...


Clip Art

Clip Art

CLIP ART

A small size of image provided by the ms-word(office package)
when you click on Clip Art option you will see a Dialog box appear on the right hand side showing various options.


How to set a Clip ART into your Doc?
Steps:

  • Start any application of Ms-office
  • then go to insert menu
  • select clip art option
  • you will see a search option in your right hand side area
  • type the english words like, computer,building,animal,nature,celebrations,etc
  • then hit on Go
  • you will see many result, click on any image you want to have on your screen(make sure you set the position of the cursor)

Cursor position is very important while you insert any clip art



In case your system is not providing the pictures you entered the name into search box then
select "Organize Clips" then click on office collection you will get lots of options to choose
but if you want to set the images from using this option then you have to copy image by using right click on that image 
and paste it in the document area.
...
Drop Cap

Drop Cap

Drop Cap

Drop Cap is a tool by which we can make our text's first character to be uppercase.

Drop means how many lines you want to skip for...as in the given box "A" has dropped 3 lines.
How to apply?
Steps:
  • Firstly wright what you want to
  • then go to insert menu there you see a option of Drop Cap
  • Click on Drop cap you see DROP CAP Option where you can easily select Dropped or In Margin
  • If you selected the Dropped one you have to set the font face for text,how many lines you wanted to drop/skip and distance from the text.then ok

Drop Cap dialog box

...


BIT,BYTE,KB,MB,GB,TB???

BIT,BYTE,KB,MB,GB,TB???

BIT,BYTE,KB,MB,GB,TB???

THESE ALL ABOVE ARE THE MEASURING SYMBOL OF THE CAPACITY CONSUMED BY ANY ELECTRONIC DEVICE.THESE ARE:

  1. BIT
  2. BYTE
  3. KILOBYTE(KB)
  4. MEGABYTE(MB)
  5. GIGABYTE(GB)
  6. TERABYTE(TB)

"BIT" IS A SMALLEST UNIT.IT REPRESENTS THE VALUE OF 1 AND 0(BINARY NUMBERS).
1 BIT= 1 OR 0

"BYTE" IS GREATER THAN BIT AND EQUALS TO 8 BITS.
1 BYTE = 8 BITS

"KILOBYTE" IS GREATER THAN BYTES AND EQUALS TO 1024 BYTES.
1 KB = 1024 BYTES

"MEGA BYTES" IS A GREATER UNIT THAN KILOBYTES AND EQUALS TO 1024 KILOBYTES
1 MB = 1024 KILOBYTES

"GIGABYTE" IS  GREATER THAN MEGABYTES AND EQUALS TO 1024 MEGABYTES.
1 GB = 1024 MEGABYTES

"TERABYTE"IS THE LARGEST UNIT TO COUNT AND EQUALS TO 1024 GIGABYTES.
1 TB = 1024 GIGABYTES

FOR e.g. WHEN YOU UPLOAD ANY IMAGE OR DOCUMENT THERE MUST BE SOME GUIDELINES WHERE THE SIZE HAS BEEN MENTIONED AND WE HAVE TO FOLLOW...
according to different sizes 
...
List of Words from A-Z

List of Words from A-Z

A to Z

LIST OF WORDS ABOUT COMPUTERS


TERM
MEANING
Absolute Address
Exact data memory location
ActiveX
Tools to link applications to the web
Adware
Software supported by advertisements
Analog
Data represented by a continuous signal or information
Applet
A Java program embedded in web page
Archie
A program to find files on FTP servers
Avatar
A character representing an internet user
Backbone
Network mainline carrying data to smaller lines
Bandwidth
Amount of data sent through network
Bit
Smallest piece of information, that is, either 1 or 0
Bluetooth
A short range wireless technology to connect electronic devices
Boot
To start a computer
Byte
Sequence of information bits, which equals 8 bits
Cache
Technically classifying, it stores recently visited web addresses, web pages in hard disk/RAM/near processor, depending on cache types, for fast retrieval
Captcha
Response test that shows if the user is human or not
Centronics
36 pin parallel interface standard
Computer
A machine that computes and is programmable
Cookie
It is an internet term where the web server sent data records your activities on websites. Some websites record & remember information like your username and password, so you don’t have to type them again.
Crop
Removing part of an image or photo
Cyber Bullying
Harassing or threatening the young via cyberspace
Cyber Squatter
Someone registering a domain name (without web pages) to sell it
Default
When a user does not specify a setting, a preset value is used
Degauss
Removing magnetism from a device
Digital
Data represented in a series of zeros and ones
DirectX
Mostly used in video games, it is a set of commands
Domain
Network and computers connected to internet
Domain Name
Website name
Driver
A file that aids computer to connect with the hardware device
Dual-Core
A CPU that has 2 processors in a chip
Embed
Adding something from one document to another
Emoticons
Text based faces/objects
Encryption
Conversion of data into unreadable state
Ethernet
A networking connection that uses coaxial cables
Exabyte
Unit of data storage equalling to 2 to 60th power bytes
Fiber Optic
Transmits information faster than copper wire
File Sharing
Way of giving same file to many users by one server
Firewire
High speed interface for connecting digital/electronic players to computers
Firmware
Software programmed into hardware
Flash Drive
Data storage device with less units
Gigabyte (GB)
Equals 1024 megabytes
Gigahertz
Measurement for computer processing speed. 1 gigahertz =1000 megahertz
Gnutella
Internet file sharing network
Golden Master
Final version of software program sent to make retail copies
Hacker
A sly person who gains illegal access to other people’s computers
Hard Copy
A document that is printed
Hardware
Internal and external physical parts of a computer system
Heat Sink
A metal alloy that absorbs heat from the processor
Host
A network computer that acts as a server to other computers
Icon
A tiny display representing files and folders
Infrared
Red light invisible to naked eye and used in some wireless devices
Integrated Circuit
A semiconductor chip
Internet
A super highway network that connects smaller networks
Intranet
Internal network within an organisation
IP Address
It is internet protocol numbers ranging from 0 to 255 and separated by 3 dots. It is assigned to a computer connected to internet by Internet Service Provider (ISP).
Iteration
Program process repetition
JavaScript
A scripting language developed by Sun Microsystems
Joystick
A device consisting of base and stick used in video games
Jumper
Metal bridge to close electrical circuit
Kerberos
Used to give secure network authentication
Kernel
The foundation layer of an operating system
Keygen
Key generator that automatically generates  a registration or serial #
Keylogger
Keystrokes recording program that could be used by a hacker to find out passwords
Kibibyte (KiB)
Exact units of 1024 bytes
Kilobyte (KB)
Estimated 1000 bytes or 1024 bytes depending on the content in use. Hence, kilobyte has ambiguous units.
LAN
Local area network that covers a small area
Leaf
A file in hard disk
Limewire
A free software that allows network users to share files
Linkedin
Business social networking site
Linux
Operating system developed by Linus Torvalds. It is a popular OS for hosting web servers.
Macro
A command/script in form of a key or symbol
Mainframe
Big powerful computer processing mammoth volume at high speed
Malware
Programs like virus & Trojan intended to damage computers
Media
Data storage hardware like DVD, CD, HD
Meta Tag
Tool to store details like keywords & contents of a web page
Memory Stick
Sony’s flash memory cards
Name Server
Web domain is referred to IP address by name server
Nanosecond
A billionth of a second
Network
A system of connected computers that send and receive data
Node
Anything connected to a network
Null Value
Something that has no value in programming
Offline
State of computer devices that are neither turned on nor connected
Online
State of computer devices that are turned on and connected
Operating System(OS)
The significant program that runs the computer hardware
Oracle
Database management program developed by Oracle Corporation
Overclock
Technique to run a microprocessor faster than intended
Packet
Amount of data sent from source to destination
Path
Address of file
Peer to Peer (P2P)
Connected workstations sharing files without a central server
Peripheral
Any device attached to computer externally
Phishing (i.e. Password harvesting fishing)
Attempting to garner personal information via emails that seem genuine from banking and popular websites
Primary Key
A value that mainly identifies a record in a table
Quad-Core
CPU having 4 separate processors in a chip
Query
Request of a database in computer
Queue
Series of tasks waiting to be done by programs
QWERTY
Denotes standard keyboard because Q,W,E,R,T,Y keys are side by side in the upper left row
Random Access Memory (RAM)
Memory cells that make up memory module. Data is always loaded from hard disk to RAM since it is faster to read from it. The best method to make your computer work faster is to increase its RAM.  
Raw Data
Data that is not processed
Read-only Memory (ROM)
Memory storing hardware information that is not lost when power is turned off
Real Time
The moment, data is received, it is processed
Reboot
To restart
Registry
Database storing set up, software and hardware configuration information in Windows OS
Router
A device connecting one local area network to another
Script
A series of commands performed by a program
Serial Port
Interface or connection to peripherals
Server
Mainframe computer that serves other attached computers
Shadowing
Method of using high speed RAM to make computer to work faster
Simplex
Circuit that can either transmit or receive
Software
A code or program that is read by computer
Spam
Unnecessary emails
Static
Non interactive web page
System
Comprehensive inclusion of hardware, software & firmware items
Terabyte (TB)
One trillion bytes
Terminal
An internet computer screen
Throughout
Data amount processed in a given time
Topology
Physical and logical set up of a network
Trojan
Dangerous virus loaded deceptively through a host program
Undo
A command to cancel previous action
Universal Resource Locator (URL)
Another term for internet address
Universal Serial Bus (USB)
Computer port that is faster
Unix
Web server operating system developed by AT & T
Upload
To transfer files from local computer to web server/network
Virtual Memory
Memory generated by  hard disk sectors when RAM is full
Virtual Reality
Computer created illusion of reality
Virus
A code or program designed to replicate and damage computers
Wave
Microsoft’s waveform sound format
Weblog
A personal journal or blog on the web
Workstation
Any computer attached to internet
X2
Technology to send higher data rates on old phone system
XMS(Extended Memory Specification)
Procedure for using extended memory & area  of disk operating system (DOS)
Y2K
Year 2000; the predicted Millennium Bug that flopped
Yottabyte (YB)
Largest data storage unit, i.e. 1,000,000,000,000,000,000,000,000 bytes
Zero Day Exploit
Computer security loophole issue & attack on it are known on same day. Zero day left to release patch to fix it.
Zettabyte (ZB)
1,000, 000, 000, 000, 000, 000, 000 bytes
Zipping
Compressing files to save space
Zune
Digital music entertainment developed by Microsoft




...

Bullets or Numbering

Bullets or Numbering

Bullets or Numbering


Bullets or Numbering is applied when you are categorising some points
e.g.
suppose you have to tell the number of subjects you are studying in a semester
you can type your content like

mathematics
political science
english
hindi

 after typing above subjects you can select your content then go to home menu there you see a in a paragraph option there are some dots and numbering these are the bullets you wanted to apply .
it has a range or you can edit any bullet .

after applying bullets your content will be:

  • mathematics
  • political science
  • english
  • hindi

...

What is Alignment

What is Alignment

Alignment

Alignment is a tool by which you can adjust your text in a document to the left side, right side or to the center.

Short Keys:
ctrl + L for left text alignment
ctrl + R for right text alignment
ctrl + E for center alignment of the text


you can apply this after selecting your text with the help of mouse(left mouse button) or keyboard(shift + arrow keys).


...

Popular Posts

Labels

? (1) 1 BIT equals to (1) 3g (1) alignment (1) ALU (1) amr (1) apply watermark (1) avi (1) backspace key (2) BIT (1) blank page (1) bmp (1) bold (1) brain of computer (1) bullets or numbering (1) BYTES (1) c.p.u (1) calendar (1) caring of cd and dvd (1) caring of computer and other important components (1) cdma (1) central unit (1) change case (1) change case in ms-word 2007 (1) change icon in vista o/s. (1) change icon in windows xp (1) clip art (2) Computer Definition (1) cover page (1) CPU (1) ctrl+A (1) Ctrl+B (1) Ctrl+G (1) Ctrl+I (1) ctrl+k (1) Ctrl+U (1) CU (1) customize desktop in vista-ultimate (1) customize desktop in windows xp (1) delete key (2) drop cap (1) excel short keys (2) external devices (1) F1 (1) first letter Capital (1) folder (1) formatting toolbar (2) full form of computer (1) full form of cpu (1) full form of keyboard (1) full form of mouse (1) full form of ups (1) function keys (2) GB (1) GB or MB (1) gif (1) GoTo (1) gsm (1) hardware devices (1) help icon (1) how to boot into safe mode in windows xp (1) how to start windows xp in safe mode (1) how to start/turn off computer (2) howtousemicrosoftoffce (1) html (1) http (1) hyperlink (1) icons (2) insert menu (6) ip (1) ipo (1) isha wadhwa (1) italic (1) jar (1) jpeg (1) KB (1) keyboard (1) left alignment (1) link (1) modem (1) MU (1) my first blog (1) numlock (1) office collection (1) options of insert menu (3) page border (1) page break (1) page color in ms-word 2007 (2) page layout (2) parts of c.p.u (1) password (1) peripheral devices (1) Powerpoint run command (1) print screen (1) protect (1) reason behing central unit (1) remove watermark (1) rts (1) safe mode (1) select all (1) selecting text with keyboard (1) selecting text with mouse (1) short keys (4) shortcut Ms-Word (1) sim (1) small images (1) start button (1) swf (1) systemtray (1) table (1) taskbar (1) TB (1) title bar (1) toggle case (1) umts (1) underline (1) url (1) usb (1) use of printScreen (1) virus (1) watermark (1) what are icons (1) what is Bit (1) what is byte (1) What is KB (1) what is MB (1) what is smallest unit (1) wifi (1) window +R (1) window R (1) windows (1) windows short keys (3) word art (1)