Upload Button Icon Add office photos

Filter interviews by

Theeta Electricals MIS Executive Interview Questions, Process, and Tips

Updated 17 Feb 2023

Theeta Electricals MIS Executive Interview Experiences

1 interview found

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 12 Jun 2021

I applied via Recruitment Consulltant and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

5 Questions

  • Q1. Do you know?, How to use countif formula in Excel?
  • Ans. 

    Countif formula is used to count the number of cells in a range that meet a specific condition.

    • Syntax: =COUNTIF(range, criteria)

    • Range can be a single cell or a range of cells

    • Criteria can be a number, text, cell reference, or expression

    • Examples: =COUNTIF(A1:A10,">50") will count the number of cells in range A1:A10 that are greater than 50

    • =COUNTIF(B1:B10,"apples") will count the number of cells in range B1:B10 that conta

  • Answered by AI
  • Q2. How to summarise data?
  • Ans. 

    Data can be summarised by using statistical measures like mean, median, mode, and range.

    • Identify the purpose of the summary

    • Choose appropriate statistical measures

    • Calculate the measures

    • Present the summary in a clear and concise manner

    • Use visual aids like charts and graphs if necessary

  • Answered by AI
  • Q3. How to use Vlookup and Hlookup?
  • Ans. 

    Vlookup and Hlookup are Excel functions used to search for specific data in a table and return corresponding values.

    • Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column.

    • Hlookup searches for a value in the first row of a table and returns a value in the same column from a specified row.

    • Both functions require a lookup value, table array, column index numb...

  • Answered by AI
  • Q4. How to use data validation?
  • Ans. 

    Data validation is used to ensure that data entered into a system meets certain criteria.

    • Data validation can be used to prevent errors and ensure accuracy.

    • It can be used to restrict input to certain values or formats.

    • Examples include validating email addresses, phone numbers, and dates.

    • Data validation can also be used to ensure that required fields are filled out.

    • It can be implemented through programming or through bui

  • Answered by AI
  • Q5. How to use importrange function in Google sheet?
  • Ans. 

    Importrange function is used to import data from one Google sheet to another.

    • Open the Google sheet where you want to import data

    • In a cell, type =importrange("spreadsheet_url", "Sheet1!A1:B10")

    • Replace spreadsheet_url with the URL of the sheet you want to import from

    • Replace Sheet1!A1:B10 with the range of cells you want to import

    • Click enter and grant access to the sheet you want to import from

    • Data from the specified rang...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - First prepare for interview as per your job position and responsibilities.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Referral and was interviewed before Jul 2020. There was 1 interview round.

Interview Questionnaire 

6 Questions

  • Q1. How to book depreciation on fixed assets?
  • Ans. 

    Depreciation on fixed assets can be booked using various methods such as straight-line, reducing balance, and sum-of-the-years' digits.

    • Depreciation is the allocation of the cost of a fixed asset over its useful life.

    • Straight-line method charges an equal amount of depreciation each year.

    • Reducing balance method charges a higher amount of depreciation in the early years and lower in later years.

    • Sum-of-the-years' digits me...

  • Answered by AI
  • Q2. Can we raise a debit note ? How can it's file on GST portal ?
  • Ans. 

    Yes, a debit note can be raised and filed on the GST portal.

    • A debit note can be raised when there is an increase in the value of taxable supply.

    • It can be filed on the GST portal by logging in and selecting the 'Debit Note' option.

    • The details of the debit note such as the recipient's GSTIN, invoice number, and date must be provided.

    • The debit note must also be linked to the original invoice for which it is being raised.

    • O...

  • Answered by AI
  • Q3. What's bank reconciliation?
  • Ans. 

    Bank reconciliation is the process of comparing a company's bank statement with its own financial records to ensure accuracy.

    • Bank reconciliation involves comparing the bank statement with the company's own financial records.

    • It helps to identify any discrepancies or errors in the financial records.

    • The process involves matching transactions, such as deposits and withdrawals, between the two records.

    • Any differences are th...

  • Answered by AI
  • Q4. How many types of TDS return ?
  • Ans. 

    There are 4 types of TDS return.

    • Form 24Q for salaries

    • Form 26Q for payments other than salaries

    • Form 27Q for payments made to non-residents

    • Form 27EQ for TCS

  • Answered by AI
  • Q5. What is rate of ESIC and EPFO contribution employer and employee ?
  • Ans. 

    ESIC and EPFO contribution rates for employer and employee.

    • ESIC contribution rate for employer is 3.25% and for employee is 0.75% of the employee's salary.

    • EPFO contribution rate for employer is 12% and for employee is 12% of the employee's basic salary.

    • ESIC is applicable for employees earning up to Rs. 21,000 per month and EPFO is applicable for all employees.

    • Employers with less than 10 employees can opt for the Atal P

  • Answered by AI
  • Q6. Threshold limit of TDS
  • Ans. 

    Threshold limit of TDS refers to the maximum amount of tax that can be deducted at source.

    • The threshold limit for TDS varies depending on the type of payment being made.

    • For example, the threshold limit for TDS on salary payments is Rs. 2.5 lakhs per annum.

    • For TDS on rent payments, the threshold limit is Rs. 2.4 lakhs per annum.

    • If the payment exceeds the threshold limit, TDS is deducted at the applicable rate.

    • The thresh...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was too top. It lasted for 3 hours.

Interview Questionnaire 

2 Questions

  • Q1. In the Technical Interview, the Interviewer asked me about my projects in Power Electronics and my experience in the previous organization. Questions related to Power Electronics basics and PCB Design alon...
  • Q2. In this round, I was asked to tell me about myself, family, experience in previous organization, job role and why work with us and expectations from the company. Also the HR will briefly tell you about the...

Interview Preparation Tips

Round: Test
Experience: Aptitude Test consisting of Verbal, Reasoning and Logic questions along with some Technical Questions which requires a good preparation.
Study well for the test to get to the next round.

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Process knowledge on Electroplating Process from start to end
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared on your strong areas and be confident
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain Your project
  • Ans. 

    Developed a mobile app for tracking daily water intake and setting hydration goals.

    • Designed user-friendly interface for inputting water consumption

    • Implemented reminder notifications to encourage regular hydration

    • Included visual graphs to track daily, weekly, and monthly water intake

    • Integrated with wearable devices to sync hydration data

  • Answered by AI
  • Q2. What is SMPS? Explain its working
  • Ans. 

    SMPS stands for Switched Mode Power Supply. It is a type of power supply that uses switching devices to convert electrical power efficiently.

    • SMPS converts AC voltage to DC voltage through a series of switching components

    • It operates by rapidly switching the input voltage on and off at a high frequency

    • SMPS are more efficient and lighter than traditional linear power supplies

    • Examples of SMPS include laptop chargers, LED d

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Sep 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Asking purchase department related department questions
  • Ans. I full filled their questions against answers
  • Answered Anonymously
  • Q2. PO & PR process i explain

Interview Preparation Tips

Interview preparation tips for other job seekers - must awre of current Applying job related
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Stores SOP,describe the process to control shrinkage . before company work experience
  • Ans. 

    The process to control shrinkage in stores involves implementing strict inventory management procedures and conducting regular audits.

    • Implementing a system for tracking inventory levels and monitoring stock movement

    • Conducting regular audits to identify any discrepancies or losses

    • Training staff on proper inventory management procedures and the importance of minimizing shrinkage

    • Implementing security measures such as CCTV...

  • Answered by AI
  • Q2. Company culture and the salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Find a job with both salary and work satisfaction.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jun 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - HR 

(3 Questions)

  • Q1. Explain your Masters project.
  • Q2. Tell about your self
  • Q3. Explain your Bachelors Project.

Interview Preparation Tips

Interview preparation tips for other job seekers - Do understand your project clearly and explain it with confidence.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Technical field related for technical condidate
Round 3 - Technical 

(1 Question)

  • Q1. Head of department telling technical questions related field
Round 4 - HR 

(1 Question)

  • Q1. General information and documents
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Group Discussion 

Regarding electrical project related discussion

Theeta Electricals Interview FAQs

How to prepare for Theeta Electricals MIS Executive interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Theeta Electricals. The most common topics and skills that interviewers at Theeta Electricals expect are Advanced Excel, VLOOKUP, Conditional Formatting, ERP and Formulas.
What are the top questions asked in Theeta Electricals MIS Executive interview?

Some of the top questions asked at the Theeta Electricals MIS Executive interview -

  1. How to use importrange function in Google she...read more
  2. Do you know?, How to use countif formula in Exc...read more
  3. How to use Vlookup and Hlook...read more

Tell us how to improve this page.

Theeta Electricals MIS Executive Reviews and Ratings

based on 2 reviews

3.0/5

Rating in categories

2.0

Skill development

2.0

Work-life balance

2.0

Salary

1.0

Job security

2.0

Company culture

2.0

Promotions

2.0

Work satisfaction

Explore 2 Reviews and Ratings
Production Engineer
29 salaries
unlock blur

₹1.8 L/yr - ₹4.8 L/yr

Purchase Executive
14 salaries
unlock blur

₹2.2 L/yr - ₹4.2 L/yr

Senior Production Engineer
11 salaries
unlock blur

₹3.2 L/yr - ₹4.8 L/yr

Quality Engineer
8 salaries
unlock blur

₹2.5 L/yr - ₹4 L/yr

Production Supervisor
6 salaries
unlock blur

₹1.8 L/yr - ₹2 L/yr

Explore more salaries
Compare Theeta Electricals with

GAO Tek

4.4
Compare

Amphenol Interconnect

4.2
Compare

Kyungshin Industrial Motherson

3.4
Compare

Electrical Research & Development Association

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview