i
Filter interviews by
A filter formula is a formula used to specify criteria for filtering data in a spreadsheet or database.
Filter formulas are used to extract specific data from a larger dataset based on certain conditions.
They can be used in various applications such as Excel, Google Sheets, and SQL databases.
Filter formulas typically involve logical operators (e.g., equals, greater than, less than) and functions (e.g., COUNTIF, SUMIF) t...
SUMIF is a formula in Excel used to calculate the sum of values in a range based on specified criteria.
SUMIF formula is used to add up values in a range that meet a given condition.
It takes three arguments: range, criteria, and sum_range.
The range is the set of cells to be evaluated, criteria defines the condition, and sum_range is the range to be summed.
For example, =SUMIF(A1:A10, ">5", B1:B10) will sum the values in ...
XLOOKUP is a formula in Excel that allows you to search for a value in a range and return a corresponding value from another range.
XLOOKUP is a powerful alternative to VLOOKUP and HLOOKUP formulas.
It can perform both vertical and horizontal lookups.
XLOOKUP can search for values in multiple columns or rows.
It can handle both exact and approximate matches.
XLOOKUP supports wildcard characters and can handle errors more ef...
The IF function is a logical function in Excel that allows you to perform different actions based on a specified condition.
The IF function checks if a condition is true or false and returns different values or performs different actions accordingly.
It has three arguments: the condition to be tested, the value to be returned if the condition is true, and the value to be returned if the condition is false.
Example: =IF(A1...
Overall 12 question
Analytics team discussion
Top trending discussions
Always be confident and make an effort to listen before you speak.
I applied via Campus Placement and was interviewed in Oct 2022. There were 2 interview rounds.
Easy questions of basic maths.
I appeared for an interview in Aug 2021.
Accounting is the process of recording, classifying, and summarizing financial transactions to provide information that is useful in making business decisions. Inventory refers to the goods and materials that a business holds for the ultimate purpose of resale.
Accounting involves keeping track of financial transactions such as sales, purchases, and expenses
Inventory management involves tracking the quantity and value o...
A bill is a request for payment, while an invoice is a detailed record of a transaction.
A bill is typically sent before payment is due, while an invoice is sent after a transaction has occurred.
A bill may include a summary of charges, while an invoice provides a detailed breakdown of the goods or services provided.
Invoices are often used for accounting and tax purposes, while bills are more commonly used in everyday tr...
To productinize Data Pipelines, one must automate, monitor, and scale the pipeline for efficient and reliable data processing.
Automate the data pipeline using tools like Apache Airflow or Kubernetes
Monitor the pipeline for errors, latency, and data quality issues using monitoring tools like Prometheus or Grafana
Scale the pipeline by optimizing code, using distributed computing frameworks like Spark, and leveraging clou...
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data.
BigQuery uses a distributed architecture to process and analyze large datasets quickly.
It allows users to run SQL-like queries on datasets stored in Google Cloud Storage.
BigQuery automatically scales to handle large amounts of data and can be integrated with other Google Cloud services.
It supports real-time data...
I applied via Campus Placement and was interviewed in Jul 2022. There was 1 interview round.
I applied via Naukri.com and was interviewed in Oct 2022. There were 4 interview rounds.
There'll be 10 questions have to write 5 correctly
There are four types of GST in India - CGST, SGST, IGST, and UTGST. They are used for different types of transactions.
CGST is levied by the central government on intra-state transactions
SGST is levied by the state government on intra-state transactions
IGST is levied by the central government on inter-state transactions
UTGST is levied by the union territories on intra-state transactions
GST is used to replace multiple in...
Some maths question duration 30 min
I applied via AmbitionBox and was interviewed in Sep 2023. There was 1 interview round.
Vyapar in marketing refers to the process of conducting business or trade.
Vyapar involves buying and selling goods or services.
It includes activities such as advertising, promotion, and distribution.
Vyapar aims to attract customers and generate revenue for the business.
Examples of vyapar in marketing include running social media campaigns, participating in trade shows, and offering discounts to customers.
based on 1 interview experience
Inside Sales Associate
9
salaries
| ₹2.9 L/yr - ₹4.3 L/yr |
Business Consultant
7
salaries
| ₹3 L/yr - ₹6 L/yr |
Senior Business Consultant
6
salaries
| ₹3.3 L/yr - ₹4.1 L/yr |
Team Lead
4
salaries
| ₹5.5 L/yr - ₹6.5 L/yr |
Assistant Area Sales Manager
4
salaries
| ₹6.5 L/yr - ₹7 L/yr |
Vyapar
Nowfloats Technologies
ShopKirana
Tata nexarc