BHEL Industrial Trainee Interview Questions, Process, and Tips

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

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

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

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)