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

=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

• 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

• In a spreadsheet, =A1+B1 tells the program to add the values in cells A1 and B1.
• The calculated result is displayed in cell C1.
• The + operator is used for addition.

Last verified on 01-09-2026