MS-WORD Shortcut Keys

In making documents in a word 
processing program like microsoft
word, there are features that
we canuse to save time and effort
in making a professional looking
documents, and that feature is 
the keyboard shortcuts.I know
 hat many of PC users or NET
users knows a bunch of k-shortcuts but 
for the sake of some people that don`t 
know yet..! I compiled some of the 
useful keys.

NOTE: If some part of this blog entry related to MS word have
a wrong parts..you can leave a comment or email me to 
clarify and change it.

Keyboard shortcuts for Document Action

        Action                                            Keystroke

1. open a file -                                      CTRL+O
2. new file -                                          CTRL+N
3. close a file -                                     CTRL+W
4. save as -                                             F12
5. save -                                    CTRL+S or SHIFT+12
6. print preview -                                CTRL+F2
7. print -                                              CTRL+P
8. show/hide paragraph symbols -         CTRL+*
9. spelling and grammar -                         F7
10. help -                                                  F1
11. find -                                              CTRL+F
12. replace -                                        CTRL+H
13. go to -                                           CTRL+G

Keyboard shortcuts for Text Style 

        Action                           Keystroke 

1. font face -                       CTRL+SHIFT+F
2. font size -                        CTRL+SHIFT+P
3. bold -                                    CTRL+B
4. italics -                                  CTRL+I
5. underline -                             CTRL+U
6. double underline -           CTRL+SHIFT+D
7. word underline -            CTRL+SHIFT+W
8. all caps -                       CTRL+SHIFT+A
9. change case -                      SHIFT+F3 

NOTE: A plus sign indicates the the key need
               to be pressed at the same time
.

MS excel Functions

Studying different kinds of programs like
Ms-excel is a part on learning the
fundamentals of being an IT student. For
 me I hate excel because, when our
instructor taught us on how to use excel,
 Im absent that time so Ive`d miss the
discussion and the result.?...I did not
learned mush more in excel. But i would
like to share this info related on excel
functions.

Microsoft Excel - is primarily a spreadsheet program for making sense out of numbers.

Excel functions:

1. Average - get the average of the array of numbers.
2. Min - displaying the smallest number in an array of elements.
3. Max - "           "             "           "            "          "        "
4. If function - ex.=if(A1<75,"true","false")  /  syntax.=if(logical test,true,false)
5. Sum If function - ex.=sumif(E1:E6,"=165",F1;F6)  /  syntax.=sumif(range,criteria, sum range)
6. Sqrt function - display the square root of a number.  /  ex.=sqrt(A10)
7. Count function - count the total element within the range.  /  ex.=count(A1:A6)
8. Countif function - ex.=countif(E1:E6,165)  /  syntax.=countif(range,criteria)
9. Median - display the middle element in an array.
10. Hyperlink - syntax.=hyperlink(link_location,name).

NOTE: If some part of this blog entry related to MS word have a wrong parts..you can leave a comment or email me to clarify and change it.