Life Care Logistic Interview Questions, Process, and Tips

To check stock in SAP, use transaction code MMBE.

• Open SAP and go to the main menu

• Click on Logistics > Materials Management > Inventory Management > Environment > Stock

• Enter the material number and plant code

• Click on Execute

• The stock information will be displayed

Vlookup function is applied in Excel to search for a specific value in a table and return a corresponding value from another column.

• Select the cell where you want the result to appear

• Type =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Replace lookup_value with the value you want to search for

• Replace table_array with the range of cells that contains the data

• Replace col_index_num with the column number...read more

Yes, Pivot Table is a data summarization tool used in spreadsheet programs.

• Pivot Table allows users to group and summarize large amounts of data in a spreadsheet.

• It can be used to create reports, charts, and graphs based on the summarized data.

• Users can easily filter, sort, and rearrange the data to get the desired results.

• For example, a sales team can use Pivot Table to analyze their sales data by region, product, or

Yes, I have basic Excel knowledge.

• I am familiar with creating and editing spreadsheets

• I can use basic functions such as SUM, AVERAGE, and COUNT

• I know how to format cells and apply conditional formatting

• I am able to create charts and graphs to visualize data

• I am comfortable with sorting and filtering data

• I can use basic formulas such as IF, VLOOKUP, and HLOOKUP