Skip to main content

HEC Jobs 2024 Online Apply Latest Advertisement

0

MS OFFICE ALL SHORTCUT KEYS And EXCEL FORMULAS

 

Education

MS OFFICE ALL SHORTCUT KEYS AND EXCEL FORMULAS

Here are the shortcut keys for Microsoft Word, Excel, PowerPoint, Access, OneNote, and Outlook:

Microsoft Word:

  • Ctrl + N: Create a new document.
  • Ctrl + O: Open an existing document.
  • Ctrl + S: Save the current document.
  • Ctrl + P: Print the current document.
  • Ctrl + Z: Undo the last action.
  • Ctrl + Y: Redo the last action.
  • Ctrl + X: Cut the selected text.
  • Ctrl + C: Copy the selected text.
  • Ctrl + V: Paste the cut or copied text.
  • Ctrl + F: Open the Find dialog box to search for text.
  • Ctrl + H: Open the Replace dialog box to find and replace text.
  • Ctrl + B: Apply or remove bold formatting.
  • Ctrl + I: Apply or remove italic formatting.
  • Ctrl + U: Apply or remove underline formatting.
  • Ctrl + L: Align text to the left.
  • Ctrl + E: Align text to the center.
  • Ctrl + R: Align text to the right.

Microsoft Excel:

  • Ctrl + N: Create a new workbook.
  • Ctrl + O: Open an existing workbook.
  • Ctrl + S: Save the current workbook.
  • Ctrl + P: Print the current workbook.
  • Ctrl + Z: Undo the last action.
  • Ctrl + Y: Redo the last action.
  • Ctrl + X: Cut the selected cells.
  • Ctrl + C: Copy the selected cells.
  • Ctrl + V: Paste the cut or copied cells.
  • Ctrl + F: Open the Find dialog box to search for data.
  • Ctrl + H: Open the Replace dialog box to find and replace data.
  • Ctrl + B: Apply or remove bold formatting.
  • Ctrl + I: Apply or remove italic formatting.
  • Ctrl + U: Apply or remove underline formatting.
  • F2: Edit the selected cell.

Microsoft PowerPoint:

  • Ctrl + N: Create a new presentation.
  • Ctrl + O: Open an existing presentation.
  • Ctrl + S: Save the current presentation.
  • Ctrl + P: Print the current presentation.
  • Ctrl + Z: Undo the last action.
  • Ctrl + Y: Redo the last action.
  • Ctrl + X: Cut the selected slides or objects.
  • Ctrl + C: Copy the selected slides or objects.
  • Ctrl + V: Paste the cut or copied slides or objects.
  • Ctrl + F: Open the Find dialog box to search for text.
  • Ctrl + B: Apply or remove bold formatting.
  • Ctrl + I: Apply or remove italic formatting.
  • Ctrl + U: Apply or remove underline formatting.
  • Ctrl + L: Align text or objects to the left.
  • Ctrl + E: Align text or objects to the center.
  • Ctrl + R: Align text or objects to the right.

Microsoft Access:

  • Ctrl + N: Create a new database.
  • Ctrl + O: Open an existing database.
  • Ctrl + S: Save the current database.
  • F11: Create a new table.
  • Ctrl + F: Open the Find dialog box to search for data.
  • Ctrl + P: Print the current object.
  • F5: Run a query, form, or report.
  • F12: Save the current object with a new name.
  • Ctrl + Z: Undo the last action.
  • Ctrl + Y: Redo the last action.
  • Ctrl + X: Cut the selected data or object.
  • Ctrl + C: Copy the selected data or object.
  • Ctrl + V: Paste the cut or copied data or object.

Microsoft OneNote:

  • Ctrl + N: Create a new note.
  • Ctrl + O: Open an existing notebook.
  • Ctrl + S: Save the current note.
  • Ctrl + P: Print the current note.
  • Ctrl + Z: Undo the last action.
  • Ctrl + Y: Redo the last action.
  • Ctrl + X: Cut the selected text or object.
  • Ctrl + C: Copy the selected text or object.
  • Ctrl + V: Paste the cut or copied text or object.
  • Ctrl + F: Open the Find dialog box to search for text.
  • Ctrl + B: Apply or remove bold formatting.
  • Ctrl + I: Apply or remove italic formatting.
  • Ctrl + U: Apply or remove underline formatting.

Microsoft Outlook:

  • Ctrl + N: Create a new email.
  • Ctrl + R: Reply to the selected email.
  • Ctrl + F: Forward the selected email.
  • Ctrl + S: Save the current email.
  • Ctrl + P: Print the current email.
  • Ctrl + Z: Undo the last action.
  • Ctrl + Y: Redo the last action.
  • Ctrl + X: Cut the selected text.
  • Ctrl + C: Copy the selected text.
  • Ctrl + V: Paste the cut or copied text.
  • Ctrl + F: Open the Find dialog box to search for text.
  • Ctrl + Shift + M: Create a new appointment.
  • Ctrl + Shift + C: Create a new contact.
  • Ctrl +I apologize for the incomplete response.

 

 

Here are some commonly used Excel formulas:

  1. SUM: Adds a range of cells together.
    Example: =SUM(A1:A10)
  2. AVERAGE: Calculates the average of a range of cells.
    Example: =AVERAGE(A1:A10)
  3. COUNT: Counts the number of cells in a range that contain numbers.
    Example: =COUNT(A1:A10)
  4. MAX: Returns the maximum value in a range of cells.
    Example: =MAX(A1:A10)
  5. MIN: Returns the minimum value in a range of cells.
    Example: =MIN(A1:A10)
  6. IF: Performs a logical test and returns one value if the condition is true and another value if the condition is false.
    Example: =IF(A1>10, “Greater than 10”, “Less than or equal to 10”)
  7. VLOOKUP: Searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
    Example: =VLOOKUP(A1, B1:C10, 2, FALSE)
  8. CONCATENATE: Combines multiple text strings into one.
    Example: =CONCATENATE(“Hello”, ” “, “World”)
  9. TODAY: Returns the current date.
    Example: =TODAY()
  10. NOW: Returns the current date and time.
    Example: =NOW()
  11. COUNTIF: Counts the number of cells within a range that meet a specific criterion.
    Example: =COUNTIF(A1:A10, “>50”)
  12. SUMIF: Adds the cells within a range that meet a specific criterion.
    Example: =SUMIF(A1:A10, “>50”)
  13. AVERAGEIF: Calculates the average of the cells within a range that meet a specific criterion.
    Example: =AVERAGEIF(A1:A10, “>50”)
  14. IFERROR: Returns a value if a formula results in an error, otherwise returns the result of the formula.
    Example: =IFERROR(A1/B1, “Error”)

Tags:

Comments

Post a Comment