Filter interviews by
Ms Excel formulas lookups are used to search for specific data in a range of cells and return corresponding values.
VLOOKUP function is used to search for a value in the first column of a range and return a value in the same row from a specified column.
HLOOKUP function is similar to VLOOKUP but searches for a value in the first row of a range and returns a value in the same column from a specified row.
INDEX and MATCH fu...
Creating a sheet with Microsoft Excel
Open Microsoft Excel
Click on 'Blank Workbook' to create a new sheet
Enter data into cells
Format cells as needed (e.g. currency, date)
Save the sheet by clicking 'File' > 'Save As' and choosing a location
Top trending discussions
I applied via Approached by company and was interviewed in Aug 2021. There were 2 interview rounds.
Quant focussed Case Study (be prepared for calculations)
I applied via Company Website and was interviewed before Oct 2020. There was 1 interview round.
I appeared for an interview in Mar 2017.
To make the red fishes 98%, 50 fishes have to be removed from the aquarium.
Calculate 1% of 200 fishes, which is 2 fishes.
To make the red fishes 98%, subtract 1% (2 fishes) from 99% (198 fishes).
To find the number of fishes to be removed, divide the difference by 1% (2 fishes).
Therefore, 50 fishes have to be removed to make the red fishes 98%.
I appeared for an interview in Feb 2017.
I appeared for an interview in Mar 2017.
To make the red fishes 98%, 50 fishes have to be removed from the aquarium.
Calculate 1% of 200 fishes to find the number of red fishes.
Subtract the number of red fishes from 200 to find the number of non-red fishes.
Calculate 2% of the total number of fishes to find the desired number of red fishes.
Subtract the desired number of red fishes from the current number of red fishes to find the number of fishes to be removed.
based on 1 interview
Interview experience
based on 25 reviews
Rating in categories
Relationship Manager
7
salaries
| ₹1.9 L/yr - ₹4 L/yr |
Accounts Manager
6
salaries
| ₹3.2 L/yr - ₹7 L/yr |
Workshop Manager
5
salaries
| ₹2 L/yr - ₹5 L/yr |
Sales Executive
4
salaries
| ₹1 L/yr - ₹3.2 L/yr |
Service Advisor
4
salaries
| ₹2.2 L/yr - ₹2.8 L/yr |
Huawei Technologies
Z X Learning
Evision Technoserve
Cogoport