Excel Interview Questions
2 min readDec 1, 2023
- In today’s article, we’ll delve into some of the most frequently asked Excel interview questions and provide you with detailed answers to help you ace your interview. Whether you’re a beginner eager to learn MS Excel or a seasoned professional looking to enhance your skills in 2024, this guide has something valuable for everyone. Let’s get started!
Table of Contents
- Merging Columns with CONCATENATE and TextJoin
- Splitting Full Names into First and Last Names
- Freezing Rows for Easy Data Navigation
- Protecting Worksheets from Unwanted Changes
- Handling VLOOKUP Errors with Absolute References
- Finding the Sum of Scores with SUMIF
- Highlighting Values with Conditional Formatting
- Using Wildcards in Excel Functions
- Handling Hash Ref Errors
- Making Informed Decisions with Pivot Tables
- Preparing for Excel-Related Interviews
Merging Columns with Concatenate and TextJoin
Q: I have 3 columns called ‘First Name’, ‘Last Name’, and ‘Profession’ name. How do I merge these 3 and create a new column called, ‘full name’?
Answer:
You can achieve this by using functions like CONCATENATE and TEXTJOIN.
CONCATENATE simply combines values without a delimiter, while TEXTJOIN allows you to specify a delimiter, making it more versatile.
