Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    All Shortcut Keys of MS WORD

    Uploaded by

    Ikram Marwat
    The document lists shortcut keys for Microsoft Word. It provides over 20 shortcut keys that can be used to perform common formatting and document editing tasks such as selecting all text, copying, pasting, bolding, italics, and undoing/redoing actions. The IF function in Excel evaluates a condition and returns one value if the condition is true and another value if the condition is false. It can be nested to evaluate multiple conditions in sequence.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    All Shortcut Keys of MS WORD

    Uploaded by

    Ikram Marwat
    3 views5 pages
    The document lists shortcut keys for Microsoft Word. It provides over 20 shortcut keys that can be used to perform common formatting and document editing tasks such as selecting all text, copying, pasting, bolding, italics, and undoing/redoing actions. The IF function in Excel evaluates a condition and returns one value if the condition is true and another value if the condition is false. It can be nested to evaluate multiple conditions in sequence.

    Original Title

    All Shortcut keys of MS WORD

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document lists shortcut keys for Microsoft Word. It provides over 20 shortcut keys that can be used to perform common formatting and document editing tasks such as selecting all text, copying, pasting, bolding, italics, and undoing/redoing actions. The IF function in Excel evaluates a condition and returns one value if the condition is true and another value if the condition is false. It can be nested to evaluate multiple conditions in sequence.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    3 views5 pages

    All Shortcut Keys of MS WORD

    Uploaded by

    Ikram Marwat
    The document lists shortcut keys for Microsoft Word. It provides over 20 shortcut keys that can be used to perform common formatting and document editing tasks such as selecting all text, copying, pasting, bolding, italics, and undoing/redoing actions. The IF function in Excel evaluates a condition and returns one value if the condition is true and another value if the condition is false. It can be nested to evaluate multiple conditions in sequence.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 5

    All Shortcut keys of MS WORD

     Control + A: Highlights & Selects all text in a document.


     Control + B: Emboldens selected text.
     Control + C: Copies selected text to clipboard.
     Control + D: Opens the Font Formatting window.
     Control + E: Toggles text between Align-Left and Centered.
     Control + F: Opens a Find field.
     Control + G: Moves to the next result after using the Find tool.
     Control + H: Opens the Find & Replace tool.
     Control + I: Italicizes selected text.
     Control + J: Toggles text between Align-Left and Justified.
     Control + K: Inserts a hyperlink into your document.
     Control + L: Toggles text between Align-Left and Justified.
     Control + M: Indent entire paragraph.
     Control + N: Opens a new document.
     Control + O: Opens the Open File window.
     Control + P: Opens the Print options window.
     Control + Q: Removes paragraph formatting (indentation/spacing).
     Control + R: Toggles text between Align-Left and Align-Right.
     Control + S: Opens the Save window.
     Control + T: Creates a hanging indent.
     Control + U: Underlines selected text.
     Control + V: Pastes text from clipboard into the document.
     Control + W: Closes the open document
     Control + X: Cuts selected text, saving it to the clipboard.
     Control + Y: Redo the action that was just Undone (see next
    shortcut).
     Control + Z: Undo the last action taken.
    MS EXCEL FORMULAS

    IF( condition, value_if_true, [value_if_false] )

    Parameters or Arguments
    condition
    The value that you want to test.
    value_if_true
    It is the value that is returned if condition evaluates to TRUE.
    value_if_false
    Optional. It is the value that is returned if condition evaluates to FALSE.

    Returns
    The IF function returns value_if_true when the condition is TRUE.
    The IF function returns value_if_false when the condition is FALSE.
    The IF function returns FALSE if the value_if_false parameter is omitted and the
    condition is FALSE.

    Example (as Worksheet Function)


    Let's explore how to use the IF function as a worksheet function in Microsoft Excel.

    Based on the Excel spreadsheet above, the following IF examples would return:
    =IF(B2<10, "Reorder", "")
    Result: "Reorder"

    =IF(A2="Apples", "Equal", "Not Equal")


    Result: "Equal"

    =IF(B3>=20, 12, 0)
    Result: 12
    IF( condition1, value_if_true1, IF( condition2, value_if_true2,
    value_if_false2 ))

    This would be equivalent to the following IF THEN ELSE statement:

    IF condition1 THEN
    value_if_true1
    ELSEIF condition2 THEN
    value_if_true2
    ELSE
    value_if_false2
    END IF

    Parameters or Arguments
    condition
    The value that you want to test.
    value_if_true
    The value that is returned if condition evaluates to TRUE.
    value_if_false
    The value that is return if condition evaluates to FALSE.
    Note
     This Nested IF function syntax demonstrates how to nest two IF functions. You can nest
    up to 7 IF functions.

    Applies To
     Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel
    2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

    Type of Function
     Worksheet function (WS)

    Example (as Worksheet Function)


    Let's look at an example to see how you would use a nested IF and explore how to use
    the nested IF function as a worksheet function in Microsoft Excel:

    Based on the Excel spreadsheet above, the following Nested IF examples would return:
    =IF(A1="10x12",120,IF(A1="8x8",64,IF(A1="6x6",36)))
    Result: 120

    =IF(A2="10x12",120,IF(A2="8x8",64,IF(A2="6x6",36)))
    Result: 64

    =IF(A3="10x12",120,IF(A3="8x8",64,IF(A3="6x6",36)))
    Result: 36

    You might also like