Microsoft+office+notes

=Excel= $D$5: "$" means it is an absolute reference; It won't change when the formula is copied and pasted (otherwise it will change in reference to the original pasting.  changes a reference from relative to absolute while editing a cell

to see all the formulas in a spreadsheet go to tools>formula auditing>formula auditing mode (or press ctrl+' )

to enter a time enter 9:00 p for 9:00 PM

for todays date: ctrl+; for current time: ctrl+shift+;

to enter a mixed fraction put a space between the whole and fraction (for just a fraction enter 0 2/3 for 2/3)

(200) will show as -200 ? dunno why yet.

to clear the formatting (bold, red size 5, etc) in a cell: Edit>Clear>Formatting

[] random questions answered about functions

=Word (2010)= Shift+F3 toggles between ALL CAPS, all lower case, And Initial Upper Case.

Shift+F1 opens **Reveal Formatting** task pane. If you check the box at the bottom of the pane you can show all of the formatting marks within the document!

to create "headings" for the navigation bar, >Paragraph>Outline level> select desired level.

"Combine" (Merge) documents
[|http://www.ehow.com/how_8105385_can-multiple-word-documents-one.html]
 * 1) Open a word document I don't believe it matters what document you open
 * 2) Review>Compare>Combine> enter or browse for documents to combine >OK>continue
 * 3) there will be three columns 1st) edits named 2nd) the intended final merged document 3rd) the two original documents
 * 4) use review ribbon's "accept" or "reject" options to edit final merged document.
 * 5) save>name your new, merged document or save over one of the originals

APA Template
downloadable with styles and macros []

Use the **clipboard** drop down menu (below "Format Painter") on the home menu to collect multiple copies to paste.

Tracking changes: change **User name** for a document under File>Options>__U__ser name and __I__nitials

Shft+F3 changes font cases: all caps, etc.

nonbreaking space, press CTRL+SHIFT+SPACEBAR. nonbreaking hyphen, press CTRL+SHIFT+HYPHEN.  Week 1 Changing Demographics