Arcesium Data Analyst Interview Questions and Answers

Q1. Wildcard in excel
Ans. 
Wildcard in Excel is a symbol used to represent one or more characters in a search string.
• Wildcards include * (asterisk) for multiple characters and ? (question mark) for a single character.

• Example: 'te*t' can match 'test' or 'text'.

• Wildcards are commonly used in functions like VLOOKUP and SUMIF.
Answered by AI
Add your answer

1 python question and 1 sql question for coding and rest were the mcqs based on sql and python.

Q1. Python code was asked for checking the anagrams
Add your answer
Q2. Sql code asked to solve on screen share using various use cases like group by, having, count
Add your answer

Q1. Python code was asked for swaping any number but without using python libraries
Add your answer
Q2. Sql code was asked using concepts of rank dense,rank, partition by
Add your answer

Q1. Basic to Intermediate SQL Based questions
Add your answer
Q2. Basic to Intermediate Python Based questions
Add your answer

Hackerra test with sql ,python coding and theory

Sql advanced coding round

Python basic coding test

Q1. General discussion
Add your answer