DXC Technology Analyst II Interview Questions and Answers

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Q1. What is DNS, HTTP/s, TLS, SSL?
Add your answer
Q2. What is the latest for HTML, CSS, and JS?
Add your answer

Q1. What are the latest features in ES10?
Add your answer
Q2. What is the difference between async and promises?
Add your answer
Q3. Why everything is a object in JavaScript
Add your answer

Q1. Hierarchy of filters in tableau
Ans. 
In Tableau, the hierarchy of filters determines the order in which filters are applied to the data.
• Filters are applied in the order they appear in the Filter Shelf.

• Context filters are applied first, then dimension filters, and finally measure filters.

• Filters can be set to apply to all worksheets or only specific worksheets.

• Example: If a context filter is applied to a dimension, it will filter the data before any other
Answered by AI
Add your answer
Q2. What are Parameter actions
Ans. 
Parameter actions allow users to dynamically change parameter values in Tableau dashboards.
• Parameter actions enable users to interact with dashboard parameters by clicking on marks or selecting values.

• They can be used to filter data, highlight specific information, or drive calculations.

• For example, a user can click on a bar chart to update a parameter value and see corresponding changes in other visualizations.
Answered by AI
Add your answer
Q3. How to toggle between pages
Ans. 
To toggle between pages, use navigation buttons, links, or keyboard shortcuts.
• Use navigation buttons like 'Next' and 'Previous'

• Click on links or tabs to switch between pages

• Use keyboard shortcuts like Ctrl + Tab to toggle between open tabs
Answered by AI
Add your answer

Q1. Why did you choose Genpact
Ans. 
I chose Genpact for its reputation in the industry and opportunities for growth.
• Genpact has a strong reputation in the industry for providing innovative solutions to clients.

• The company offers a wide range of opportunities for career growth and development.

• I was impressed by Genpact's focus on continuous learning and development for its employees.
Answered by AI
Add your answer

Q1. Offer negotiation
Add your answer

Q1. Which is the best level in Wipro? Ans:Now Wipro has introduced quarterly appraisal system.
Add your answer
Q2. What is the process of Wipro ? Ans: Wipro,a global information technology, consulting,and business process service company.
Add your answer

Can you recommend any free website for taking an online carrier aptitude test and recieving a detailed report on sutaible job options.

What is the best resource to learn data structure and algorithm(must contain practice assignments too)? I have stumbled across Coursera,but does it cover all essential details about DSA?

Q1. What is technical? Ans: Defination must be able to apply the technical knowledge and skills required in the specialist and professional job role.
Add your answer

It's easy just be yourself

Q1. Tell me about yourself
Add your answer
Q2. About core Java and oops concept
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What are your strengths and weakness
Ans. 
Strengths: Strong problem-solving skills, attention to detail, quick learner. Weakness: Sometimes too focused on perfection.
• Strength: Strong problem-solving skills - able to analyze complex problems and come up with effective solutions

• Strength: Attention to detail - ensures accuracy in coding and testing

• Strength: Quick learner - able to quickly adapt to new technologies and languages

• Weakness: Sometimes too focused on p...read more
Answered by AI
Add your answer