Analyst

HR is responsible for the basic training of all new hires. Below is a table that gives a training status for all the new hires.
Using Excel formulae, find out the following:
1. How many have neither registered nor completed any of the 3 courses?
2. How many have registered or trained in at least 2 of the 3 courses?
3. How many have not been trained in any of the 3 yet?

Below in Column 2 there are some numbers given:
Please calculate sum of numbers based on the criteria given in the start row number and end row number
Formula should be capable enough, if we change start row number and end row number sum will get update

Based on the data in the table below, please answer the following questions using excel functions
1. Number of employees from the Sales deparment who joined before July 2006 and have a total experience (prior and present) of more than 10 years?
2. Total Number of years of experience of employees in the Sales department who joined before 31 Mar 2009?

Fill this multiplication table with just one formula and copy past the same in all the red cells.

1. Please Map area sales manager name into column C from Table given in Column F and G
2. In Column J extract first name of area sales manager from column G

What is the difference between Primary Key and Foreign Key?

What are the different types of JOIN in SQL?

Explain the difference between left outer join and right outer join?

Write a query to find the names of employees that begin with ‘S’

Write a query to retrieve two minimum and maximum salaries from the EmployeePosition table.

Write a query to find the Nth highest salary from the table

Write an SQL query to fetch all those employees who work on Projects other than project Q.

Can you give your brief introduction?

Will you be able to relocate to the base position, i.e., Bangalore, if required?

Where do you see yourself after 5 years?