Can you please explain the functions of lookups, pivot

Question

Accepted Answer

Lookups and pivot tables are functions used in data analysis to organize and summarize large amounts of data.

Lookups are used to find specific data in a table based on certain criteria.
Pivot tables are used to summarize and analyze large amounts of data by organizing it into a more manageable format.
Lookups can be used to match data from one table to another, or to find specific values within a table.
Pivot tables can be used to analyze data by grouping it into categories, such as by date, product, or location.
Both functions are commonly used in Excel and other spreadsheet programs for data analysis and reporting.

Popular interview questions of Team Leader MIS