Loginworks Softwares Associate Data Analyst Interview Questions, Process, and Tips

vlookup is a function in Excel used to search for a specific value in a table and return a corresponding value from another column.

• vlookup stands for 'vertical lookup'

• It requires a lookup value, a table array, column index number, and an optional range lookup value

• It can only search for values in the leftmost column of the table array

• It returns the first matching value found, so it may not be accurate if there are dupl...read more

Query to find rows beginning with a letter in SQL

• Use the LIKE operator with the pattern '[letter]%'

• Replace [letter] with the desired letter

• Enclose the pattern in single quotes

• Example: SELECT * FROM table_name WHERE column_name LIKE 'A%'

To find duplicates in Excel, use the conditional formatting feature or the Remove Duplicates tool.

• Select the range of cells where you want to find duplicates

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Select 'Highlight Cells Rules' and then 'Duplicate Values'

• Choose the formatting style and click 'OK'

• Alternatively, go to the 'Data' tab and click on 'Remove Duplicates'

• Select the columns where you want to fi

Query to find duplicates in SQL

• Use GROUP BY clause to group the columns that may have duplicates

• Use HAVING clause to filter the groups that have more than one row

• Use COUNT() function to count the number of rows in each group