i
Collegedunia
Filter interviews by
I appeared for an interview in Mar 2023.
Q- conditional formatting
Q- alter query of sql
Q- html tags
Q-vlookup question
Q-which is good vlookup or indexmatch
Q- countif function
Q- create view in sql
Q- problem solving question
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
Alt + Down Arrow
Press Alt key and Down Arrow key simultaneously
Shortcut key is used to open the filter drop-down menu for pivot tables
Can be used to quickly filter data in pivot tables
Syntax for copying data from one table to another in SQL
Use INSERT INTO statement with SELECT subquery
Specify the source table and columns in SELECT subquery
Specify the destination table and columns in INSERT INTO statement
Vlookup searches for a value in the first column of a table and returns a corresponding value in the same row. Index match uses the index function to find a value in a table and match function to return a corresponding value in the same row.
Vlookup only works from left to right, while Index match can work in any direction.
Index match is more flexible and efficient for large datasets.
Index match can handle errors better...
The shortcut key for pivot table is Alt + D + P.
Press Alt key and then press D and P keys in sequence to create a pivot table.
This shortcut works in Microsoft Excel.
Pivot tables are used to summarize and analyze large amounts of data.
Top trending discussions
I applied via Approached by Company and was interviewed before Jun 2021. There were 2 interview rounds.
Knowledge of excel and team handling
I applied via Walk-in and was interviewed in May 2020. There was 1 interview round.
I applied via Approached by Company and was interviewed before Jul 2021. There was 1 interview round.
I applied via Walk-in and was interviewed in Aug 2020. There was 1 interview round.
I applied via Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.
I applied via Job Fair
based on 1 interview
Interview experience
based on 12 reviews
Rating in categories
Business Development Manager
241
salaries
| ₹3 L/yr - ₹12.8 L/yr |
Content Writer
180
salaries
| ₹1 L/yr - ₹6.5 L/yr |
Operations Analyst
114
salaries
| ₹2 L/yr - ₹7 L/yr |
Business Analyst
96
salaries
| ₹2.2 L/yr - ₹11.5 L/yr |
Data Analyst
87
salaries
| ₹2 L/yr - ₹9 L/yr |
Udaan
Swiggy
BlackBuck
Ninjacart