Explanation

=SUM(A1:A3) means add A1 + A2 + A3

A1 = 2  

A2 = 4  

A3 = 6  

2 + 4 + 6 = 12

Last verified on 04-09-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

• COUNTA() counts only non-empty cells in a selected range.
• It counts cells containing numbers, text, logical values (TRUE/FALSE), errors, and formulas that return values.
• It does not count completely empty cells.
• COUNTA() is commonly used for counting filled entries in datasets.

Additional information:

• COUNT() → Counts only numeric cells
• COUNTBLANK() → Counts empty (blank) cells
• COUNTIF() → Counts cells matching a specific condition
• COUNTIFS() → Counts cells matching multiple conditions

Last verified 08-07-2026

Explanation

• F11 creates a chart from the selected data and places it on a new chart sheet.
• Alt + F1 creates a chart directly on the current worksheet.

Last verified on 07-09-2026

Explanation

Order of arguments:

• First argument: Range – the cells you want to count
• Second argument: Criteria – the condition that defines which cells to count
• Example:
• =COUNTIF(A1:A10, ">20") counts how many cells in range A1 to A10 have a value greater than 20.

Last verified on 05-09-2026

Explanation

• In MS Excel, pressing Enter after entering data normally moves the selection one cell down.
• This is the default direction of movement after pressing Enter.

Additional information:

• Tab → Cell to the right.
• Shift + Enter → Cell directly above.
• Shift + Tab → Cell to the left.
• F2 → Edit the active cell.

Last verified on 03-09-2026

Explanation

• Conditional formatting highlights cells automatically based on set conditions or rules (e.g., values greater than 100).
• It helps in quickly analyzing data trends by using colors, icons, or data bars.

Last verified on 02-09-2026

Explanation

• The active cell is the currently selected cell in a spreadsheet.
• It is usually highlighted with a heavy/thick border.
• Data entered from the keyboard is placed into the active cell.
• Only one cell is normally active at a time.

Last verified on 26-08-2026

Explanation

• In Excel, pressing Enter normally moves the active cell down one row.
• If the current cell is B4, pressing Enter moves the selection to B5.
• This is the default behavior unless the Enter key direction has been changed in Excel settings.

Last verified on 26-08-2026

Explanation

• The keyboard shortcut to select an entire row in Microsoft Excel is Shift + Spacebar.
• This command selects all cells in the current active row.
• For highlighting a column, CTRL+space is used.

Last updated by NS on 06 May 2026