Microsoft Excel 2007

Microsoft Excel 2007

• Spreadsheet program
• extension: *.xlsx
• Now each sheet contains 16384 columns and 1048576 rows( 17179869184 cells)
• Very easy handling of functions, charts, pivot table and other features.

• Contains ribbon with 7 tabs i.e. Home, Insert, Pagelayout, Data, Formula, Review, View.

Control Menu Shortcuts

Shortcuts for 'window' control buttons: 

Maximize:- Alt+Space Bar+X  

Minimize:- Alt+Space Bar+N 

Close:-   Alt+ Space Bar+C 

Restore:- Alt+Space Bar+R

Shortcuts With MS- Word 2007

1) To chnage font size you can use :

ctrl+[ to Decrease font size by point 1
ctrl+] to Increase font size by point 1

2) Insert --> Page Break

Shortcut Ctrl+ Enter Key

3) Home Tab ---> Editing Group

• Find:- Ctrl+F
• Replace:- Ctrl+ H
• Goto:- Ctrl+ G, Function key F5 is also used for Goto Command
  
• Select All:- Ctrl+A

4) For Paragraph Formatting:

• Left Alignment: Ctrl+L
• Center Alignment: Ctrl+E
• Right Alignment: Ctrl+R
• Justify Alignment: Ctrl+J
  

Domain Name

Domain Name: The "address" or URL of a particular Web site. You can register your own domain name at www.networksolutions.com.

Domain extensions(Domain Codes) vary depending on the site in question:

* COM: An Internet domain used for business or commercial ventures.
* EDU: An Internet domain used for educational facilities.
* GOV: An Internet domain used by the government.
* MIL: An Internet domain used by the military.
* NET: An Internet domain used for network businesses.
* ORG: An Internet domain used for non-profit organizations.

Memory Units: Bits, Bytes, Mega, Giga, Tera

Bits, Bytes, Mega, Giga, Tera
1 bit = a 1 or 0 (b)
4 bits = 1 nybble (?)
8 bits = 1 byte (B)
1024 bytes = 1 Kilobyte (KB)
1024 Kilobytes = 1 Megabyte (MB)
1024 Megabytes = 1 Gigabyte (GB)
1024 Gigabytes = 1 Terabyte (TB)

The smallest amount of transfer is one bit. It holds the value of a 1, or a 0. (Binary coding). Eight of these 1's and zero's are called a byte.

MS Word 2007 Ribbon

There is one RIBBON, which is divided into 7 tabs and then tabs are divided into GROUPS. Like Home Tab contains a group named Font, which contains commands like font, font size, bold, italic, underline, sub script, super script, font color etc.

Another example is Page Layout tab contains a group "Page Set up" includes commands like Margins, page size, orientations, breaks, line numbers.

Microsoft office Word 2007

Introduction to Microsoft office Word 2007

• Start--program files--MS office 2007--Microsoft office Word 2007
  
• Commonly known as Word Processor
  
• Single file is known as Document
  
• Extension: *. docx
  

There is one ribbon which contains 7 tabs in Microsoft office word 2007. The tabs are as follows:

• HOME
  
• INSERT
  
• PAGE LAYOUT
  
• REFERENCE
  
• MAILINGS
  
• REVIEW
  
• VIEW
  

On the top left corner there is one round-button i.e. Office Button which contains almost similar items like File Menu of previous versions.