Filter interviews by
Excel is a spreadsheet program by Microsoft that allows users to perform calculations, analyze data, and create visualizations.
Excel uses formulas to perform calculations on data
Formulas start with an equal sign (=)
Common functions include SUM, AVERAGE, IF, VLOOKUP
Examples: =SUM(A1:A10), =IF(B1>10, 'Yes', 'No')
Excel Google Sheet Query Function allows users to retrieve data from a Google Sheet using SQL-like syntax.
The function starts with =QUERY()
Users can specify the data range to query
Users can use SQL-like syntax to filter, sort, and manipulate data
The function can be used to create dynamic reports and dashboards
Excel Google Sheet Query Function allows users to retrieve and manipulate data from a Google Sheet using SQL-like syntax.
The Query function can be used to filter, sort, and aggregate data from a Google Sheet.
It supports SQL-like syntax, including SELECT, WHERE, ORDER BY, and GROUP BY clauses.
Example: =QUERY(A1:B10, "SELECT A, SUM(B) WHERE A <> '' GROUP BY A ORDER BY A")
The Query function can also be used to join data f...
Top trending discussions
I was interviewed in Jan 2025.
I was interviewed in Jan 2025.
I was interviewed in Jan 2025.
I was interviewed in Jan 2025.
I was interviewed in Jan 2025.
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
based on 1 interview
Interview experience
based on 13 reviews
Rating in categories
Assistant Manager
4
salaries
| ₹2 L/yr - ₹5.5 L/yr |
Web Designer
4
salaries
| ₹1.1 L/yr - ₹3 L/yr |
Business Development Executive
4
salaries
| ₹3 L/yr - ₹3 L/yr |
Team Lead
4
salaries
| ₹3.8 L/yr - ₹9 L/yr |
Data Analyst
3
salaries
| ₹5.5 L/yr - ₹8.2 L/yr |
TCS
Accenture
Wipro
Cognizant