Filter interviews by
I appeared for an interview in Mar 2024.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for 'Vertical Lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
Conditional formatting is a feature in software applications that allows users to apply formatting rules to cells or data based on specified conditions.
Allows users to highlight important information
Can be used to visually represent data trends
Helps in quickly identifying outliers or exceptions
Commonly used in spreadsheet applications like Excel
A Pivot Table is a data summarization tool used in spreadsheet programs to reorganize and summarize selected columns and rows of data.
Allows users to extract significance from a large, detailed data set
Can group data by categories and display sums, averages, counts, or other statistics
Provides a dynamic way to analyze data without altering the original dataset
Commonly used in Excel, Google Sheets, and other spreadsheet
To create a sales report in a pivot table, you need to organize your sales data and use pivot table tools in Excel.
Organize your sales data with columns for product, sales amount, date, etc.
Select your data range and go to Insert > PivotTable in Excel.
Drag and drop fields like product and sales amount into Rows and Values section of the pivot table.
Apply filters, group data, and customize the layout to create a compreh...
Top trending discussions
A pizza delivery service's profit-loss is determined by the cost of ingredients, labor, and delivery expenses subtracted from revenue.
Revenue is generated by the sale of pizzas and any additional items such as drinks or sides
Cost of ingredients includes the cost of dough, sauce, cheese, and toppings
Labor costs include wages for delivery drivers and in-store staff
Delivery expenses include gas, insurance, and vehicle mai...
A graph showing the relationship between selling price and profits.
Create a scatter plot with profits on the x-axis and selling price on the y-axis
Use different colors or shapes to represent different products or time periods
Add a trendline to show the overall relationship between the variables
The credit card industry is highly competitive and constantly evolving, with companies offering various rewards and benefits to attract customers.
Credit card companies offer rewards and benefits to attract customers
The industry is highly competitive and constantly evolving
Credit card fraud is a major concern for both companies and customers
Regulations such as the CARD Act have impacted the industry
The COVID-19 pandemic...
I applied via Campus Placement
based on 1 interview
Interview experience
based on 1 review
Rating in categories
NOC Engineer
18
salaries
| ₹1.9 L/yr - ₹4 L/yr |
Assistant Manager
13
salaries
| ₹4 L/yr - ₹5.2 L/yr |
Network Engineer
13
salaries
| ₹2.2 L/yr - ₹4 L/yr |
Manager
7
salaries
| ₹7 L/yr - ₹10 L/yr |
Deputy Manager
7
salaries
| ₹7.2 L/yr - ₹9.3 L/yr |
Huawei Technologies
Z X Learning
Evision Technoserve
Cogoport