Inbound Supervisor Interview Questions and Answers for Freshers

Yes, I am familiar with vlookup, pivot table, and consolidated.

• I have used vlookup to search for specific data in a large dataset.

• I have used pivot tables to summarize and analyze data.

• I have used consolidated to combine data from multiple sources.

• I am comfortable using these tools in Microsoft Excel.

MS-Excel uses various rules for data manipulation and formatting.

• Excel uses formulas and functions to perform calculations and manipulate data.

• Conditional formatting rules can be applied to highlight specific data based on certain criteria.

• Data validation rules can be set to restrict the type of data that can be entered in a cell.

• Sorting and filtering rules can be applied to organize and analyze data.

• Pivot table rules can be used to summarize and analyze large amounts of data...read more