DHL Supply Chain Inbound Supervisor Interview Questions and Answers

Knowledge of MS-Excel and Excel shortcuts is essential for an Inbound Supervisor.

• Familiarity with basic functions such as SUM, AVERAGE, COUNT, etc.

• Ability to use shortcuts such as Ctrl+C, Ctrl+V, Ctrl+Z, etc.

• Knowledge of advanced functions such as VLOOKUP, IF, INDEX, etc.

• Ability to create and format tables, charts, and graphs.

• Understanding of data analysis tools such as PivotTables and PivotCharts.

• Examples: Using Ctrl+...read more

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 ...read more

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.