Explanation

• Pressing the Alt key alone does not edit the contents of a cell.
• The Alt key is mainly used to access the Ribbon shortcuts and menu commands.
• In MS Excel, you can edit a cell by double-clicking the cell, pressing F2, or clicking in the Formula Bar.

Last verified on 21-07-2026

Explanation

• Pressing F2 allows you to edit the contents or formula of the current cell in MS Excel.

Additional information:

• F4: Repeat last action / toggle absolute and relative references
• CTRL + 1: Opens Format Cells dialog
• CTRL + F: Opens Find dialog
• Works in: Excel 2007, 2010, 2013, 2016, 2019, 365

Last verified on 12-03-2026

Explanation

• Shift + F10 displays the Shortcut (Context) Menu, just like a right-click with the mouse.

Additional information:

• Alt + Space → Display the Control Menu
• Alt + F4 → Close the Active Window
• Ctrl + C → Copy
• Ctrl + V → Paste

Last verified on 19-07-2026

Explanation

• The MAX function returns the largest value in a set of numbers in Excel.
• It compares all selected values and displays the highest one.
• It is commonly used for finding the maximum score, salary, or price.

Additional information:

• MIN() → Returns the smallest value
• AVERAGE() → Returns the average value
• COUNT() → Counts cells containing numbers
• SUM() → Adds all numbers

Last verified on 18-07-2026

Explanation

• The dollar sign ($) is used to create an absolute cell reference in MS Excel.

Additional information:

• Absolute Reference: $D$2 (Row and column fixed)
• Relative Reference: D2 (Row and column change)
• Mixed Reference: $D2 (Column fixed)
• Mixed Reference: D$2 (Row fixed)
• Shortcut Key: F4 toggles between reference types.

Last verified on 18-07-2026