Shortcut Keys For Microsoft Exel

Here are some of the shortcut keys which are useful while working with Microsoft Excel.

• F1 Key Help
• F2 Key Edit current Cell
• F5 Key Goto
• F7 Key Spell Check
• F12 Key Save file as
• CTRL and A Select entire worksheet.
• CTRL and B Toggle Bold Text.
• CTRL and C Copies the item or items selected to the Clipboard and can be pasted using CTRL and V.
• CTRL and F Displays the Find dialog box.
• CTRL and H Displays the Replace dialog box.
• CTRL and I Toggles Italic Text.
• CTRL and N New File.
• CTRL and O Open File.
• CTRL and P Print.
• CTRL and S Save File.
• CTRL and U Toggles Underlined Text.
• CTRL and V Paste the contents of the clipboard.
• CTRL and X Cut the selected item.
• CTRL and Y Redo the last undone action
• CTRL and Z Undoes the last action.
• CTRL and 1 Displays Format Cells Dialogue Box
• CTRL and 5 Toggles Strikethrough Text

Keyboard Shortcuts Result in Excel 2000 – Formulas

• ALT and = Autosum
• ALT and F8 Macros
• CTRL and ; Insert Current Date
• CTRL and : Insert Current Time

Keyboard Shortcuts Result in Excel 2000 – Movement

• Left Arrow One Cell Left (also SHIFT and TAB)
• Right Arrow One Cell Right (also TAB)
• Up Arrow One Cell Up
• Down Arrow One Cell Down
• Home Go to End of row
• CTRL and left Arrow Go to End of Column
• CTRL and Home Go to Top of Worksheet (A1)
• CTRL and End Go to End of Worksheet
• CTRL and PAGE-DOWN Go to Next Worksheet

Keyboard Shortcuts Result in Excel 2000 – Cell Selection

• CTRL and Spacebar Select the entire Column
• SHIFT and Spacebar Select the entire Row
• CTRL and A Select Entire Worksheet
• SHIFT and Left Cursor Select all cells to the left of the active one
• SHIFT and Right Cursor Select all cells to the right of the active one

Download Lavasoft Ad-Aware Se Personal + Defination

Ad-aware SE Personal Edition boasts a number of improvements. Extended memory scanning now scans all modules loaded by a process. Scanning uses the all- new CSI (Code Sequence Identification) technology to identify new and unknown variants of known targets. Extended registry scanning now scans registry branches of multiple-user accounts and performs additional smart checks to detect dynamically created references. Scanning speed is noticeably faster, and this version offers an Extended Scanning mode for known and unknown/possible browser hijackers.

Download : def

Download: Ad-Aware Se

Some File Format Defination to Know

Here are some computer file format which you must know basically …..

ISO:
A file that is created from an image of a CD. You can make an iso yourself with a program such as Adaptec Easy CD Creator, or you can burn an ISO file to a CD-R to create a copy of a CD.

Bin/cue files:
These are also used to create an image of a CD. Most people burn these with CdrWin or Fireburner. The .bin file contains all the data for the cd, the .cue file is just a small file in text format telling the software exactly how to burn the data onto the CD.

MP3:
Don’t know what these are? What cave have you been you living in? This is a format used to compress music files. You can create your own by encoding .wav files ripped from audio CDs. There are many free players that will play mp3s for you (see the Winamp tutorial)

Ace files:
These are used to compress/archive data. Use WinAce to decompress them, or to make your own. The normal format for ace files is to have .ace, .c01, .c01, etc.

Rar files:
Another compression/archive format. This is most commonly used on iso or bin files in order to split them up into smaller files (15 MB is the norm). Winrar and many other utilities can decompress these. Rar files are usually in the format .rar, .r01, .r02, etc. But don’t be surprised if you don’t see a .rar file. Just open up winrar and point it to .r01. You also may see them packed as .001, .002, etc. (maybe with a .rar, maybe not)

Pub:
This is an FTP that has left on anonymous access. Many are owned by large companies, so they have a lot of bandwidth. This makes it possible for one person to send files there and many people can download them at once =) These are found by scanning ranges of ips (see the FTP tutorial). Just remember, like the name says, these are public. Just because you upload something there or make directories with your name does not make it ‘your pub’. At the same time, realize that if you come across a pub with another person/groups stuff on it that it may be in use to build other pubs from – so don’t ruin it for many people by deleting stuff you find there. For more on this, go read some posts on our Bulletin Board.

Proxy:
A system that is set up to forward packets… There are many different kinds, check out the proxy tutorial for more info. Basically, a proxy server helps cover up your tracks because you connect to remote computers through the proxy. Think of it as the condom of the Internet

SFV Files/ CRC Checks:

SFV files contain information about files that they accompany. You can preform a CRC check on the files using a program such as WinSFV. This compares the information in the SFV file to the file itself. If the information doesn’t match, then the file was probably messed up in transfer somehow.. try downloading it again, from a different source if possible.