AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Theeta Electricals MIS Executive Interview Questions, Process, and Tips
Theeta Electricals MIS Executive Interview Experiences
1 interview found
Anonymous
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
- 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
- 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...
- 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
- 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...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
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...
- 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...
- 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...
- 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
- 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
- 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...
Interview Preparation Tips
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Spark architecture
- Q2. Sql problems on cross join
- Ans.
Understanding cross joins in SQL and their implications on data retrieval.
A cross join produces a Cartesian product of two tables, combining every row from the first table with every row from the second.
Example: If Table A has 2 rows and Table B has 3 rows, a cross join will result in 2 * 3 = 6 rows.
Cross joins can lead to large result sets, which may impact performance and readability.
Use cross joins cautiously, typic...
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
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.
Selected
I applied via Recruitment Consulltant and was interviewed in Aug 2023. There were 2 interview rounds.
(1 Question)
- Q1. Process knowledge on Electroplating Process from start to end
(1 Question)
- Q1. Salary discussion
Interview Preparation Tips
Zarin Tasnim Khan
Selected
(1 Question)
- Q1. Basic question about HR
Explain own strength and weakness
Interview Preparation Tips
Selected
I appeared for an interview before Feb 2024.
(1 Question)
- Q1. What do you know about hr
- Ans.
HR, or Human Resources, is a department within a company responsible for managing employee relations, recruitment, training, and other related tasks.
HR is responsible for recruiting and hiring new employees.
HR handles employee relations, including conflict resolution and disciplinary actions.
HR manages employee benefits and compensation.
HR is involved in training and development programs for employees.
HR ensures compli...
Interview Preparation Tips
Selected
I applied via Job Fair and was interviewed in Nov 2023. There were 2 interview rounds.
(4 Questions)
- Q1. Communication is a top skill wanted by employers. How is this important with regards to the HR?
- Q2. Why you are interested in working in HR?
- Q3. What other skills do you think an HR should have to be successful at what they do?
- Q4. How receptive are you to receiving feedback?
I applied via Recruitment Consulltant and was interviewed in Nov 2023. There were 2 interview rounds.
(4 Questions)
- Q1. Did you do any recharge of Gao tek inc?
- Ans.
No, I did not do any recharge of Gao tek inc.
I did not have any involvement in recharging Gao tek inc.
I did not perform any financial transactions related to Gao tek inc.
I did not have access to Gao tek inc's recharge systems.
- Q2. Can you please introduce your self?
- Q3. How would you manage time schedule for this internship?
- Q4. What do you think why we should hire you as our intern?
Interview Preparation Tips
- Good experience
Selected
I applied via Referral and was interviewed in Jul 2023. There was 1 interview round.
(1 Question)
- Q1. They basically asked questions bordering on hr and introduced me to the role specifics
Interview Preparation Tips
- Who is an hr
- What is Headhunting
- What do you know about gao tek
Theeta Electricals Interview FAQs
Tell us how to improve this page.
Theeta Electricals Interviews By Designations
- Theeta Electricals Planning Engineer Interview Questions
- Theeta Electricals Senior Engineer Mechanical Interview Questions
- Theeta Electricals MIS Executive Interview Questions
- Theeta Electricals Senior Engineer Interview Questions
- Theeta Electricals Permanent job Life Time Interview Questions
- Theeta Electricals Production Manager Interview Questions
- Theeta Electricals Production Engineer Team Lead Interview Questions
- Theeta Electricals Senior Quality Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior MIS Executive Interview Questions
- MIS Executive and Analyst Interview Questions
- MIS Executive and Coordinator Interview Questions
- MIS and Back Office Executive Interview Questions
- Executive Interview Questions
- Sales Executive Interview Questions
- Senior Executive Interview Questions
- Accounts and MIS Executive Interview Questions
- Show more
Interview Questions from Similar Companies
Theeta Electricals MIS Executive Reviews and Ratings
based on 2 reviews
Rating in categories
|
Production Engineer
29
salaries
|  ₹1.8 L/yr - ₹4.8 L/yr |
|
Purchase Executive
14
salaries
| ₹2.2 L/yr - ₹4.2 L/yr |
|
Senior Production Engineer
11
salaries
| ₹3.2 L/yr - ₹4.8 L/yr |
|
Quality Engineer
8
salaries
| ₹2.5 L/yr - ₹4 L/yr |
|
Production Supervisor
6
salaries
| ₹1.8 L/yr - ₹2 L/yr |
GAO Tek
Amphenol Interconnect
Kyungshin Industrial Motherson
Electrical Research & Development Association
- Home >
- Interviews >
- Theeta Electricals Interview Questions >
- Theeta Electricals MIS Executive Interview Questions
