Filter interviews by
SUMIF function in Excel adds up values based on a given condition.
SUMIF function syntax: =SUMIF(range, criteria, [sum_range])
Example: =SUMIF(A1:A10, ">10", B1:B10) will sum values in B1:B10 where corresponding value in A1:A10 is greater than 10
Criteria can be a number, expression, or text
Sum_range is optional and if omitted, the range is used for both sum and criteria
COUNTIF is a function in Excel used to count cells that meet a specific criteria.
COUNTIF(range, criteria) is the syntax for the function.
Range is the range of cells you want to apply the criteria to.
Criteria is the condition that must be met for a cell to be counted.
Example: =COUNTIF(A1:A10, ">10") will count the number of cells in range A1:A10 that are greater than 10.
Top trending discussions
Related to codeing
Mathematical question
It will be a group case study with 3-4 questions to be answered
I applied via Company Website and was interviewed in Sep 2023. There was 1 interview round.
Medium to Hard 4 DSA questions
I applied via Company Website and was interviewed in May 2023. There were 4 interview rounds.
Basic excel, Reasoning, English Grammar
I applied via Campus Placement and was interviewed before Jun 2023. There were 3 interview rounds.
The aptitude test involved a written test and video round.
The group discussion round had the topic related to semiconductor chip shortage globally post COVID
Financial metrics in Automotive industry include revenue, profit margin, return on assets, and inventory turnover.
Revenue: Total income generated from selling vehicles, parts, and services.
Profit margin: Ratio of net income to revenue, indicating efficiency in cost management.
Return on assets: Measure of how effectively assets are used to generate profit.
Inventory turnover: Number of times inventory is sold and replace...
Greening of supply chain refers to implementing sustainable practices to reduce environmental impact.
Implementing eco-friendly packaging materials
Reducing carbon emissions through efficient transportation
Sourcing materials from sustainable suppliers
Implementing recycling and waste reduction programs
Using renewable energy sources in operations
I applied via Approached by Company and was interviewed in Jun 2022. There were 5 interview rounds.
The question asks about calculating cumulative sum of an array and frequency of each word in a sentence.
To calculate cumulative sum of an array, we can use a loop and keep adding the current element to a running sum variable.
To calculate frequency of each word in a sentence, we can split the sentence into words and use a dictionary to keep track of the count of each word.
We can use built-in functions in programming lan...
I applied via Naukri.com and was interviewed before Jan 2024. There were 2 interview rounds.
Simple aptitude test questions
Assignment was given to conduct market research
Interview experience
based on 7 reviews
Rating in categories
Research Analyst
20
salaries
| ₹1.8 L/yr - ₹5.1 L/yr |
MIS Executive
16
salaries
| ₹3.6 L/yr - ₹6 L/yr |
Senior Research Analyst
7
salaries
| ₹3 L/yr - ₹4.4 L/yr |
Quality Analyst
4
salaries
| ₹3 L/yr - ₹3.8 L/yr |
Team Lead Operations
4
salaries
| ₹5 L/yr - ₹6.5 L/yr |
WATConsult
Dentsu Webchutney
Interactive Avenues
Isobar