Monday, March 31, 2008

DHCP

DEFINITION - DHCP (Dynamic Host Configuration Protocol) is a communications protocol that lets network administrators centrally manage and automate the assignment of Internet Protocol (IP) addresses in an organization's network. Using the Internet Protocol, each machine that can connect to the Internet needs a unique IP address, which is assigned when an Internet connection is created for a specific computer. Without DHCP, the IP address must be entered manually at each computer in an organization and a new IP address must be entered each time a computer moves to a new location on the network. DHCP lets a network administrator supervise and distribute IP addresses from a central point and automatically sends a new IP address when a computer is plugged into a different place in the network.

DHCP uses the concept of a "lease" or amount of time that a given IP address will be valid for a computer. The lease time can vary depending on how long a user is likely to require the Internet connection at a particular location. It's especially useful in education and other environments where users change frequently. Using very short leases, DHCP can dynamically reconfigure networks in which there are more computers than there are available IP addresses. The protocol also supports static addresses for computers that need a permanent IP address, such as Web servers.

DHCP is an extension of an earlier network IP management protocol, Bootstrap Protocol (BOOTP). DHCP is a more advanced protocol, but both configuration management protocols are commonly used and DHCP can handle BOOTP client requests. Some organizations use both protocols, but understanding how and when to use them in the same organization is important. Some operating systems, including Windows NT/2000, come with DHCP servers. A DHCP or BOOTP client is a program that is located in (and perhaps downloaded to) each computer so that it can be configured.
Blogged with the Flock Browser

Thursday, March 6, 2008

SHORT CUT MS-EXCEL


  
Ctrl+A
Select All
None
Ctrl+B
Bold
Format, Cells, Font, Font Style, Bold
Ctrl+C
Copy
Edit, Copy
Ctrl+D
Fill Down
Edit, Fill, Down
Ctrl+F
Find
Edit, Find
Ctrl+G
Goto
Edit, Goto
Ctrl+H
Replace
Edit, Replace
Ctrl+I
Italic
Format, Cells, Font, Font Style, Italic
Ctrl+K
Insert Hyperlink
Insert, Hyperlink
Ctrl+N
New Workbook
File, New
Ctrl+O
Open
File, Open
Ctrl+P
Print
File, Print
Ctrl+R
Fill Right
Edit, Fill Right
Ctrl+S
Save
File, Save
Ctrl+U
Underline
Format, Cells, Font, Underline, Single
Ctrl+V
Paste
Edit, Paste
Ctrl W
Close
File, Close
Ctrl+X
Cut
Edit, Cut
Ctrl+Y
Repeat
Edit, Repeat
Ctrl+Z
Undo
Edit, Undo
F1
Help
Help, Contents and Index
F2
Edit
None
F3
Paste Name
Insert, Name, Paste
F4
Repeat last action
Edit, Repeat. Works while not in Edit mode.
F4
While typing a formula, switch between absolute/relative refs
None
F5
Goto
Edit, Goto
F6
Next Pane
None
F7
Spell check
Tools, Spelling
F8
Extend mode
None
F9
Recalculate all workbooks
Tools, Options, Calculation, Calc,Now
F10
Activate Menubar
N/A
F11
New Chart
Insert, Chart
F12
Save As
File, Save As
Ctrl+:
Insert Current Time
None
Ctrl+;
Insert Current Date
None
Ctrl+"
Copy Value from Cell Above
Edit, Paste Special, Value
Ctrl+’
Copy Fromula from Cell Above
Edit, Copy
Shift
Hold down shift for additional functions in Excel’s menu
none
Shift+F1
What’s This?
Help, What’s This?
Shift+F2
Edit cell comment
Insert, Edit Comments
Shift+F3
Paste function into formula
Insert, Function
Shift+F4
Find Next
Edit, Find, Find Next
Shift+F5
Find
Edit, Find, Find Next
Shift+F6
Previous Pane
None
Shift+F8
Add to selection
None
Shift+F9
Calculate active worksheet
Calc Sheet
Shift+F10
Display shortcut menu
None
Shift+F11
New worksheet
Insert, Worksheet
Shift+F12
Save
File, Save
Ctrl+F3
Define name
Insert, Names, Define
Ctrl+F4
Close
File, Close
Ctrl+F5
XL, Restore window size
Restore
Ctrl+F6
Next workbook window
Window, ...
Shift+Ctrl+F6
Previous workbook window
Window, ...
Ctrl+F7
Move window
XL, Move
Ctrl+F8
Resize window
XL, Size
Ctrl+F9
Minimize workbook
XL, Minimize
Ctrl+F10
Maximize or restore window
XL, Maximize
Ctrl+F11
Inset 4.0 Macro sheet
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro
Ctrl+F12
File Open
File, Open
Alt+F1
Insert Chart
Insert, Chart...
Alt+F2
Save As
File, Save As
Alt+F4
Exit
File, Exit
Alt+F8
Macro dialog box
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions
Alt+F11
Visual Basic Editor
Tools, Macro, Visual Basic Editor
Ctrl+Shift+F3
Create name by using names of row and column labels
Insert, Name, Create
Ctrl+Shift+F6
Previous Window
Window, ...
Ctrl+Shift+F12
Print
File, Print
Alt+Shift+F1
New worksheet
Insert, Worksheet
Alt+Shift+F2
Save
File, Save
Alt+=
AutoSum
No direct equivalent
Ctrl+`
Toggle Value/Formula display
Tools, Options, View, Formulas
Ctrl+Shift+A
Insert argument names into formula
No direct equivalent
Alt+Down arrow
Display AutoComplete list
None
Alt+’
Format Style dialog box
Format, Style
Ctrl+Shift+~
General format
Format, Cells, Number, Category, General
Ctrl+Shift+!
Comma format
Format, Cells, Number, Category, Number
Ctrl+Shift+@
Time format
Format, Cells, Number, Category, Time
Ctrl+Shift+#
Date format
Format, Cells, Number, Category, Date
Ctrl+Shift+$
Currency format
Format, Cells, Number, Category, Currency
Ctrl+Shift+%
Percent format
Format, Cells, Number, Category, Percentage
Ctrl+Shift+^
Exponential format
Format, Cells, Number, Category,
Ctrl+Shift+&
Place outline border around selected cells
Format, Cells, Border
Ctrl+Shift+_
Remove outline border
Format, Cells, Border
Ctrl+Shift+*
Select current region
Edit, Goto, Special, Current Region
Ctrl++
Insert
Insert, (Rows, Columns, or Cells) Depends on selection
Ctrl+-
Delete
Delete, (Rows, Columns, or Cells) Depends on selection
Ctrl+1
Format cells dialog box
Format, Cells
Ctrl+2
Bold
Format, Cells, Font, Font Style, Bold
Ctrl+3
Italic
Format, Cells, Font, Font Style, Italic
Ctrl+4
Underline
Format, Cells, Font, Font Style, Underline
Ctrl+5
Strikethrough
Format, Cells, Font, Effects, Strikethrough
Ctrl+6
Show/Hide objects
Tools, Options, View, Objects, Show All/Hide
Ctrl+7
Show/Hide Standard toolbar
View, Toolbars, Stardard
Ctrl+8
Toggle Outline symbols
<

Blogged with the Flock Browser