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

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