CARS24 Junior Associate Interview Questions and Answers

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

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

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")

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

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_

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

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.

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

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

I am passionate about the company's mission and values, and I believe my skills and experience align well with the opportunities for growth and development here.

• I am impressed by the company's innovative approach to solving industry challenges

• I admire the company's commitment to sustainability and community involvement

• I see great potential for career advancement and learning opportunities within the company

I am impressed by the company's innovative approach and strong reputation in the industry.

• Company's innovative approach aligns with my career goals

• Strong reputation in the industry indicates stability and growth opportunities

• Excited about the chance to work with talented professionals