Explanation

• In Microsoft Excel, the SUM function is used for addition.
• It adds numbers in a selected range of cells.
• Example: =SUM(A1:A5) adds values from A1 to A5.

Additional information:

• AVERAGE → calculates mean
• COUNT → counts numbers
• MAX → finds highest value
• MIN → finds lowest value
• PRODUCT → multiplies values

Last verified on 19-04-2026

Explanation

• Microsoft Excel provides tools to organize and view data efficiently.
• Filter allows users to display only specific data based on criteria without deleting rows.
• It helps in analyzing large datasets easily.

Last verified on 04-04-2026

Explanation

• Microsoft Excel provides tools to control and manage user input.
• Data Validation is used to create drop-down lists based on cell values.
• It helps ensure accurate and consistent data entry.

Last verified on 04-04-2026

Explanation

• Microsoft Excel provides features to automate data entry and save time.
• The Fill Handle is used to quickly fill a series like numbers, dates, or patterns by dragging.
• It appears as a small square at the bottom-right corner of a selected cell.

Last verified on 04-04-2026

Explanation

Explanation

• To split windows or document panes into two in applications like Excel or Word, use the View > Window > Split menu option.
• This command divides the active document window into separate

Explanation

• In MS Excel, to sum values in a range based on a condition, the SUMIF() function is used.
• It allows you to add only the numbers that meet a specific criterion, such as all sales above 1000 or only a certain category.
• This is different from SUM(), which adds all numbers in a range without any condition.

Last verified on 11-03-2026

Explanation

• In MS Excel, a pre-programmed formula is called a Function.
• Functions perform specific calculations or tasks automatically, such as SUM, AVERAGE, or IF.
• They save time by automating repetitive formulas and reducing errors.

Last verified on 11-03-2026

Explanation

• In MS Excel, different functions are used to handle dates and times.
• To display the current date and time, the NOW() function is used.

Additional information:

• DATE() – Returns a date based on year, month, and day
• TODAY() – Returns today’s date only
• TIME() – Constructs a specific time from hours, minutes, and seconds

Last verified on 11-03-2026

Explanation

• In MS Excel 2016, the UPPER() function is used to convert text to uppercase letters.
• It changes all lowercase characters in a cell to capital letters.

Additional information:

• LOWER() – Converts text to lowercase
• PROPER() – Capitalizes the first letter of each word

Last verified on 11-03-2026