Biyernes, Enero 4, 2013

Microsoft shortcut keys


Application window-maximize Alt-F10
Application window-previous Alt-Shift-F6
Application window-restore Alt-F5
AutoFormat Ctrl-Alt-K
AutoText-create Alt-F3
AutoText-insert entry Ctrl-Alt-V
AutoText-insert entry F3
Bold Ctrl-B
Bookmarks Ctrl-Shift-F5
Break-column Ctrl-Shift-Enter
Break-page Ctrl-Enter
Browse a document Ctrl-Alt-Home
Browse next/previous item Ctrl-PgDn/PgUp
Capatilize word shift+f3
Case-All Caps Ctrl-Shift-A
Close Ctrl-F4
Close Ctrl-W
Copy Ctrl + C
Copy formatting Ctrl-Shift-C
Create a nonbreaking hyphen CTRL+HYPHEN
Create a nonbreaking space CTRL+SHIFT+SPACEBAR
Customize a menu Ctrl-Alt =
Customize a shortcut Ctrl-Alt-Num +
Cut Ctrl-X
Date Field Alt-Shift-D
Decrease font size CTRL+SHIFT+<
Dialog box next tabbed section Ctrl-Tab
Dialog box previous tabbed section Ctrl-Shift-Tab
Document window-move Ctrl-F7
Document window-restore Ctrl-F5
Document window-size Ctrl-F8
Drawing-constrain shape to symmetrical Shift-drag
Drawing-draw from center Ctrl-drag
Ellipsis Ctrl-Alt-
Em Dash Ctrl-Alt-Num -
Endnote Ctrl-Alt-E
Exit application Alt-F4
Fields-display code Shift-F9
Fields-display codes (toggle) Alt-F9
Fields-double-click in field Alt-Shift-F9
Fields-insert blank field Ctrl-F9
Fields-lock a field Ctrl-3
Fields-lock a field Ctrl-F11
Fields-next field F11
Fields-previous field Shift-F11
Fields-unlink a field Ctrl-6
Fields-unlink a field Ctrl-Shift-F9
Fields-unlock a field Ctrl-4
Fields-unlock a field Ctrl-Shift-F11
Fields-update Alt-Shift-U
Fields-update link in source Ctrl-Shift-F7
Fields-update selected field F9
Find Find Ctrl + F
Font Ctrl-D
Font Ctrl-Shift-F
Font grow/shrink 1 pt Ctrl- ] or [
Font next/previous size Ctrl-Shift- >or <
Font Size Ctrl-Shift-P Font Size Ctrl-Shift-P
Footnote Ctrl-Alt-F
Create a new blank document Ctrl + N
Go Back Ctrl-Alt-Z
Go Back Shift-F5
GoTo Ctrl-G
GoTo Next/Previous Paragraph Ctrl-Up/Down
GoTo Next/Previous Word Ctrl-Left/Right
Graphic-crop Shift-drag
Graphic-original proportions Ctrl-click
Hanging indent-decrease Ctrl-Shift-T
Hanging Indent-increase Ctrl-T
Hard hyphen - Ctrl-Shift -
Hard space Hard space
Header/Footer-link to previous Alt-Shift-R
Heading Level 1 Ctrl-Alt-1
Heading Level 2 Ctrl-Alt-2
Heading Level 3 Ctrl-Alt-3
Help F1
Help-Whats This? Shift-F1
Hidden text Ctrl-Shift-H
Hyperlink Ctrl-K
CTRL+SHIFT+> Increase font size
Indent-decrease Ctrl-Shift-M
Indent-increase Ctrl-M
Ctrl-Alt-M Insert Comment
Insert ListNum field Ctrl-Alt-L
Italics Ctrl-I
Justify-Center Ctrl-E
Justify-Full Ctrl-J
Justify-Left Ctrl-L
Justify-Right Ctrl-R
Line-spacing Ctrl-1
Line-spacing 1.5 Ctrl-5
Line-spacing 2 Ctrl-2
List Bullet Style Ctrl-Shift-L
Macros-edit Alt-F8
Macros-view VBA code Alt-F11
Mark-Index entry Alt-Shift-X
Mark-TOA citation Alt-Shift-I
Mark-TOC entry entry Alt-Shift-O
Maximize window Ctrl-F10
Menu Bar F10
Merge-data edit Alt-Shift-E
Merge-field insert Alt-Shift-F
Merge-preview Alt-Shift-K
Merge-to document Alt-Shift-N
Merge-to printer Alt-Shift-M
Microsoft Script Editor Alt-Shift-F11
Microsoft System Info Ctrl-Alt-F1
Move between master/subdocument Ctrl-\
Newline within paragraph Shift-Enter
Next window Ctrl-F6
Nonprinting characters Ctrl-Shift-8
Normal Style Ctrl-Shift-N Ctrl-Shift-N
Open a document Ctrl-O
Open Ctrl + O Opens a saved document
Outlining-collapse Alt-Shift-Num -
Outlining-expand Alt-Shift =
Outlining-expand Alt-Shift-Num +
Outlining-move Alt-Shift-Up/Down
Outlining-promote/demote Alt-Shift-Left/Right
Outlining-Show 1st line Alt-Shift-L
Outlining-Show All Headings Alt-Shift-A
Outlining-Show Heading 1 Alt-Shift-1
Outlining-Show Heading 2 Alt-Shift-2
Outlining-Show Heading 3 Alt-Shift-3
Outlining-Show Heading 4 Alt-Shift-4
Outlining-Show Heading 5 Alt-Shift-5
Outlining-Show Heading 6 Alt-Shift-6
Outlining-Show Heading 7 Alt-Shift-7
Outlining-Show Heading 8 Alt-Shift-8
Outlining-Show Heading 9 Alt-Shift-9
Page number field Alt-Shift-P
Pane-Close Alt-Shift-C
Paragraph Space Above (add/delete 12 pt.)Ctrl-0 Ctrl-0 (zero)
Paste Ctrl-V
Print Ctrl-P
Print Preview Ctrl-Alt-I
Redo the last action CTRL+Y
Remove Character formats Ctrl-Shift-Z
Remove menu item Ctrl-Alt -
Remove Paragraph formats Ctrl-Q
Remove paragraph or character formatting CTRL+SPACEBAR
Repeat the last command Ctrl-Y
Repeat Find Ctrl-Alt-Y
Repeat Find Shift-F4 Repeat Find Shift-F4
Replace Ctrl-H
Revision Marks on/off Ctrl-Shift-E
Save As F12
Save Ctrl-S
Select All Ctrl-A
Selection extended F8
Selection reduced Shift-F8
Shortcut Menu Shift-F10
Small Caps Ctrl-Shift-K
Soft hyphen - Ctrl -
Spelling and Grammar check F7
Spell-It-display next misspelling Alt-F7
Spike-cut to Ctrl-F3
Spike-paste Ctrl-Shift-F3
Split a window Ctrl-Alt-S
Style box Ctrl-Shift-S
Subscript Ctrl =
Symbol Font Ctrl-Shift-Q
Table-remove border lines Ctrl-Alt-U
Table-to column bottom Alt-PgDn
Table-to column top Alt-PgUp
Table-to row beginning Alt-Home
Table-to row end Alt-End
Thesaurus Shift-F7
Time Field Alt-Shift-T
To bottom/top of screen Ctrl-Alt-PgDn/PgUp
Type (c) Ctrl-Alt-C
Type (r) Ctrl-Alt-R
Type (tm) Ctrl-Alt-T
underline CTRL+U
Underline-double Ctrl-Shift-D
Underline-word Ctrl-Shift-W
Undo Ctrl-Z
View-Normal Ctrl-Alt-N
View-Outline Ctrl-Alt-O
View-Page Ctrl-Alt-P
Window pane-next F6
Window pane-previous Shift-F6













 MY GOS......

Formulas!!, (well some of it)

FormulaDescription (Result)
=IF(A2=15, "OK", "Not OK")If the value in cell A2 equals 15, then return "OK". (OK)
=IF(A2<>15, "OK", "Not OK")If the value in cell A2 is not equal to 15, then return "OK". (Not OK)
=IF(NOT(A2<=15), "OK", "Not OK")If the value in cell A2 is not less than or equal to 15, then return "OK". (Not OK)
=IF(A5<>"SPROCKETS", "OK", "Not OK")If the value in cell A5 is not equal to "SPROCKETS", then return "OK". (Not OK)
=IF(AND(A2>A3, A2<A4), "OK", "Not OK")If 15 is greater than 9 and less than 8, then return "OK". (Not OK)
=IF(AND(A2<>A3, A2<>A4), "OK", "Not OK")If 15 is not equal to 9 and 15 is not equal to 8, then return "OK". (OK)
=IF(OR(A2>A3, A2<A4), "OK", "Not OK")If 15 is greater than 9 or less than 8, then return "OK". (OK)
=IF(OR(A5<>"Sprockets", A6<>"Widgets"), "OK", "Not OK")If the value in cell A5 is not equal to "Sprockets" or "Widgets", then return "OK". (Not OK)
=IF(OR(A2<>A3, A2<>A4), "OK", "Not OK")If 15 is not equal to 9 or 15 is not equal to 8, then return "OK". (OK)


I am quite frustrated now, actually


This is me while doing the excel.....

Putting the data one by one... T_T


Microsoft Excel


Microsoft Excel

From Wikipedia, the free encyclopedia
  (Redirected from Microsoft excel)
Microsoft Excel
Microsoft Excel 2010 icon.png
Microsoft Excel 2013 Default Screen.png
Microsoft Excel 2013 running on Windows 8
Developer(s)Microsoft
Stable release2013 (15.0.4433.1506) / December 11, 2012; 24 days ago
Preview release2013 Beta (15.0.4128.1014) / July 16, 2012; 5 months ago
Operating systemMicrosoft Windows
TypeSpreadsheet
LicenseTrialware
Websiteoffice.microsoft.com/en-us/excel
Microsoft Excel for Mac
Microsoft Excel 2011 Icon.png
Microsoft Excel for Mac 2011.png
Microsoft Excel for Mac 2011 running on Mac OS X Snow Leopard
Developer(s)Microsoft
Stable release2011 (14.1.0.100825) / October 26, 2010; 2 years ago
Operating systemMac OS X
TypeSpreadsheet
LicenseProprietary commercial software
Websitewww.microsoft.com/mac/excel
Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has almost completely replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part ofMicrosoft Office. The current versions are 2010 for Microsoft Windows[1] and 2011 for Mac OS X.[2]

Micorsoft word...


Microsoft Word

From Wikipedia, the free encyclopedia
Microsoft Word
Microsoft Word 2013 Icon.png
Microsoft Word on Windows 8.png
Microsoft Office Word 2013 on Windows 8
Developer(s)Microsoft
Stable release2013 (15.0.4433.1506) / December 11, 2012; 23 days ago
Operating systemMicrosoft Windows
TypeWord processor
LicenseTrialware
Websiteoffice.microsoft.com/en-us/word/
Microsoft Word for Mac
Microsoft Word 2011 Icon.png
Microsoft Word for Mac 2011.png
Microsoft Word for Mac 2011
Developer(s)Microsoft
Operating systemMac OS X
TypeWord processor
LicenseCommercial proprietary software
Websitewww.microsoft.com/mac/word
Microsoft Word is a word processor designed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenix systems.[1][2][3]Subsequent versions were later written for several other platforms including IBM PCs running DOS (1983), the Apple Macintosh (1984), the AT&T Unix PC (1985), Atari ST (1986), SCO UNIXOS/2, and Microsoft Windows (1989). It is a component of the Microsoft Office software system; it is also sold as a standalone product and included in Microsoft Works Suite. The current versions are Microsoft Office Word 2010 for Windows and Microsoft Office Word 2011 for Mac. (These versions differ.)

A short preview about microsoft


Microsoft

From Wikipedia, the free encyclopedia
Microsoft Corporation
TypePublic
Traded as
IndustryComputer software
FoundedAlbuquerqueNew Mexico, United States (April 4, 1975)
Founder(s)Bill GatesPaul Allen
HeadquartersMicrosoft Redmond Campus,RedmondWashingtonU.S.
Area servedWorldwide
Key people
ProductsMicrosoft Windows
Microsoft Office
Microsoft Servers
Video games
(See products list)
ServicesOnline services
RevenueIncrease US$ 73.72 billion (2012)[1]
Operating incomeDecrease US$ 21.76 billion (2012)[1]
Net incomeDecrease US$ 16.97 billion (2012)[1]
Total assetsIncrease US$ 121.2 billion (2012)[1]
Total equityIncrease US$ 66.36 billion (2012)[1]
Employees94,000 (2012)[1]
SubsidiariesList of Microsoft subsidiaries
WebsiteMicrosoft.com
References: [2]
Microsoft Corporation is an American multinational software corporation headquartered in RedmondWashington that develops, manufactures, licenses and supports a wide range of products and services related to computing. The company was founded by Bill Gates and Paul Allen on April 4, 1975. Microsoft is theworld's largest software maker measured by revenues.[3] It is also one of the world's most valuable companies.[4]









Sabado, Disyembre 15, 2012