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

Explanation

• Function: COUNT
• Purpose: Counts cells containing numbers only
• Syntax: =COUNT(range)
• Example: =COUNT(A1:A10)
• Ignores: Text, blank cells, and logical values (TRUE/FALSE)

Additional information:

• COUNTA → Counts all non-empty cells.
• COUNTIF → Counts cells that meet a specific condition.
• COUNTIFS → Counts cells meeting multiple conditions.
• COUNTBLANK → Counts blank cells.

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