What is loop in Excel ? What is pivot table ? If else formulas

Question

Accepted Answer

Loop in Excel is a repetitive process that allows you to perform a task multiple times.

Loops are used to automate repetitive tasks in Excel
There are two types of loops in Excel: For loop and While loop
For example, you can use a loop to print a list of numbers from 1 to 10
Pivot table is a data summarization tool in Excel
It allows you to quickly summarize and analyze large amounts of data
You can use pivot tables to create reports, charts, and graphs
If-else formulas are used to make decisions based on certain conditions
For example, you can use an if-else formula to calculate a bonus based on sales performance

Top HR questions asked in Agnihotri Group Of Institutions Clerk Staff