Explanation

• In MS Excel 2016, a Line Chart displays data points connected by lines.
• It is ideal for showing trends, patterns, or changes over time.
• Multiple data series can be plotted on the same line chart for comparison.

Explanation

• In MS Excel 2016, a Column Chart displays data as vertical bars.
• It is especially useful for comparing values across categories clearly.
• Column charts make it easy to visualize differences and trends at a glance.

Last verified on 10-03-2026

Explanation

• In MS Excel 2016, each cell is uniquely identified by its address.
• Address is a combination of column letter and row number.
• Example: A1 refers to the cell in Column A, Row 1.

Last verified on 10-03-2026

Explanation

• UNICODE() function returns the numeric Unicode value (code point) of the first character in a text string.
• It helps identify the character code used in Unicode encoding.
• Useful when working with different languages and symbols.

Last verified on 09-03-2026

Explanation

• DAYS360() function in MS Excel 2016 calculates the number of days between two dates based on a 360-day year.
• This method is commonly used in financial and accounting calculations.
• It assumes 12 months × 30 days = 360 days.

Last verified on 09-03-2026

Explanation

• Subtotal in MS Excel 2016 is used to automatically calculate totals for grouped data.
• It inserts subtotals and grand totals for selected categories or rows.
• This feature is useful when working with large datasets.

Last verified on 09-03-2026

Explanation

• Conditional Formatting in MS Excel 2016 is used to highlight cells based on specific conditions.
• It visually displays data trends using colors, data bars, and icon sets.
• This helps users quickly analyze large datasets.

Last verified on 09-03-2026

Explanation

• Pressing Ctrl + ; inserts the current date into the selected cell in Excel.
• The inserted date is static, it does not update automatically like =TODAY().

Additional information:

• Ctrl + Shift + ; – inserts current time
• =TODAY() – formula to insert current date dynamically
• =NOW() – formula for current date and time

Last verified on 08-03-2026

Explanation

• Data Form allows you to view, add, edit, or delete one record at a time in Excel.
• It is useful for large datasets where scrolling through rows is inconvenient.
• To use Data Form: Select data → Go to Data → Form

Last verified on 08-03-2026

Explanation

• AVERAGEIF calculates the average of cells that meet a specific condition.
• Formula: =AVERAGEIF(range, criteria, [average_range])
• Useful for conditional averaging in large datasets.

Last verified on 08-03-2026