Explanation

• Excel 2007–2026 (Default): .xlsx

Additional information:

• Excel 97–2003 (Default): .xls
• Excel Macro-Enabled Workbook: .xlsm
• Excel Binary Workbook: .xlsb
• Excel Template: .xltx

Last verified on 12-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