Licious Junior Qa Executive Interview Questions and Answers

Q1. Excell regarding and Insurance Motor & some none motor
Add your answer

Q1. As per same question and regarding salary benefits
Add your answer

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

Q1. Tell me about your self
Add your answer
Q2. Document all needed
Add your answer

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

Q1. About salary discuss & about company
Add your answer
Q2. About facilities & working background
Add your answer

Q1. Do you understand the engineering drawings, Preparing of BBS,Quantity Estimation
Ans. 
Yes
• Yes, I understand engineering drawings and can interpret them accurately.

• Yes, I am proficient in preparing Bar Bending Schedules (BBS) for reinforcement detailing.

• Yes, I have experience in quantity estimation for construction projects.

• Yes, I am familiar with relevant software and tools used for these tasks.

• Yes, I can provide examples of projects where I have successfully performed these tasks.
Answered by AI
View 4 more answers
Q2. Mix grade ration of concrete.
Ans. 
Mix grade ratio of concrete refers to the proportion of cement, sand, and aggregate used in the concrete mix.
• The mix grade ratio of concrete is expressed as the proportion of cement to sand to aggregate.

• The most common mix grade ratios for concrete are 1:2:3 and 1:3:6.

• The mix grade ratio of concrete depends on the strength and durability required for the specific project.

• The mix grade ratio of concrete can be adjusted ...read more
Answered by AI
Add your answer
Q3. How to perform a cube test.
Ans. 
Cube test is performed to determine the compressive strength of concrete.
• Prepare the cube moulds of size 150mm x 150mm x 150mm.

• Clean the moulds and apply oil to the inner surface.

• Fill the moulds with concrete in three layers and compact each layer.

• Level the top surface and cover the moulds with a gunny bag.

• After 24 hours, remove the moulds and immerse the cubes in water for curing.

• After 7 days, test the cubes for compr...read more
Answered by AI
Add your answer

Q1. What is your Salary expectation
Add your answer
Q2. Why you leaving your current company
Add your answer