Easy Peasy...

NOT

Show All

Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value.

Syntax

NOT(logical)

Logical     is a value or expression that can be evaluated to TRUE or FALSE.

Remark

If logical is FALSE, NOT returns TRUE; if logical is TRUE, NOT returns FALSE.

1
2
3

A	B
Formula	Description (Result)
=NOT(FALSE)	Reverses FALSE (TRUE)
=NOT(1+1=2)	Reverses an equation that evaluates to TRUE (FALSE)

Not bad...

OR

Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

Syntax

OR(logical1,logical2,...)

Logical1,logical2,...     are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

Remarks

• The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values.
• If an array or reference argument contains text or empty cells, those values are ignored.
• If the specified range contains no logical values, OR returns the #VALUE! error value.
• You can use an OR array formula to see if a value occurs in an array. To enter an array formula, press CTRL+SHIFT+ENTER.

1 2 3 4

A B Formula Description (Result) =OR(TRUE) One argument is TRUE (TRUE) =OR(1+1=1,2+2=5) All arguments evaluate to FALSE (FALSE) =OR(TRUE,FALSE,TRUE) At least one argument is TRUE (TRUE)

He Approves!!!

AND

Show All
Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.

Syntax

AND(logical1,logical2, ...)

Logical1, logical2, ...     are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

Remarks

The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays or references that contain logical values.
If an array or reference argument contains text or empty cells, those values are ignored.
If the specified range contains no logical values, AND returns the #VALUE! error value.

1 2 3

A Data 50 104 Formula Description (Result) =AND(1<A2, A2<100) Because 50 is between 1 and 100 (TRUE) =IF(AND(1<A3, A3<100), A3, "The value is out of range.") Displays the second number above, if it is between 1 and 100, otherwise displays a message (The value is out of range.) =IF(AND(1<A2, A2<100), A2, "The value is out of range.") Displays the first number above, if it is between 1 and 100, otherwise displays a message (50)

He doesn't approve.

Ctrl+A Select All
Ctrl+B Bold
Ctrl+C Copy
Ctrl+D Fill Down
Ctrl+F Find
Ctrl+G Goto
Ctrl+H Replace
Ctrl+I Italic
Ctrl+K Insert Hyperlink
Ctrl+N New Workbook
Ctrl+O Open
Ctrl+P Print
Ctrl+R Fill Right
Ctrl+S Save
Ctrl+U Underline
Ctrl+V Paste
Ctrl W Close
Ctrl+X Cut
Ctrl+Y Repeat
Ctrl+Z Undo
F1 Help
F2 Edit
F3 Paste Name
F4 Repeat last action
F4 While typing a formula, switch between absolute/relative refs
F5 Goto
F6 Next Pane
F7 Spell check
F8 Extend mode
F9 Recalculate all workbooks
F10 Activate Menubar
F11 New Chart
F12 Save As
Ctrl+: Insert Current Time
Ctrl+; Insert Current Date
Ctrl+" Copy Value from Cell Above
Ctrl+’ Copy Formula from Cell Above
Shift Hold down shift for additional functions in Excel’s menu
Shift+F1 What’s This?
Shift+F2 Edit cell comment
Shift+F3 Paste function into formula
Shift+F4 Find Next
Shift+F5 Find
Shift+F6 Previous Pane
Shift+F8 Add to selection
Shift+F9 Calculate active worksheet
Ctrl+Alt+F9 Calculate 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.
Shift+F10 Display shortcut menu
Shift+F11 New worksheet
Shift+F12 Save
Ctrl+F3 Define name
Ctrl+F4 Close
Ctrl+F5 XL, Restore window size
Ctrl+F6 Next workbook window
Shift+Ctrl+F6 Previous workbook window
Ctrl+F7 Move window
Ctrl+F8 Resize window
Ctrl+F9 Minimize workbook
Ctrl+F10 Maximize or restore window
Ctrl+F11 Inset 4.0 Macro sheet
Ctrl+F12 File Open
Alt+F1 Insert Chart
Alt+F2 Save As
Alt+F4 Exit
Alt+F8 Macro dialog box
Alt+F11 Visual Basic Editor
Ctrl+Shift+F3 Create name by using names of row and column labels
Ctrl+Shift+F6 Previous Window
Ctrl+Shift+F12 Print
Alt+Shift+F1 New worksheet
Alt+Shift+F2 Save
Alt+= AutoSum
Ctrl+` Toggle Value/Formula display
Ctrl+Shift+A Insert argument names into formula
Alt+Down arrow Display AutoComplete list
Alt+’ Format Style dialog box
Ctrl+Shift+~ General format
Ctrl+Shift+! Comma format
Ctrl+Shift+@ Time format
Ctrl+Shift+# Date format
Ctrl+Shift+$ Currency format
Ctrl+Shift+% Percent format
Ctrl+Shift+^ Exponential format
Ctrl+Shift+& Place outline border around selected cells
Ctrl+Shift+_ Remove outline border
Ctrl+Shift+* Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report.
Ctrl++ Insert
Ctrl+- Delete
Ctrl+1 Format cells dialog box
Ctrl+2 Bold
Ctrl+3 Italic
Ctrl+4 Underline
Ctrl+5 Strikethrough
Ctrl+6 Show/Hide objects
Ctrl+7 Show/Hide Standard toolbar
Ctrl+8 Toggle Outline symbols
Ctrl+9 Hide rows
Ctrl+0 Hide columns
Ctrl+Shift+( Unhide rows
Ctrl+Shift+) Unhide columns
Alt or F10 Activate the menu
Ctrl+Tab In toolbar: next toolbar
In a workbook: activate next workbook
Shift+Ctrl+Tab In toolbar: previous toolbar
In a workbook: activate previous workbook
Tab Next tool
Shift+Tab Previous tool
Enter Do the command
Alt+Enter Start a new line in the same cell.
Ctrl+Enter Fill the selected cell range with the current entry.
Shift+Ctrl+F Font Drop Down List
Shift+Ctrl+F+F Font tab of Format Cell Dialog box
Shift+Ctrl+P Point size Drop Down List
Ctrl+Spacebar Select the entire column
Shift+Spacebar Select the entire row
CTRL+/ Select the array containing the active cell.
CTRL+SHIFT+O Select all cells that contain comments.
CTRL+\ In a selected row, select the cells that don’t match the formula or static value in the active cell.
CTRL+SHIFT+| In a selected column, select the cells that don’t match the formula or static value in the active cell.
CTRL+[ Select all cells directly referenced by formulas in the selection.
CTRL+SHIFT+{ Select all cells directly or indirectly referenced by formulas in the selection.
CTRL+] Select cells that contain formulas that directly reference the active cell.
CTRL+SHIFT+} Select cells that contain formulas that directly or indirectly reference the active cell.
ALT+; Select the visible cells in the current selection.
SHIFT+BACKSPACE With multiple cells selected, select only the active cell.
CTRL+SHIFT+SPACEBAR Selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet
Ctrl+A Select All
Ctrl+B Bold
Ctrl+C Copy
Ctrl+D Fill Down
Ctrl+F Find
Ctrl+G Goto
Ctrl+H Replace
Ctrl+I Italic
Ctrl+K Insert Hyperlink
Ctrl+N New Workbook
Ctrl+O Open
Ctrl+P Print
Ctrl+R Fill Right
Ctrl+S Save
Ctrl+U Underline
Ctrl+V Paste
Ctrl W Close
Ctrl+X Cut
Ctrl+Y Repeat
Ctrl+Z Undo
F1 Help
F2 Edit
F3 Paste Name
F4 Repeat last action
F4 While typing a formula, switch between absolute/relative refs
F5 Goto
F6 Next Pane
F7 Spell check
F8 Extend mode
F9 Recalculate all workbooks
F10 Activate Menubar
F11 New Chart
F12 Save As
Ctrl+: Insert Current Time
Ctrl+; Insert Current Date
Ctrl+" Copy Value from Cell Above
Ctrl+' Copy Formula from Cell Above
Shift Hold down shift for additional functions in Excel's menu
Shift+F1 What's This?
Shift+F2 Edit cell comment
Shift+F3 Paste function into formula
Shift+F4 Find Next
Shift+F5 Find
Shift+F6 Previous Pane
Shift+F8 Add to selection
Shift+F9 Calculate active worksheet
Ctrl+Alt+F9 Calculate 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.
Shift+F10 Display shortcut menu
Shift+F11 New worksheet
Shift+F12 Save
Ctrl+F3 Define name
Ctrl+F4 Close
Ctrl+F5 XL, Restore window size
Ctrl+F6 Next workbook window
Shift+Ctrl+F6 Previous workbook window
Ctrl+F7 Move window
Ctrl+F8 Resize window
Ctrl+F9 Minimize workbook
Ctrl+F10 Maximize or restore window
Ctrl+F11 Inset 4.0 Macro sheet
Ctrl+F12 File Open
Alt+F1 Insert Chart
Alt+F2 Save As
Alt+F4 Exit
Alt+F8 Macro dialog box
Alt+F11 Visual Basic Editor
Ctrl+Shift+F3 Create name by using names of row and column labels
Ctrl+Shift+F6 Previous Window
Ctrl+Shift+F12 Print
Alt+Shift+F1 New worksheet
Alt+Shift+F2 Save
Alt+= AutoSum
Ctrl+` Toggle Value/Formula display
Ctrl+Shift+A Insert argument names into formula
Alt+Down arrow Display AutoComplete list
Alt+' Format Style dialog box
Ctrl+Shift+~ General format
Ctrl+Shift+! Comma format
Ctrl+Shift+@ Time format
Ctrl+Shift+# Date format
Ctrl+Shift+$ Currency format
Ctrl+Shift+% Percent format
Ctrl+Shift+^ Exponential format
Ctrl+Shift+& Place outline border around selected cells
Ctrl+Shift+_ Remove outline border
Ctrl+Shift+* Select current region
Ctrl++ Insert
Ctrl+- Delete
Ctrl+1 Format cells dialog box
Ctrl+2 Bold
Ctrl+3 Italic
Ctrl+4 Underline
Ctrl+5 Strikethrough
Ctrl+6 Show/Hide objects
Ctrl+7 Show/Hide Standard toolbar
Ctrl+8 Toggle Outline symbols
Ctrl+9 Hide rows
Ctrl+0 Hide columns
Ctrl+Shift+( Unhide rows
Ctrl+Shift+) Unhide columns
Alt or F10 Activate the menu
Ctrl+Tab In toolbar: next toolbar
Shift+Ctrl+Tab In toolbar: previous toolbar
Ctrl+Tab In a workbook: activate next workbook
Shift+Ctrl+Tab In a workbook: activate previous workbook
Tab Next tool
Shift+Tab Previous tool
Enter Do the command
Alt+Enter Start a new line in the same cell.
Ctrl+Enter Fill the selected cell range with the current entry.
Shift+Ctrl+F Font Drop Down List
Shift+Ctrl+F+F Font tab of Format Cell Dialog box
Shift+Ctrl+P Point size Drop Down List
F1 Help
F2 View Object Browser
F3 Find Next
F4 Properies Window
F5 Run Sub/Form or Run Macro
F6 Switch Split Windows
F7 View Code Window
F8 Step Into
F9 Toggle Breakpoint
F10 Activate Menu Bar
Shift+F2 View definition
Shift+F3 Find Previous
Shift+F7 View Object
Shift+F8 Step Over
Shift+F9 Quick Watch
Shift+F10 Show Right Click Menu
Ctrl+F2 Focus To Object Box
Ctrl+F4 Close Window
Ctrl+F8 Run To Cursor
Ctrl+F10 Activate Menu Bar
Alt+F4 Close VBE
Alt+F6 Switch Between Last 2 Windows
Alt+F11 Return To Application
Ctrl+Shift+F2 Go to last position
Ctrl+Shift+F8 Step Out
Ctrl+Shift+F9 Clear All Breakpoints
Insert Toggle Insert Mode
Delete Delete
Home Move to beginning of line
End Move to end of line
Page Up Page Up
Page Down Page Down
Left Arrow Left
Right Arrow Right
Up Arrow Up
Down Arrow Down
Tab Indent
Enter New Line
BackSpace Delete Prev Char
Shift+Insert Paste
Shift+Home Select To Start Of Line
Shift+End Select To End Of Line
Shift+Page Up Select To Top Of Module
Shift+Page Down Select To End Of Module
Shift+Left Arrow Extend Selection Left 1 Char
Shift+Right Arrow Extend Selection Right 1 Char
Shift+Up Arrow Extend Selection Up
Shift+Down Arrow Extend Selection Down
Shift+Tab Outdent
Alt+Spacebar System Menu
Alt+Tab Cycle Applications
Alt+BackSpace Undo
Ctrl+A Select All
Ctrl+C Copy
Ctrl+E Export Module
Ctrl+F Find
Ctrl+G Immediate Window
Ctrl+H Replace
Ctrl+I Turn On Quick Info
Ctrl+J List Properties/Methods
Ctrl+L Show Call Stack
Ctrl+M Import File
Ctrl+N New Line
Ctrl+P Print
Ctrl+R Project Explorer
Ctrl+S Save
Ctrl+T Show Available Components
Ctrl+V Paste
Ctrl+X Cut
Ctrl+Y Cut Entire Line
Ctrl+Z Undo
Ctrl+Insert Copy
Ctrl+Delete Delete To End Of Word
Ctrl+Home Top Of Module
Ctrl+End End Of Module
Ctrl+Page Up Top Of Current Procedure
Ctrl+Page Down End Of Current Procedure
Ctrl+Left Arrow Move one word to left
Ctrl+Right Arrow Move one word to right
Ctrl+Up Arrow Previous Procedure
Ctrl+Down Arrow Next Procedure
Ctrl+Spacebar Complete Word
Ctrl+Tab Cycle Windows
Ctrl+BackSpace Delete To Start Of Word
Ctrl+Shift+I Parameter Info
Ctrl+Shift+J List Constants

Chuck Norris doesn't approve!!!

What The Fudge!!!!

IF

Show All
Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.

Use IF to conduct conditional tests on values and formulas.

Syntax

IF(logical_test,value_if_true,value_if_false)

Logical_test     is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.

Value_if_true     is the value that is returned if logical_test is TRUE. For example, if this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, then the IF function displays the text "Within budget". If logical_test is TRUE and value_if_true is blank, this argument returns 0 (zero). To display the word TRUE, use the logical value TRUE for this argument. Value_if_true can be another formula.

Value_if_false     is the value that is returned if logical_test is FALSE. For example, if this argument is the text string "Over budget" and the logical_test argument evaluates to FALSE, then the IF function displays the text "Over budget". If logical_test is FALSE and value_if_false is omitted, (that is, after value_if_true, there is no comma), then the logical value FALSE is returned. If logical_test is FALSE and value_if_false is blank (that is, after value_if_true, there is a comma followed by the closing parenthesis), then the value 0 (zero) is returned. Value_if_false can be another formula.

Remarks

Up to seven IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. (See Example 3 for a sample of nested IF functions.) If you want to test more than seven conditions, consider using the LOOKUP, VLOOKUP, or HLOOKUP function. (See Example 4 for a sample of the LOOKUP function.)
When the value_if_true and value_if_false arguments are evaluated, IF returns the value returned by those statements.
If any of the arguments to IF are arrays, every element of the array is evaluated when the IF statement is carried out.
Microsoft Excel provides additional functions that can be used to analyze your data based on a condition. For example, to count the number of occurrences of a string of text or a number within a range of cells, use the COUNTIF worksheet function. To calculate a sum based on a string of text or a number within a range, use the SUMIF worksheet function. Learn about calculating a value based on a condition.

Example...

1 2 3 4

A Score 45 90 78 Formula Description (Result) =IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))) Assigns a letter grade to the first score (F) =IF(A3>89,"A",IF(A3>79,"B", IF(A3>69,"C",IF(A3>59,"D","F")))) Assigns a letter grade to the second score (A) =IF(A4>89,"A",IF(A4>79,"B", IF(A4>69,"C",IF(A4>59,"D","F")))) Assigns a letter grade to the third score (C)

Enlightened

Relative & Absolute Cell References
     There are a variety of ways to express cell references. These dictate how they will be treated
when used in a function or formula that is to be copied. It is important to understand them to be
able to control the way you wish to have references behave. Relative addresses are dynamic
in nature and allow things to change when copied. Absolute addresses utilize the $ (dollar
sign) symbol, in one or more places, to limit which aspects of the cell reference may change
when copied. Selecting which type to use depends on the circumstances and desired results:
     1. Relative References require nothing to be changed to use them. In copying a function or
formula using a relative reference upward or downward, the row number can change. In
copying to the right or left, the column letter can change.
Examples
Original function: =SUM(A1:C1)
• Copied downward 1 row becomes =SUM(A2:C2)
• Copied to the right 1 column becomes =SUM(B1:D1)
     2. Full Absolute References lock to a specific cell on the sheet. When a function or formula
contains a reference of this kind and is copied, the copied version will still point to the
exact cell that the original function or formula used. It does not matter if the original is
copied to the left, right, up, or down:
Examples
Original function: =SUM($A$1:$C$1)
• Copied up or down remains =SUM($A$1:$C$1)
• Copied left or right remains =SUM($A$1:$C$1)
     3. Column Absolute References lock the alphabetic column designator so that it will not
change, but does not restrict the numeric row designator from changing:
Examples
Original function: =SUM($A1:$C1)
• Copied to the right or left remains =SUM($A1:$C1)
• Copied down 1 row becomes =SUM($A2:$C2)
     4. Row Absolute References lock the numeric row designator so that is will not change,
but does not restrict the alphabetic column designator from changing:
Examples
Original function: =SUM(A$1:C$1)
• Copied up or down remains =SUM(A$1:C$1)
• Copied right 1 column becomes =SUM(B$1:D$1)

TP!!!!

Sir Tom taught us how to write some of these...

You know those papers with full of explanations that when you read them your minds are gonna pop... Well... here they are.

A technical paper is like a report of something but longer... 

When you try to right one you should be like this...

You need to be at peace. If you don't you do this...

So there you have it. Now you have some knowledge about what Technical Papers are and what to do and what not to do while writing a technical paper. Thanks for reading!!

Microsoft Excel

Okay guys I shall stop with the explaining of things and lets get to the actual thing because I'm getting sick and tired of long and boring explanations. So... anyway this is Microsoft excel

Its kinda awesome because of how awesome it is!!!

Anyway... Microsoft excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Max OS X, It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. 

Now that we know what the excel is now lets know what it does. It has a battery of supplied functions to answer statistical, engineering, and financial needs. Okay guys that's all the time I have thanks for reading!!

Things...

In today's post we will talk about headers, footnotes, index, pagination, and all that fun stuff.

First thing first... a header is the the area the you always find on top of each page of a document like so...

Next is a footer. Basically its the opposite of a header. If the header is the area on top of the document the footer below the document like this... 

Ok third is about the footnotes like this...

Footnotes are a form of in-text citation that does not disrupt the flow of the text. Basically, at the end of a quotation or piece of information, you see a little number. If you look at the bottom of the page, you will see the same number followed by information.

Next is index. Indexes are an alphabetical list of names, subjects, etc., with references to the places where they occur, typically found at the end of a book. I'll give you an example...

They were easy confronting one at a time. But when I mixed them all up it was crazy as heck. It was more chaotic than the movie 2012!!! My mind wouldn't just settle down and think things through. My mind was like a super bouncy ball that is breaking things and travelling at the speed of light which is 299 792 458 m / s.

Well that was kinda informative... but anyway guys this is the end of the post and thanks for reading!!!

Challenge Accepted...

In the start of our 3rd quarter, Sir Tom has given us our 3rd quarter topics and requirements. The first thing in the list of topics is creating documents. What we need is to explain operationally the different parts of a word processor interface. OR in other words... how to use these bad boys... 

And I was like...meh...

And there started my EPIC journey towards the 3rd quarter....

(epic background music)