Saturday, September 10, 2016

Mac keyboard shortcuts



By pressing a combination of keys, you can do things that normally need a mouse, trackpad, or other input device.

To use a keyboard shortcut, hold down one or more modifier keys while pressing the last key of the shortcut. For example, to use the shortcut Command-C (copy), hold down Command, press C, then release both keys. Mac menus and keyboards often use symbols for certain keys, including the modifier keys:

    Command ⌘
    Shift ⇧

    Option ⌥
    Control ⌃

    Caps Lock ⇪
    Fn


If you're using a keyboard made for Windows PCs, use the Alt key instead of Option, and the Windows logo key instead of Command. Some Mac keyboards and shortcuts use special keys in the top row, which include icons for volume, display brightness, and other functions. Press the icon key to perform that function, or combine it with the Fn key to use it as an F1, F2, F3, or other standard function key.

To learn more shortcuts, check the menus of the app you're using. Every app can have its own shortcuts, and shortcuts that work in one app may not work in another.

Cut, copy, paste, and other common shortcuts
          Shortcut               Description
Command-X     Cut: Remove the selected item and copy it to the Clipboard.
Command-C     Copy the selected item to the Clipboard. This also works for files in the Finder.
Command-V     Paste the contents of the Clipboard into the current document or app. This also works for files in the Finder.
Command-Z     Undo the previous command. You can then press Command-Shift-Z to Redo, reversing the undo command. In some apps, you can undo and redo multiple commands.
Command-A     Select All items.
Command-F     Find: Open a Find window, or find items in a document.
Command-G     Find Again: Find the next occurrence of the item previously found. To find the previous occurrence, press Command-Shift-G.
Command-H     Hide the windows of the front app. To view the front app but hide all other apps, press Command-Option-H.
Command-M     Minimize the front window to the Dock. To minimize all windows of the front app, press Command-Option-M.
Command-N     New: Open an new document or window.
Command-O     Open the selected item, or open a dialog to select a file to open.
Command-P     Print the current document.
Command-S     Save the current document.
Command-W     Close the front window. To close all windows of the app, press Command-Option-W.
Command-Q     Quit the app.
Option-Command-Esc     Force Quit: Choose an app to force quit. Or press Command-Shift-Option-Esc and hold for 3 seconds to force just the front app to quit.
Command–Space bar     Spotlight: Show or hide the Spotlight search field. To perform a Spotlight search from a Finder window, press Command–Option–Space bar. If you use multiple input sources to type in different languages, these shortcuts change input sources instead of showing Spotlight.
Space bar     Quick Look: Use Quick Look to preview the selected item.
Command-Tab     Switch apps: Switch to the next most recently used app among your open apps.
Shift-Command-Tilde (~)     Switch windows: Switch to the next most recently used window of the front app.
Shift-Command-3     Screenshot: Take a screenshot of the entire screen. Learn more screenshot shortcuts.
Command-Comma (,)     Preferences: Open preferences for the front app.
Sleep, log out, and shut down shortcuts
               Shortcut                   Description
Power button
    Tap to turn on your Mac or wake your Mac from sleep. 
Hold for 1.5 seconds while your Mac is awake to display a dialog asking if you want to restart, sleep, or shut down. If you don't want to wait 1.5 seconds, press Control–Power button or Control–Media Eject  .
Hold for 5 seconds to force your Mac to turn off.
Control–Command–Power button     Force your Mac to restart.
Control–Shift–(Power button or Media Eject )     Put your displays to sleep.
Control–Command–Media Eject      Quit all apps, then restart your Mac. If any open documents have unsaved changes, you'll be asked whether you want to save them.
Control–Option–Command–(Power button or Media Eject )     Quit all apps, then shut down your Mac. If any open documents have unsaved changes, you'll be asked whether you want to save them.
Shift-Command-Q     Log out of your OS X user account. You'll be asked to confirm.
Option-Shift-Command-Q     Log out of your OS X user account immediately, without being asked to confirm.
Document shortcuts
               Shortcut                   Description
Command-B     Boldface the selected text, or turn boldfacing on or off.
Command-I     Italicize the selected text, or turn italics on or off.
Command-U     Underline the selected text, or turn underlining on or off.
Command-T     Show or hide the Fonts window.
Command-D     Select the Desktop folder from within an Open dialog or Save dialog.
Control-Command-D     Show or hide the definition of the selected word.
Shift-Command-Colon (:)     Display the Spelling and Grammar window.
Command-Semicolon (;)     Find misspelled words in the document.
Option-Delete     Delete the word to the left of the insertion point.
Control-H     Delete the character to the left of the insertion point. Or use Delete.
Control-D     Delete the character to the right of the insertion point. Or use Fn-Delete.
Fn-Delete     Forward delete on keyboards that don't have a Forward Delete   key. Or use Control-D.
Control-K     Delete the text between the insertion point and the end of the line or paragraph.
Command-Delete     Select Delete or Don't Save in a dialog that contains a Delete or Don't Save button.
Fn–Up Arrow     Page Up: Scroll up one page.
Fn–Down Arrow     Page Down: Scroll down one page.
Fn–Left Arrow     Home: Scroll to the beginning of a document.
Fn–Right Arrow     End: Scroll to the end of a document.
Command–Up Arrow     Move the insertion point to the beginning of the document.
Command–Down Arrow     Move the insertion point to the end of the document.
Command–Left Arrow     Move the insertion point to the beginning of the current line.
Command–Right Arrow     Move the insertion point to the end of the current line.
Option–Left Arrow     Move the insertion point to the beginning of the previous word.
Option–Right Arrow     Move the insertion point to the end of the next word.
Shift–Command–Up Arrow     Select the text between the insertion point and the beginning of the document.
Shift–Command–Down Arrow     Select the text between the insertion point and the end of the document.
Shift–Command–Left Arrow     Select the text between the insertion point and the beginning of the current line.
Shift–Command–Right Arrow     Select the text between the insertion point and the end of the current line.
Shift–Up Arrow     Extend text selection to the nearest character at the same horizontal location on the line above.
Shift–Down Arrow     Extend text selection to the nearest character at the same horizontal location on the line below.
Shift–Left Arrow     Extend text selection one character to the left.
Shift–Right Arrow     Extend text selection one character to the right.
Option–Shift–Up Arrow     Extend text selection to the beginning of the current paragraph, then to the beginning of the following paragraph if pressed again.
Option–Shift–Down Arrow     Extend text selection to the end of the current paragraph, then to the end of the following paragraph if pressed again.
Option–Shift–Left Arrow     Extend text selection to the beginning of the current word, then to the beginning of the following word if pressed again.
Option–Shift–Right Arrow     Extend text selection to the end of the current word, then to the end of the following word if pressed again.
Control-A     Move to the beginning of the line or paragraph.
Control-E     Move to the end of a line or paragraph.
Control-F     Move one character forward.
Control-B     Move one character backward.
Control-L     Center the cursor or selection in the visible area.
Control-P     Move up one line.
Control-N     Move down one line.
Control-O     Insert a new line after the insertion point.
Control-T     Swap the character behind the insertion point with the character in front of the insertion point.
Command–Left Curly Bracket ({)     Left align.
Command–Right Curly Bracket (})     Right align.
Shift–Command–Vertical bar (|)     Center align.
Option-Command-F     Go to the search field.
Option-Command-T     Show or hide a toolbar in the app.
Option-Command-C     Copy Style: Copy the formatting settings of the selected item to the Clipboard.
Option-Command-V     Paste Style: Apply the copied style to the selected item.
Option-Shift-Command-V     Paste and Match Style: Apply the style of the surrounding content to the item pasted within that content.
Option-Command-I     Show or hide the inspector window.
Shift-Command-P     Page setup: Display a window for selecting document settings.
Shift-Command-S     Display the Save As dialog, or duplicate the current document.
Shift–Command–
Minus sign (-)         Decrease the size of the selected item.
Shift–Command–
Plus sign (+)     Increase the size of the selected item. Command–Equal sign (=) performs the same function.
Shift–Command–
Question mark (?)     Open the Help menu.
Finder shortcuts
          Shortcut               Description
Command-D     Duplicate the selected files.
Command-E     Eject the selected disk or volume.
Command-F     Start a Spotlight search in the Finder window.
Command-I     Show the Get Info window for a selected file.
Shift-Command-C     Open the Computer window.
Shift-Command-D     Open the desktop folder.
Shift-Command-F     Open the All My Files window.
Shift-Command-G     Open a Go to Folder window.
Shift-Command-H     Open the Home folder of the current OS X user account.
Shift-Command-I     Open iCloud Drive.
Shift-Command-K     Open the Network window.
Option-Command-L     Open the Downloads folder.
Shift-Command-O     Open the Documents folder.
Shift-Command-R     Open the AirDrop window.
Shift-Command-T     Add selected Finder item to the Dock (OS X Mountain Lion or earlier)
Control-Shift-Command-T     Add selected Finder item to the Dock (OS X Mavericks or later)
Shift-Command-U     Open the Utilities folder.
Option-Command-D     Show or hide the Dock. This often works even when you're not in the Finder.
Control-Command-T     Add the selected item to the sidebar (OS X Mavericks or later).
Option-Command-P     Hide or show the path bar in Finder windows.
Option-Command-S     Hide or show the Sidebar in Finder windows.
Command–Slash (/)     Hide or show the status bar in Finder windows.
Command-J     Show View Options.
Command-K     Open the Connect to Server window.
Command-L     Make an alias of the selected item.
Command-N     Open a new Finder window.
Shift-Command-N     Create a new folder.
Option-Command-N     Create a new Smart Folder.
Command-R     Show the original file for the selected alias.
Command-T     Show or hide the tab bar when a single tab is open in the current Finder window.
Shift-Command-T     Show or hide a Finder tab.
Option-Command-T     Show or hide the toolbar when a single tab is open in the current Finder window.
Option-Command-V     Move: Move the files in the Clipboard from their original location to the current location.
Option-Command-Y     View a Quick Look slideshow of the selected files.
Command-Y     Use Quick Look to preview the selected files.
Command-1     View the items in the Finder window as icons.
Command-2     View the items in a Finder window as a list.
Command-3     View the items in a Finder window in columns.
Command-4     View the items in a Finder window with Cover Flow.
Command–Left Bracket ([)     Go to the previous folder.
Command–Right Bracket (])     Go to the next folder.
Command–Up Arrow     Open the folder that contains the current folder.
Command–Control–Up Arrow     Open the folder that contains the current folder in a new window.
Command–Down Arrow     Open the selected item.
Command–Mission Control     Show the desktop. This works even when you're not in the Finder.
Command–Brightness Up     Turn Target Display Mode on or off.
Command–Brightness Down     Turn display mirroring on or off when your Mac is connected to more than one display.
Right Arrow      Open the selected folder. This works only when in list view.
Left Arrow     Close the selected folder. This works only when in list view.
Option–double-click     Open a folder in a separate window and close the current window.
Command–double-click     Open a folder in a separate tab or window.
Command-Delete     Move the selected item to the Trash.
Shift-Command-Delete     Empty the Trash.
Option-Shift-Command-Delete     Empty the Trash without confirmation dialog.
Command-Y     Use Quick Look to preview the files.
Option–Brightness Up     Open Displays preferences. This works with either Brightness key.
Option–Mission Control     Open Mission Control preferences.
Option–Volume Up     Open Sound preferences. This works with any of the volume keys.
Command key while dragging     Move the dragged item to another volume or location. The pointer changes while you drag the item.
Option key while dragging     Copy the dragged item. The pointer changes while you drag the item.
Option-Command while dragging     Make an alias of the dragged item. The pointer changes while you drag the item.
Option-click a disclosure triangle     Open all folders within the selected folder. This works only when in list view.
Command-click a window title     See the folders that contain the current folder.

Excel 2007 Shortcuts

 

1- Navigating in Worksheets and Selecting Cells

Ctrl+Shift+[+]     Insert a new row or column (after the current row is selected with shift+space, or column is selected with ctrl+space
arrow left, arrow right, arrow up, arrow down     Move one cell up, down, left, or right in a worksheet.
Ctrl+Arrow Keys     Moves to the edge of the current data region
Shift+Arrow Keys     Extends the selection of cells by one cell.
Ctrl+Shift+Arrow Keys     Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell
Backspace     Deletes one character to the left in the Formula Bar. Also clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point
Delete     Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point.
End     Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on. Also selects the last command on the menu when a menu or submenu is visible.
Ctrl+End     Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text
Ctrl+Shift+end in worksheet     Extends the selection of cells to the last used cell on the worksheet (lower-right corner).
Ctrl+Shift+end in formula bar     Selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.
Enter     Completes a cell entry and selects the cell below
Shift+Enter     Completes a cell entry and selects the cell above.
Ctrl+Enter     Completes a cell entry and stays in the same cell
Alt+Enter     Starts a new line in the same cell
Esc     Cancels an entry in the cell or Formula Bar. Closes an open menu or submenu, dialog box, or message window. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again.
Home     Moves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when scroll lock is turned on. Selects the first command on the menu when a menu or submenu is visible.
Ctrl+Home     Moves to the beginning of a worksheet.
Ctrl+Shift+Home     Extends the selection of cells to the beginning of the worksheet
Page Down     Moves one screen down in a worksheet.
Alt+Page Down     Moves one screen to the right in a worksheet.
Ctrl+Page Down     Moves to the next sheet in a workbook.
Ctrl+Shift+Page Down     Selects the current and next sheet in a workbook
Page Up     Moves one screen up in a worksheet.
Alt+Page Up     Moves one screen to the left in a worksheet.
Ctrl+Page Up     Moves to the previous sheet in a workbook.
Ctrl+Shift+Page Up     Selects the current and previous sheet in a workbook
Space     In a dialog box, performs the action for the selected button, or selects or clears a check box.
Ctrl+Space     Selects an entire column in a worksheet.
Shift+Space     Selects an entire row in a worksheet.
Ctrl+Shift+Space     Selects the entire worksheet.
Tab     Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialog box.
Shift+Tab     Moves to the previous cell in a worksheet or the previous option in a dialog box.
Ctrl+Tab     Switches to the next tab in dialog box
Ctrl+Shift+Tab     Switches to the previous tab in a dialog box.

2. Format Cells


Ctrl+1     Format cells dialog.
Ctrl+b (or ctrl+2)     Apply or remove bold formatting.
Ctrl+i (or ctrl+3)     Apply or remove italic formatting.
Ctrl+u (or ctrl+4)     Apply or remove an underline.
Ctrl+5     Apply or remove strikethrough formatting.
Ctrl+Shift+&     Apply the outline border.
Ctrl+Shift+_ (underscore)     Remove outline borders.
Ctrl+Shift+F     Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size. Used to be ctrl+shift+p, but that seems just get to the Font Tab in 2010.
Alt+' (apostrophe / single quote)     Display the Style dialog box.
F4     Repeat previous formatting on current cell












3. Function keys in Excel 2007




F1     Displays the Microsoft Office Excel Help task pane.
Ctrl+F1     Displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface.
Alt+F1     Creates a chart of the data in the current range.
Alt+Shift+F1     Inserts a new worksheet.
F2     Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
Shift+F2     Adds or edits a cell comment.
Ctrl+F2     Displays the Print Preview window.
F3     Displays the Paste Name dialog box.
Ctrl+F3     Display the Name Manager, create new names.
Shift+F3     Displays the Insert Function dialog box.
F4     Repeats the last command or action, if possible.
Ctrl+F4     Closes the selected workbook window.
F5     Displays the Go To dialog box.
Ctrl+F5     Restores the window size of the selected workbook window.
F6     Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area.
Shift+F6     Switches between the worksheet, Zoom controls, task pane, and Ribbon.
Ctrl+F6     Switches to the next workbook window when more than one workbook window is open.
F7     Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
Ctrl+F7     Performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.
F8     Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
Shift+F8     Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
Ctrl+F8     Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
Alt+F8     Displays the Macro dialog box to create, run, edit, or delete a macro.
F9     Calculates all worksheets in all open workbooks.
Shift+F9     Calculates the active worksheet.
Ctrl+Alt+F9     calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Ctrl+Alt+Shift+F9     Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Ctrl+F9     Minimizes a workbook window to an icon.
F10     Turns key tips on or off.
Shift+F10     Displays the shortcut menu for a selected item.
Alt+Shift+F10     Displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
Ctrl+F10     Maximizes or restores the selected workbook window.
F11     Creates a chart of the data in the current range.
Shift+F11     Inserts a new worksheet.
Alt+F11     Opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
F12     Displays the Save As dialog box.






4. CTRL Combinations in Excel 2007


Ctrl+Shift+(     Unhides any hidden rows within the selection.
Ctrl+Shift+)     Unhides any hidden columns within the selection.
Ctrl+Shift+&     Applies the outline border to the selected cells.
Ctrl+Shift+_     Removes the outline border from the selected cells.
Ctrl+Shift+~     Applies the General number format.
Ctrl+Shift+$     Applies the Currency format with two decimal places (negative numbers in parentheses).
Ctrl+Shift+%     Applies the Percentage format with no decimal places.
Ctrl+Shift+^     Applies the Exponential number format with two decimal places.
Ctrl+Shift+#     Applies the Date format with the day, month, and year.
Ctrl+Shift+@     Applies the Time format with the hour and minute, and AM or PM.
Ctrl+Shift+!     Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Ctrl+Shift+*     Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.
Ctrl+Shift+:     Enters the current time.
Ctrl+Shift+"     Copies the value from the cell above the active cell into the cell or the Formula Bar.
Ctrl+Shift+[+]     Displays the Insert dialog box to insert blank cells.
Ctrl+-     Displays the Delete dialog box to delete the selected cells.
Ctrl+;     Enters the current date.
Ctrl+`     Alternates between displaying cell values and displaying formulas in the worksheet.
Ctrl+'     Copies a formula from the cell above the active cell into the cell or the Formula Bar.
Ctrl+1     Displays the Format Cells dialog box.
Ctrl+2     Applies or removes bold formatting.
Ctrl+3     Applies or removes italic formatting.
Ctrl+4     Applies or removes underlining.
Ctrl+5     Applies or removes strikethrough.
Ctrl+6     Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
Ctrl+8     Displays or hides the outline symbols.
Ctrl+9     Hides the selected rows.
Ctrl+0 (zero)     Hides the selected columns.
Ctrl+A     Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.
Ctrl+Shift+A     Inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
Ctrl+B     Applies or removes bold formatting.
Ctrl+C     Copies the selected cells.
Ctrl+C     Followed by another CTRL+C displays the Clipboard.
Ctrl+D     Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
Ctrl+F     Displays the Find and Replace dialog box, with the Find tab selected.
Ctrl+Shift+F     Opens the Format Cells dialog box with the Font tab selected.
Ctrl+G     Displays the Go To dialog box.
Ctrl+H     Displays the Find and Replace dialog box, with the Replace tab selected.
Ctrl+I     Applies or removes italic formatting.
Ctrl+K     Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
Ctrl+N     Creates a new, blank workbook.
Ctrl+O     Displays the Open dialog box to open or find a file.
Ctrl+Shift+O     Selects all cells that contain comments.
Ctrl+P     Displays the Print dialog box.
Ctrl+Shift+P     Opens the Format Cells dialog box with the Font tab selected.
Ctrl+R     Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
Ctrl+S     Saves the active file with its current file name, location, and file format.
Ctrl+T     Displays the Create Table dialog box.
Ctrl+U     Applies or removes underlining.
Ctrl+Shift+U     Switches between expanding and collapsing of the formula bar.
Ctrl+V     Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
Ctrl+Alt+V     Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
Ctrl+W     Closes the selected workbook window.
Ctrl+X     Cuts the selected cells.
Ctrl+Y     Repeats the last command or action, if possible.
Ctrl+Z     Uses the Undo command to reverse the last command or to delete the last entry that you typed.
Ctrl+Shift+Z     Uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.












5. Smart-Art Graphics: Work with shapes

Tab     Select the next element in a SmartArt graphic.
Shift+Tab     Select the previous element in a SmartArt graphic.
Ctrl+A     Select all shapes.
Esc     Remove focus from the selected shape.
Arrow Up     Nudge the selected shape up.
Arrow Down     Nudge the selected shape down.
Arrow Left     Nudge the selected shape left.
Arrow Right     Nudge the selected shape right.
Enter/F2     Edit text in the selected shape.
Delete/Backspace     Delete the selected shape.
Ctrl+X/Shift+Delete     Cut the selected shape.
Ctrl+C     Copy the selected shape.
Ctrl+V     Paste the contents of the Clipboard.
Ctrl+Z     Undo the last action.
Shift+Arrow Right     Enlarge the selected shape horizontally. Add ctrl for moving pixel-by-pixel.
Shift+Arrow Left     Reduce the selected shape horizontally. Add ctrl for moving pixel-by-pixel.
Shift+Arrow Up     Enlarge the selected shape vertically. Add ctrl for moving pixel-by-pixel.
Shift+Arrow Down     Reduce the selected shape vertically. Add ctrl for moving pixel-by-pixel.
Alt+Arrow Right     Rotate the selected shape to the right. Add ctrl for moving pixel-by-pixel.
Alt+Arrow Left     Rotate the selected shape to the left. Add ctrl for moving pixel-by-pixel.

6. Smart-Art Graphics : Work with Text

Arrow Left     Move one character to the left.
Arrow Right     Move one character to the right.
Arrow Up     Move up one line.
Arrow Down     Move down one line.
Ctrl+Arrow Left     Move one word to the left.
Ctrl+Arrow Right     Move one word to the right.
Ctrl+Arrow Up     Move one paragraph up.
Ctrl+Arrow Down     Move one paragraph down.
End     Move to the end of a line.
Home     Move to the beginning of a line.
Ctrl+End     Move to the end of a text box.
Ctrl+Home     Move to the beginning of a text box.
Ctrl+X     Cut selected text.
Ctrl+C     Copy selected text.
Ctrl+V     Paste selected text.
Ctrl+Z     Undo the last action.
Backspace     Delete one character to the left.
Ctrl+Backspace     Delete one word to the left.
Delete     Delete one character to the right.
Ctrl+Delete     Delete one word to the right.
Alt+Shift+Arrow Right     Promote the selected text.
Alt+Shift+Arrow Left     Demote the selected text.

7. Microsoft Clip Organizer main

Ctrl+Arrow Left/Ctrl+Arrow Right     Move forward or backward one word in the Search text box.
Alt+C     Displays the Collection List task pane.
Alt+S     Displays the Search task pane.
Alt+H     Open Help.
Arrow Keys     Move left and right, up and down, among collections or clips.
Shift+Arrow Keys     Select additional clips after one clip has been selected.
Ctrl+A     Select all clips on the current page.
Ctrl+C     Copy (select a clip and move it to the clipboard).
Ctrl+V     Paste (paste from the clipboard to Clip Organizer).
Delete     Delete selected clip or category.
Home     Move to the beginning of a row and select the first item.
End     Move to the end of a row and select the last item.
Shift+F10     Display a shortcut menu for a collection, clip, or link (same as right click).
Esc     Exit a dialog box.
tab and shift+Tab     Shift focus forward and backward between different areas of a dialog box.
Alt+Space     Open the shortcut menu of a dialog box.

8. Work with the Excel Ribbon

Alt/F10     Select the active tab of the Ribbon and activate the access keys. . Press either of these keys again to move back to the document and cancel the access keys.
Alt/ f10 to select the active tab, and then arrow left /Arrow Right     Move to another tab of the Ribbon.
Ctrl+F1     Minimize or restore the Ribbon.
Shift+F10     Display the shortcut menu for the selected command.
F6     Move the focus to select either Active tab of the Ribbon, View Status bar at bottom of the window or document
Alt/ f10, and then tab /Shift+Tab     Move the focus to each command in the Ribbon, forward or backward.
arrow down, arrow up, arrow left, /Arrow Right     Move down, up, left, or right among the items in the Ribbon.
Space/Enter     Activate the selected command or control in the Ribbon.
Space/Enter     Open the selected menu or gallery in the Ribbon.
Enter     Activate a command or control in the Ribbon so you can modify a value.
Enter     Finish modifying a value in a control in the Ribbon, and move focus back to the document.
F1     Get help on the selected command or control in the Ribbon. (If no Help topic is associated with the selected command, the Help table of contents for that program is shown instead.)

Mozilla Firefox Shortcut Keys



    Alt + Left Arrow — Back a page

    Backspace — Back a page

    Alt + Right Arrow — Forward a page

    F5 — Refresh current page, frame, or tab

    F11 — Display the current website in full screen mode. Pressing F11 again will exit this mode

    Esc — Stop page or download from loading

    Ctrl + (- or +) — Increase or decrease the font size, pressing '-' will decrease and '+' will increase

    Ctrl + Enter — Quickly complete an address. For example, type google in the address bar and press CTRL + ENTER to get http://www.google.com

    Shift + Enter — Complete a .net instead of a .com address

    Ctrl + Shift + Enter — Complete a .org address

    Ctrl + Shift + Del — Open the Clear Data window to quickly clear private data

    Ctrl + D — Add a bookmark for the page currently opened

    Ctrl + I — Display available bookmarks

    Ctrl + J — Display the download window

    Ctrl + N — Open New browser window

    Ctrl + P — Print current page / frame

    Ctrl + T — Opens a new tab

    Ctrl + F4 — Closes the currently selected tab

    Ctrl + Shift + T — Undo the close of a window

    Ctrl + Tab — Moves through each of the open tabs

    Spacebar — Moves down a page at a time

    Shift + Spacebar — Moves up a page at a time

    Alt + Down arrow — Display all previous text entered in a text box and/or available options on drop down menu

Internet Explorer Shortcut Keys




    Alt + Left Arrow — Back a page

    Backspace — Back a page

    Alt + Right Arrow — Forward a page

    F5 — Refresh current page, frame, or tab

    F11 — Display the current website in full screen mode. Pressing F11 again will exit this mode

    Esc — Stop page or download from loading

    Ctrl + (- or +) — Increase or decrease the font size, pressing '-' will decrease and '+' will increase

    Ctrl + Enter — Quickly complete an address. For example, type google in the address bar and press CTRL + ENTER to get http://www.google.com

    Ctrl + D — Add a Favorite for the page currently opened

    Ctrl + I — Display available bookmarks

    Ctrl + N — Open New browser window

    Ctrl + P — Print current page / frame

    Ctrl + T — Opens a new tab

    Ctrl + F4 — Closes the currently selected tab

    Ctrl + Tab — Moves through each of the open tabs

    Spacebar — Moves down a page at a time

    Shift + Spacebar — Moves up a page at a time

    Alt + Down arrow — Display all previous text entered in a text box and/or available options on drop down menu

System Commands


Type the following commands in your Run Box (Windows Key + R) or Start Run

    devmgmt.msc — Device Manager

    msinfo32 — System Information

    cleanmgr — Disk Cleanup

    ntbackup — Backup or Restore Wizard (Windows Backup Utility)

    mmc — Microsoft Management Console

    excel — Microsoft Excel (If Installed)

    msaccess — Microsoft Access (If Installed)

    powerpnt — Microsoft PowerPoint (If Installed)

    winword — Microsoft Word (If Installed)

    frontpg — Microsoft FrontPage (If Installed)

    notepad — Notepad

    wordpad — WordPad

    calc — Calculator

    msmsgs — Windows Messenger

    mspaint — Microsoft Paint

    wmplayer — Windows Media Player

    rstrui — System Restore

    netscp6 — Netscape 6.x

    netscp — Netscape 7.x

    netscape — Netscape 4.x

    waol — America Online

    control — Opens the Control Panel

    control printers — Opens the Printers Dialog

    cmd — Command Prompt

    iexplore + "web address" — Internet Explorer

    compmgmt.msc — Computer Management

    dhcpmgmt.msc — DHCP Management

    dnsmgmt.msc — DNS Management

    services.msc — Services

    eventvwr — Event Viewer

    dsa.msc — Active Directory Users and Computers

    dssite.msc — Active Directory Sites and Services

Keyboard Shortcuts in Windows

[Alt] + [Esc] — Switch between running applications

[Alt] + letter — Select menu item by underlined letter

[Ctrl] + [Esc] — Open Program Menu

[Ctrl] + [F4] — Close active document or group windows (does not work with some applications)

[Alt] + [F4] — Quit active application or close current window

[Alt] + [-] — Open Control menu for active document

Ctrl] Lft. + Rt. arrow — Move cursor forward or back one word

Ctrl] Up + Down arrow — Move cursor forward or back one paragraph

[F1] — Open Help for active application

Windows + M — Minimize all open windows

Shift+Windows + M — Undo minimize all open windows

Windows + F1 — Open Windows Help

Windows + Tab — Cycle through the Taskbar buttons

Windows + Break — Open the System Properties dialog box
Accessability Shortcuts

    Right SHIFT for eight seconds — Switch FilterKeys on and off
    Left ALT + left SHIFT + PRINT SCREEN — Switch High Contrast on and off
    Left ALT + left SHIFT +NUM LOCK — Switch MouseKeys on and off
    SHIFT five times — Switch StickyKeys on and off
    NUM LOCK for five seconds — Switch ToggleKeys on and off

Explorer Shortcuts

    END — Display the bottom of the active window
    HOME — Display the top of the active window
    NUM LOCK + ASTERISK — on numeric keypad (*) Display all subfolders under the selected folder
    NUM LOCK + PLUS SIGN — on numeric keypad (+) Display the contents of the selected folder
    NUM LOCK + MINUS SIGN — on numeric keypad (-) Collapse the selected folder
    LEFT ARROW — Collapse current selection if it's expanded, or select parent folder
    RIGHT ARROW — Display current selection if it's collapsed, or select first subfolder

A-Z Shortcut Keys in Microsoft Word

   F1 key — Get help or use the Office assistant
    SHIFT and F1 Key — Context sensitive help
    F2 Key — Move text or image
    SHIFT + F2 Key — Copy text
    F3 Key — Insert an autotext entry
    SHIFT + F3 Key — Change the case of the selected text
    F4 Key — Perform last action again
    SHIFT + F4 Key — Perform a Find or Go to action again
    F5 Key — Displays the Go to dialogue box. You can also get to Find and Replace from here
    SHIFT + F5 Key — Move to a previous revision
    F6 Key — Go to the next frame or pane
    SHIFT + F6 Key — Go to the previous frame or pane
    F7 Key — Launch the Spell checker
    SHIFT + F7 Key — Launch the Thesaurus
    F8 Key — Extend the current selection
    SHIFT + F8 Key — Shrink the current selection
    F9 Key — Update the selected fields
    SHIFT + F9 Key — Switch between a field code and its result
    F10 Key — Activate the menu bar
    SHIFT + F10 Key — Display a Shortcut Menu (same as right-clicking)
    F11 Key — Go to the next field
    SHIFT + F11 Key — Go to the previous field
    F12 Key — Save file As, equivalent to tools menu
    SHIFT + F12 Key — Save document, equivalent to tools menu
    CTRL and A — Selects all in the current document
    CTRL and B — Bold text
    CTRL and C — Copies the item or text to the Clipboard and can be pasted using CTRL and V
    CTRL and D — Displays the Font dialogue box
    CTRL and E — Centre Alignment
    CTRL and F — Displays the Find dialog box, to search the current document
    CTRL and G — Displays the Go to dialog box, to go to a specific location in the current document
    CTRL and H — Displays the Replace dialogue box
    CTRL and I — Italic text
    CTRL and J — Full Justification
    CTRL and K — Create Hyperlink
    CTRL and L — Left Alignment
    CTRL and M — Tab
    CTRL and N — Creates a new document
    CTRL and O — Displays the Open File dialogue box
    CTRL and P — Displays the Print dialog box
    CTRL and R — Right Alignment
    CTRL and S — Displays the Save dialog box
    CTRL and U — Underline text
    CTRL and V — Pastes the copied item or text from the Clipboard into the current position in the document
    CTRL and X — Cuts the item or text selected to the Clipboard
    CTRL and Y — Redo the last undone action
    CTRL and Z — Undoes the last action
    CTRL and ENTER — Insert Page Break
    CTRL and F2 — Show Print preview
    CTRL and F4 — Closes the active document window
    CTRL and F6 — Opens the next document window

Windows Shortcut Keys

Windows key + R — Run menu

Windows key + E — Explorer

ALT + Tab — Switch between windows

ALT + Space + X — Maximize window

CTRL + Shift + Esc — Task Manager

Windows key + Break — System properties

Windows key + F — Search

Windows key + D — Hide/Display all windows

CTRL + C — Copy

CTRL + X — Cut

CTRL + V — Paste

ALL FULL FORM RELATED COMPUTER


PC : PERSONAL COMPUTER



CPU : CENTRAL PROCESSING UNIT



OS : OPERATING SYSTEM



UPS : UNINTERRUPTIBLE POWER SUPPLY



RAM : RANDOM-ACCESS MEMORY



ROM : READ-ONLY MEMORY



LCD : LIQUID CRYSTAL DISPLAY



LED : LIGHT-EMITTING DIODE



NTFS : NEW TECHNOLOGY FILE SYSTEM



FAT : FILE ALLOCATION TABLE



DOC : DOCUMENT



TXT = TEXT



MS : MICROSOFT



SD : SECURE DIGITAL



MMC : MULTIMEDIA CARD



CD : COMPACT DISC



DVD : DIGITAL VERSATILE DISC



BRD – BD : BLU-RAY DISC



ISO : INTERNATIONAL ORGANIZATION FOR STANDARDIZATION



DB : DATABASE



IC : INTEGRATED CIRCUIT



SYS : SYSTEM



CONFIG : CONFIGURATION



CTRL : CONTROL



ALT : ALTERNATE



ESC : ESCAPE



DEL : DELETE



NUM LOCK : NUMBER LOCK



FN : FUNCTION



Prnt Scrn : PRINT SCREEN



SysRq : SYSTEM REQUEST



ScrLk : SCROLL LOCK



PgUp : PAGE UP



PgDn : PAGE DOWN



Ins : INSERT



WINXP : WINDOWS XP



WIN7 : WINDOWS 7



SP : SERVICE PACK



CMD : COMMAND



TEMP : TEMPORARY



WMP : WINDOWS MEDIA PLAYER



MP3 : MOVING PICTURE EXPERTS GROUP PHASE 3 (MPEG-3)



MPEG : MOVING PICTURE EXPERTS GROUP PHASE (MPEG)



MPEG 1 : MOVING PICTURE EXPERTS GROUP PHASE 1 (MPEG-1)



MPEG 2 : MOVING PICTURE EXPERTS GROUP PHASE 2 (MPEG-2)



JPG : JOINT PHOTOGRAPHIC EXPERTS GROUP



AVI : AUDIO VIDEO INTERLEAVE



WMV : WINDOWS MEDIA VIDEO



GIF : GRAPHICS INTERCHANGE FORMAT



RGB : RED – GREEN – BLUE



CMYK : CYAN – MAGENTA – YELLOW – KEY (BLACK)



ACPI : ADVANCED CONFIGURATION AND POWER INTERFACE



APM : ADVANCED POWER MANAGEMENT



REGEDIT : REGISTRY EDITOR



PRO : PROFESSIONAL



BAT : BATCH



GPEDIT : GROUP POLICY EDITOR



OSK : ON-SCREEN KEYBOARD



COM : COMPONENT OBJECT MODEL



USB : UNIVERSAL SERIAL BUS



IT : INFORMATION TECHNOLOGY



NET : INTERNET



IP : INTERNET PROTOCOL



AP : ACCESS POINT



DNS : DOMAIN NAME SYSTEM



HTTP : HYPERTEXT TRANSFER PROTOCOL



HTTPS : HYPERTEXT TRANSFER PROTOCOL SECURE



HTML : HYPERTEXT MARKUP LANGUAGE



PHP : HYPERTEXT PREPROCESSOR



XML : EXTENSIBLE MARKUP LANGUAGE



CSS : CASCADING STYLE SHEETS



ASP : ACTIVE SERVER PAGES



SQL : STRUCTURED QUERY LANGUAGE



WWW : WORLD WIDE WEB



.COM : COMMERCIAL



.NET : NETWORK



.ORG : ORGANIZATION



.EDU : EDUCATIONAL



.GOV : GOVERMENTAL



.INFO : INFORMATION



.BIZ : BUSINESS



.BD : BANGLADESH



.US : UNITED STATE



.UK : UNITED KINGDOM



TLD : TOP-LEVEL DOMAIN



DL : DOWNLOAD



UL : UPLOAD



PR : PAGE RANK



SEO : SEARCH ENGINE OPTIMIZATION



CEO : CHIEF EXECUTIVE OFFICER



E-MAIL : ELECTRONIC MAIL



SMS : SHORT MESSAGE SERVICE



MMS : MULTIMEDIA MESSAGING SERVICE



PW – PASS – P.CODE – CODE : PASSWORD



AP : ALERTPAY



MB : MONEYBOOKERS



PP : PAYPAL



LR : LIBERTY RESERVE



INFO : INFORMATION



LAN : LOCAL AREA NETWORK



WLAN : WIRELESS LOCAL AREA NETWORK



NAT : NETWORK ADDRESS TRANSLATION



UPDATE : UP-TO-DATE



IDM : INTERNET DOWNLOAD MANAGER



DAP : DOWNLOAD ACCELERATOR PLUS



KB : KILOBYTE



MB : MEGA BYTE



GB : GIGA BYTE



GiB : GIBI BYTE



TB : TERA BYTE



TiB : TEBI BYTE



PB : PETA BYTE



PiB : PEBI BYTE



EB : EXA BYTE



EiB : EXBI BYTE



ZB : ZETTA BYTE



ZiB : ZEBI BYTE



YB : YOTTA BYTE



YiB : YOBI BYTE



GOOGLE : GOOGLE IS NOT AN ABBREVIATION . IT IS DISTORTED FORM OF GOOGOL NUMBER (10 TO THE POWER OF 100) , THAT IS 1 FOLLOWED BY 100 ZEROS (0) .



YAHOO : YET ANOTHER HIERARCHICAL OFFICIOUS ORACLE



INTEL : INTEGRATED ELECTRONICS



HP : HEWLETT PACKARD



LG : LIFE’S GOOD



IBM : INTERNATIONAL BUSINESS MACHINES



IPV4 : INTERNET PROTOCOL VERSION 4



IPV6 : INTERNET PROTOCOL VERSION 6



WI-FI : WIRELESS FIDELITY

COMPUTER FULL FORM

ADSL – Asymmetric Digital Subscriber Line

AGP – Accelerated Graphics Port

ALI – Acer Labs, Incorporated

ALU – Arithmetic Logic Unit

AMD – Advanced Micro Devices

APC – American Power Conversion

ASCII – American Standard Code for Information Interchange

ASIC – Application Specific Integrated Circuit

ASPI – Advanced SCSI Programming Interface

AT – Advanced Technology

ATI – ATI Technologies Inc.

ATX – Advanced Technology Extended



B

BFG – BFG Technologies

BIOS – Basic Input Output System

BNC – Barrel Nut Connector



C

COMPUTER – Common Operating Machine particularly Used For Tade, Education and Research.
CAS – Column Address Signal

CD – Compact Disk

CDR – Compact Disk Recorder

CDRW – Compact Disk ReWriter

CD-ROM – Compact Disk - Read Only Memory

CFM – Cubic Feet per Minute

CMOS – Complementary Metal Oxide Semiconductor

CPU – Central Processing Unit

CTX – CTX Technology Corporation



D

DDR – Double Data Rate

DDR-SDRAM – Double Data Rate - Synchronous Dynamic Random Access Memory

DFI – DFI Inc. Design for Innovation

DIMM – Dual Inline Memory Module

DRAM – Dynamic Random Access Memory

DPI – Dots Per Inch

DSL – See ASDL

DVD – Digital Versatile Disc

DVD-RAM – Digital Versatile Disk - Random Access Memory



E

ECC – Error Correction Code

ECS – Elitegroup Computer Systems

EDO – Extended Data Out

EEPROM – Electrically Erasable Programmable Read Only Memory

EPROM – Erasable Programmable Read Only Memory

EVGA – EVGA Corporation



F

FC-PGA – Flip Chip Pin Grid Array

FDC – Floppy Disk Controller

FDD – Floppy Disk Drive

FPS – Frame Per Second

FPU – Floating Point Unit

FSAA – Full Screen Anti Aliasing

FS – For Sale

FSB – Front Side Bus



G

GB – Gigabytes

GBps – Gigabytes per second or Gigabits per second

GDI – Graphical Device Interface

GHz – GigaHertz



H

HDD – Hard Disk Drive

HIS – Hightech Information System Limited

HP – Hewlett-Packard Development Company

HSF – Heatsink Fan



I

IBM – International Business Machines Corporation

IC – Integrated Circuit

IDE – Integrated Drive Electronics

IFS- Item for Sale

IRQ – Interrupt Request

ISA – Industry Standard Architecture

ISO – International Standards Organization



J

JBL – JBL, Jame B. Lansing., Speakers

JVC – JVC Company of America



K

Kbps – Kilobits Per Second

KBps – KiloBytes per second



L

LG – LG Electronics

LAN – Local Area Network

LCD – Liquid Crystal Display

LDT – Lightning Data Transport

LED – Light Emitting Diode



M

MAC – Media Access Control

MB  – MotherBoard or Megabyte

MBps – Megabytes Per Second

Mbps – Megabits Per Second or Megabits Per Second

MHz – MegaHertz

MIPS – Million Instructions Per Second

MMX – Multi Media Extensions

MSI – Micro Star International



N

NAS – Network Attached Storage

NAT – Network Address Translation

NEC – NEC Corporation

NIC – Network Interface Card



O

OC – Over Clock

OCZ – OCZ Technology

OEM – Original Equipment Manufacturer



P

PC – Personal Computer

PCB – Printed Circuit Board

PCI – Peripheral Component Interconnect

PDA – Personal Digital Assistant

PCMCIA – Peripheral Component Microchannel Interconnect Architecture

PGA – Professional Graphics Array

PLD – Programmable Logic Device

PM – Private Message or Private Messaging

PnP – Plug ‘n Play

PNY – PNY Technology

POST – Power On Self Test

PPPoA – Point to Point Protocol over ATM

PPPoE – Point to Point Protocol over Ethernet

PQI – PQI Corporation

PSU – Power Supply Unit



R

RAID – Redundant Array of Inexpensive Disks

RAM – Random Access Memory

RAMDAC – Random Access Memory Digital Analog Convertor

RDRAM – Rambus Dynamic Random Access Memory

ROM – Read Only Memory

RPM – Revolutions Per Minute



S

SASID – Self scanned Amorphous Silicon Integrated Display

SCA – SCSI Configured Automatically

SCSI – Small Computer System Interface

SDRAM – Synchronous Dynamic Random Access Memory

SECC – Single Edge Contact Connector

SODIMM – Small Outline Dual Inline Memory Module

SPARC – Scalable Processor ArChitecture

SOHO – Small Office Home Office

SRAM – Static Random Access Memory

SSE – Streaming SIMD Extensions

SVGA – Super Video Graphics Array

S/PDIF – Sony or Philips Digital Interface



T

TB – Terabytes

TBps – Terabytes per second

Tbps – Terabits per second

TDK – TDK Electronics

TEC – Thermoelectric Cooler

TPC – TipidPC

TWAIN – Technology Without An Important Name



U

UART – Universal Asynchronous Receiver or Transmitter

USB – Universal Serial Bus

UTP – Unshieled Twisted Pair



V

VCD – Video CD

VPN – Virtual Private Network



W

WAN – Wide Area Network

WTB – Want to Buy

WYSIWYG – What You See Is What You Get



X

XGA – Extended Graphics Array

XFX – XFX Graphics, a Division of Pine

XMS – Extended Memory Specification

XT – Extended Technology

QUESTIONS FOR CAMPUS INTERVIEW with answers 65

Q1:- Differentiate between RAM and ROM? RAM stands for Random Access Memory. It can store information and have new information stored o...