Explanation

In spreadsheets or programming, a function is a pre-defined formula that calculates values in a specific order.

Functions simplify calculations by automating repetitive tasks.

They are used in Excel, Google Sheets, and programming languages.

Additional information:

• Examples of functions: SUM(), AVERAGE(), MAX() in Excel.
• Pre-defined formulas save time and reduce errors compared to manual calculations.

Last verified on 16-01-2026

Explanation

A pie chart is best suited for showing the proportion of parts to a whole.

As it visually represents data as slices of a circle.

It highlighting the relative sizes of components.

Explanation

VLOOKUP requires a table array, the lookup value, and the column index number to retrieve corresponding data.

It searches vertically in the first column of the table array.

An optional range_lookup argument can specify exact or approximate matches.

Explanation

A macro is an automated sequence of commands in applications like Word or Excel to perform repetitive tasks.

It helps save time and reduce manual effort.

Macros can be recorded or written using programming languages like VBA (Visual Basic for Applications).

Explanation

Copilot is an AI assistant available across the Microsoft 365 suite (which includes Word and Excel) to help with tasks like generating text, analyzing data, and automating workflows.