Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Feb 2021. There was 1 interview round.
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
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
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...
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
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...
Top trending discussions
I was interviewed in Aug 2024.
I was interviewed in Aug 2024.
I was interviewed before Jan 2024.
posted on 23 Nov 2023
I applied via Walk-in and was interviewed in Oct 2023. There were 2 interview rounds.
I am a highly motivated and results-driven sales executive with a proven track record of exceeding targets.
Experienced in building and maintaining strong client relationships
Skilled in identifying and capitalizing on sales opportunities
Proficient in sales techniques and negotiation strategies
Excellent communication and presentation skills
Consistently achieved or surpassed sales quotas
Implemented successful sales strate...
Apple is a multinational technology company known for its innovative products like iPhone, iPad, Mac, and Apple Watch.
Apple is known for its user-friendly and sleek design.
They have a wide range of products including smartphones, tablets, computers, and wearables.
Apple products are known for their high-quality hardware and software integration.
They have a strong ecosystem with services like iCloud, App Store, and Apple...
Yes, I will be able to commute daily.
I have reliable transportation and can commute to work every day.
I am comfortable with the distance and travel time required for the commute.
I have successfully commuted daily in previous roles.
I am willing to adjust my schedule if needed to accommodate the commute.
I understand the importance of being punctual and reliable in a sales role.
posted on 14 Apr 2021
I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 3 interview rounds.
I applied via Referral and was interviewed before Jul 2020. There was 1 interview round.
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...
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...
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...
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
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
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...
based on 2 reviews
Rating in categories
Production Engineer
26
salaries
| ₹2.3 L/yr - ₹4 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 |
ABB
Siemens
Schneider Electric
Havells