Cresce Technology Private Limited MIS Executive Interview Questions, Process, and Tips

Q1. What is filter formula
Ans. 
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...read more
Answered by AI
Add your answer
Q2. What is use sumif formula
Ans. 
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 ...read more
Answered by AI
Add your answer
Q3. What is xlookup formula
Ans. 
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...read more
Answered by AI
Add your answer
Q4. What is if function
Ans. 
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...read more
Answered by AI
Add your answer

Overall 12 question

Q1. Department head discussion
Add your answer

Analytics team discussion