Digit Insurance Junior Associate Interview Questions, Process, and Tips

Q1. How to apply vlookup in excel sheet
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
• Select the cell where you want the result to appear

• Type =VLOOKUP(

• Enter the value you want to search for

• Select the range of cells where the value is located

• Enter the column number containing the value you want to return

• Enter FALSE for an exact match or TRUE for an approximate match
Answered by AI
Add your answer
Q2. What is use of pivot table in excel
Ans. 
Pivot tables in Excel are used to summarize and analyze large amounts of data in a spreadsheet.
• Pivot tables help in organizing and summarizing data from a larger table.

• They allow users to reorganize and summarize selected columns and rows of data.

• Users can easily create reports and analyze trends using pivot tables.

• Pivot tables can also be used to perform calculations and apply filters to data.

• For example, you can use ...read more
Answered by AI
Add your answer
Q3. What is use of sumifs in excel
Ans. 
SUMIFS function in Excel is used to sum values based on multiple criteria.
• SUMIFS function syntax: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

• Can be used to sum values based on multiple conditions

• Criteria can be text, numbers, dates, logical expressions, etc.

• Example: =SUMIFS(B2:B10, A2:A10, "Apples", C2:C10, ">10")
Answered by AI
Add your answer
Q4. What is use of if and ifs formula in excel
Ans. 
IF and IFs formulas in Excel are used for logical tests and conditional statements to perform different actions based on specified criteria.
• IF formula is used to perform a logical test and return one value if the condition is met, and another value if the condition is not met.

• IFs formula is used to perform multiple logical tests and return a value that corresponds to the first TRUE result.

• Examples: =IF(A1>10, 'Yes',...read more
Answered by AI
Add your answer
Q5. How to apply XLOOKUP in excel
Ans. 
XLOOKUP is a powerful function in Excel used to search for and return values in a range or array.
• XLOOKUP can be used to search for a value in a column or row and return a corresponding value from the same position in another column or row.

• It can handle both vertical and horizontal lookups, as well as return an array of results.

• XLOOKUP can also handle approximate matches and wildcard characters.

• Example: =XLOOKUP(lookup_
Answered by AI
Add your answer
Q6. How do you run any query in SQL
Ans. 
To run a query in SQL, use the SELECT statement followed by the columns you want to retrieve from a specific table.
• Start by writing the SELECT keyword followed by the column names you want to retrieve

• Specify the table you want to query from using the FROM keyword

• Add any additional conditions using the WHERE clause

• You can also use functions like COUNT, SUM, AVG, etc. for calculations

• End the query with a semicolon to exe
Answered by AI
Add your answer

Interview taking in non tech job by the Zonal manager, & Associate Manager according to the submitted CV and previous work experience.