Skip to content
Skills
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Home
/
Data Analyst
/
Questions
/
Conditional Functions
Data Analyst
Conditional Functions questions
9 questions on Conditional Functions for data analysts, easiest first.
Easy
1
Counting orders above ₹50,000
easy
Medium
3
COUNTIF with the limit in a cell
medium
Counting names that contain a word
medium
Highest sale in one region
medium
Hard
5
SUMIF adds the wrong rows
hard
COUNTIF finds duplicates that are not
hard
Summing two regions in one SUMIFS
hard
Counting codes with exact case
hard
Monthly total from a date column
hard
