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

• Justify alignment spreads the text across the width of the cell by aligning it evenly.
• It adjusts text so that both the left and right edges appear aligned.
• This option is mainly used for long text in wrapped cells.

Additional information:

• Center: Places text in the middle of the cell.
• Distributed: Spreads characters evenly within the cell.
• Wrap Text: Displays long text on multiple lines within the same cell.

Last verified on 18-07-2026

Explanation

• Both the Worksheet and the Workbook can be renamed in Microsoft Excel.
• A worksheet name can be changed by double-clicking its sheet tab.
• A workbook can be renamed by changing its file name.
• Renaming helps organize and identify files and sheets easily.

Last verified on 18-07-2026

Explanation

• Microsoft Excel is a widely used electronic spreadsheet software.
• It is a core application in Microsoft Office
• Release: September 30, 1985
• Written in: C++ (back-end)

Last updated 17 july 2026 by NA

Explanation

• Alt + F4 is used to close the Excel window/application.

Additional information:

• Ctrl + W → Close the current workbook/window
• Ctrl + F5 → Restore workbook window size
• Ctrl + S → Save workbook
• Ctrl + N → New workbpook

Last verified on 15-07-2026

Explanation

• In MS Excel, numbering from a specific number is started by entering the starting number and using the Fill Handle.
• The Fill Handle helps to continue a series of numbers automatically.
• It is used by dragging the small square at the bottom-right corner of a selected cell.

Last verified on 10-07-2026

Explanation

• A macro is an automated sequence of commands used to perform repetitive tasks quickly in software applications.
• It saves time by executing multiple steps with a single command.
• Commonly used in MS Word, Excel, and other office software.
• It can be recorded or programmed by the user.

Last verified on 21-06-2026

Explanation

• The IF function in MS Excel is used to perform conditional logic by testing whether a condition is TRUE or FALSE.
• It returns one value if the condition is true and another value if it is false.
• The IF function is one of the most commonly used logical functions in Excel.
• It helps automate calculations and decision-making.

Last verified on 08-07-2026

Explanation

• HLOOKUP searches for a value in the first horizontal row of a table and returns a value from a specified row in the same column.
• The "H" in HLOOKUP stands for Horizontal.
• It is used when data is arranged across rows instead of down columns.
• HLOOKUP is useful for looking up values in horizontally organized tables.

Additional information:

• VLOOKUP → Searches in a vertical (first) column

Last verified on 08-07-2026