NLC India Limited Industrial Trainee Interview Questions and Answers

GD on the Topic - Quality of coal is deteriorating, what should the company do?

Q1. What are interested in ?
Add your answer
Q2. Can you be on time ?
Add your answer

Q1. Calculate GST amount from the given data with excel.
Ans. 
Calculate GST amount from given data using Excel.
• Open Excel and enter the data in a table format

• Use the formula =Amount*(GST%)/100 to calculate GST amount

• Ensure that the cell format is set to currency

• Repeat the formula for all rows in the table

• Sum up the GST amount column to get the total GST amount
Answered by AI
Add your answer
Q2. Make all the department names into uppercase text on excel.
Ans. 
Convert department names to uppercase in Excel
• Select the column containing department names

• Click on the 'Home' tab in the Excel ribbon

• Click on the 'Uppercase' button in the 'Font' section

• Alternatively, use the 'UPPER' function in a new column to convert text to uppercase
Answered by AI
Add your answer
Q3. Do the subtotal of values given in the excel sheet with formulas.
Ans. 
Yes, the subtotal of values given in the excel sheet can be calculated using formulas.
• Use the SUM function to add up a range of cells

• Use the SUBTOTAL function to add up a range of cells while ignoring hidden rows

• Make sure to select the correct range of cells for accurate subtotals
Answered by AI
Add your answer
Q4. Change the date format to D-MM-YYYY
Ans. 
To change the date format to D-MM-YYYY, use the format function in the programming language of your choice.
• Use the format function to specify the desired format

• In Python: date.strftime('%d-%m-%Y')

• In JavaScript: date.toLocaleDateString('en-GB', {day: 'numeric', month: 'numeric', year: 'numeric'})

• In SQL: CONVERT(VARCHAR(10), date, 105)
Answered by AI
Add your answer

Normal GD.Just brush up contemporary topics

Q1. Tell me about yourself
Add your answer
Q2. Mechanical Engineering Technical questions related to refrigeration
Add your answer

Debate on multiple topics

Q1. Questions related to Operation Research
Add your answer

Come out with a conclusion and solutions to a problem

Q1. About previous experience, challenges and accolades.
Add your answer